What Is a JSON to CSV Converter?
A JSON to CSV converter transforms JSON data, usually an array of objects returned by an API, database or app, into CSV (comma-separated values), the tabular format understood by Excel, Google Sheets, Numbers, Power BI and virtually every data tool. Each JSON object becomes a row, and each key becomes a column.
Real-world JSON is rarely flat. Objects contain nested objects and arrays, and records don't always share the same keys. This converter flattens nested structures into dotted column names such as address.city, merges every key it finds into a complete header row, and escapes values correctly so the CSV opens cleanly in any spreadsheet.
How to Convert JSON to CSV
- Paste or upload JSON. Enter a JSON array or object, or drop a .json file.
- Pick CSV options. Choose the delimiter, nested key separator, header row and quoting.
- Check the output. The CSV updates live, with a row count and file size.
- Download for Excel. Save as .csv. Enable "Add BOM" and CRLF for best compatibility with Microsoft Excel.
Features
- Automatic flatteningNested objects become columns such as
user.address.city. - Handles missing keysAll keys across all records are merged, and missing values are left blank.
- Arrays preservedSimple arrays are joined with semicolons, and arrays of objects get indexed columns.
- Proper escapingValues with delimiters, quotes or line breaks are quoted per RFC 4180.
- Excel-friendlyOptional UTF-8 BOM and Windows line endings keep accents and emoji intact in Excel.
- Finds your dataIf the JSON is an object wrapping an array (like
{"data": [...]}), the array is detected automatically.
Example
This JSON input:
[{"name": "Alice", "address": {"city": "London", "zip": "E1"}, "tags": ["admin", "dev"]}]
becomes this CSV:
name,address.city,address.zip,tags
Alice,London,E1,admin; dev
When to Convert JSON to CSV
- Analysing API responses in Excel, Google Sheets or a BI tool.
- Exporting data from MongoDB, Firebase or other NoSQL databases for reporting.
- Sharing structured data with non-technical colleagues who prefer spreadsheets.
- Importing data into CRMs, email platforms and e-commerce systems that accept CSV uploads.
How Nested JSON Is Flattened
CSV is two-dimensional, with rows and columns, while JSON can be nested to any depth. To bridge the gap, the converter follows a few predictable rules:
| JSON structure | CSV result |
|---|---|
Nested object {"user": {"name": "Al"}} | Column user.name |
Array of simple values ["a", "b"] | One cell: a; b |
Array of objects [{"sku": 1}, {"sku": 2}] | Columns items.0.sku, items.1.sku |
| Missing key in some records | Empty cell |
null | Empty cell |
Choose the separator (dot, underscore or slash) to match the column naming your target system expects. To turn the CSV back into nested JSON later, use our CSV to JSON converter with "Nested objects from dot headers" enabled.
Converting API Responses Step by Step
- Open the API URL in your browser or tool such as Postman, or copy the response from your browser's developer tools (Network tab → Response).
- Paste the JSON here. If the records sit inside a wrapper like
{"data": [...]}, the array is found automatically. - Check the header row in the output to make sure all fields you need are present as columns.
- Download the CSV and open it in your spreadsheet, BI tool or database importer.
Opening the CSV in Excel and Google Sheets
- Excel on Windows: enable the UTF-8 BOM and CRLF line endings, then double-click the file. Accented characters and emoji display correctly.
- Excel in European locales: choose the semicolon delimiter, because Excel expects semicolons when the comma is the decimal separator.
- Google Sheets: use File → Import → Upload. Sheets detects the delimiter automatically.
Frequently Asked Questions
Can I keep nested objects as JSON text in one cell?
Yes. Untick "Flatten nested objects", and any nested object or array is written into a single cell as compact JSON text.
Is there a limit on JSON size?
No fixed limit. Several megabytes of JSON with thousands of records convert in about a second on a typical device.
Can I convert a single JSON object (not an array)?
Yes. A single object becomes one CSV row. If the object contains an array of records, such as {"results": [...]}, that array is detected and converted automatically.
Can this tool convert nested JSON to CSV?
Yes. With "Flatten nested objects" enabled, nested properties become separate columns using dot notation, so nothing is lost.
Why do accented characters look wrong in Excel?
Older versions of Excel assume a legacy encoding for CSV files. Enable "Add BOM for Excel" before downloading, and Excel will read the file as UTF-8 correctly.
What if my records have different fields?
The converter collects every key from every object into the header, and fills missing values with empty cells.
Is my JSON uploaded?
No. Everything is processed locally in your browser.