JSON to CSV Converter
Convert a JSON array to CSV online, with nested objects flattened into columns. Convert CSV back to JSON too, then download the file. Private and free.
Turn a JSON array into a spreadsheet
API responses and database exports usually arrive as JSON, but the people who need the numbers often work in Excel or Google Sheets. This converter takes a JSON array of objects and produces CSV with one row per object and one column per key. It also works in reverse, so you can turn a CSV export into a JSON array.
Columns are collected from every object, not only the first. If one record has an extra field, it still gets a column, and records without that field get an empty cell.
Steps and options
- Paste a JSON array, or open a
.jsonfile. - Keep Flatten nested objects on to turn
address.cityinto its own column. - Choose a comma, semicolon, tab or pipe delimiter. Semicolons suit regions where Excel uses a comma as the decimal mark.
- Download the result as a
.csvfile or copy it to the clipboard.
Example with a nested object
The nested address fields become dotted column names. The comma inside the second name is safe, because that value is wrapped in quotes as RFC 4180 requires.
[
{ "id": 1, "name": "Asha", "address": { "city": "Pune" } },
{ "id": 2, "name": "Ravi, Jr.", "address": { "city": "Delhi" } }
]
id,name,address.city
1,Asha,Pune
2,"Ravi, Jr.",DelhiCommon problems when opening CSV in Excel
CSV has no data types, so spreadsheet programs guess them when a file opens. That can quietly damage values if you are not careful.
- Long IDs may be shown in scientific notation. Import the column as text rather than double-clicking the file.
- Postal codes such as
011001can lose their leading zero in the same way. - All the columns may land in one cell when your Excel expects a different delimiter. Try the semicolon option.
Frequently Asked Questions
What JSON shape does the converter need?
An array of objects works best, such as [{"a":1},{"a":2}]. Each object becomes a row and each key becomes a column.
How are nested arrays handled?
Nested objects are flattened into dotted columns. Arrays inside a record are kept as JSON text in a single cell, so no data is lost.
Can I convert CSV back to JSON here?
Yes. Use the CSV to JSON tab or the swap button. Our dedicated CSV to JSON page offers the same options.
Is there a file size limit?
There is no upload, so the limit is your device's memory. Files of several megabytes normally convert without trouble.