Convert JSON to CSV
More data converters: JSON to Excel · CSV to JSON · Excel to JSON · XML to JSON · JSON to XML · XML to Excel · YAML to JSON · JSON Formatter
How to Convert JSON to CSV
A list of objects, an API response or a JSON Lines file. Click Example to try it.
Comma for most programs, semicolon for Excel in countries that write decimals with a comma.
Copy the CSV straight into another program, or download it as a .csv file.
Getting a CSV that opens correctly
Which separator to choose
| Separator | Use it when |
|---|---|
| Comma | The standard. Google Sheets, databases, Python, R and Excel in English-speaking countries. |
| Semicolon | Excel in most of Europe, where the comma is the decimal mark. Double-clicking a comma CSV there puts everything in column A. |
| Tab | Data that itself contains many commas and semicolons, or pasting into a spreadsheet. |
- Excel-friendly (UTF-8 BOM) adds an invisible marker at the start of the file. Without it, Excel on Windows can show letters such as š, đ or é as garbled characters. Programs other than Excel ignore it; turn it off only if a system rejects it.
- Quoting follows the CSV standard (RFC 4180): a value that contains the separator, a quote or a line break is wrapped in quotes, and quotes inside it are doubled.
- Nested objects become columns such as
address.city. Lists of simple values go into one cell separated by commas, or intotags.1,tags.2columns if you choose "One column per item". - Different fields per record are fine: every field gets a column, and records without it get an empty value.
- Several lists in one JSON? Choose which one becomes the rows in the Rows from menu.
Going the other way? Use CSV to JSON. For a spreadsheet with real number columns, use JSON to Excel.
Frequently Asked Questions
Is the JSON sent to your server?
No. The conversion is done in your browser and the CSV is created on your device. Nothing is uploaded or stored.
Why does Excel put all my data in one column?
Your Excel expects semicolons because your region uses a comma as the decimal mark. Choose Semicolon as the separator and download again.
Why are letters like š or é broken in Excel?
Excel needs the UTF-8 marker (BOM) to read such letters correctly. Keep "Excel-friendly (UTF-8 BOM)" switched on.
Can I convert nested JSON?
Yes. Nested objects are flattened into columns with dotted names, and lists are either joined in one cell or split into numbered columns.