{jsonbody.com}

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 .json file.
  • Keep Flatten nested objects on to turn address.city into 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 .csv file 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.

JSON input and CSV output
[
  { "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.",Delhi

Common 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 011001 can 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.