JSON to CSV
Convert JSON arrays and nested objects into clean, downloadable CSV spreadsheets in seconds. · Updated
JSON to CSV turns API arrays into spreadsheet-ready tables. Client-side flattening keeps customer records off remote converters while you prepare exports.
Common errors and fixes
Input must be a JSON array
Wrap objects in [{...}] or enable flattening for nested records.
Unexpected token
Fix JSON syntax first with the JSON Formatter, then convert.
Empty array
Provide at least one object so column headers can be inferred.
Nested object not flattened
Enable Flatten nested objects to expand address.city-style columns.
Options
| Option | Description |
|---|---|
| Delimiter | Select the field separator character for your output spreadsheet. |
| Flatten nested objects | Expands nested JSON properties into dot-notation column names (e.g. address.city). |
| Include column header | Adds the first row containing column names in the CSV output. |
| Quote all fields | Forces double quotes around every cell value instead of only fields containing commas. |
FAQ
How does JSON to CSV handle nested objects?
When 'Flatten nested objects' is enabled, nested properties are converted into dot-notation column headers like user.address.city.
Can I convert a single JSON object rather than an array?
Yes. Single objects are converted into a single-row CSV table with all object keys as headers.
How are nested arrays handled?
Nested array values are serialized into JSON strings inside their corresponding table cell.
Can I open the generated CSV in Microsoft Excel or Google Sheets?
Yes. Standard comma-delimited CSVs open directly in Excel, Numbers, and Google Sheets without any additional formatting.