JSON to CSV

How to use the json to csv

1. Paste an array of JSON objects.
2. Choose the delimiter, and whether to flatten nested objects.
3. Download the CSV.

About this tool

JSON nests; a spreadsheet does not. The conversion has to answer two questions, and this tool answers both visibly rather than silently. Nested objects are flattened into dotted column names, so <code>{"address":{"city":"London"}}</code> becomes a column called <code>address.city</code>. Arrays are kept as JSON text inside the cell, because there is no honest way to spread a list across a fixed column.

Records with different keys are unioned: every key that appears anywhere becomes a column, and records missing it get an empty cell. That is flagged when it happens, since it usually means the data is less regular than expected.

Values containing the delimiter, quotes or line breaks are quoted and escaped per RFC 4180, so the file opens correctly in Excel and Sheets.

Common uses

• Getting an API response into a spreadsheet.
• Preparing data for a bulk import.
• Sharing structured data with someone who wants Excel.

Frequently asked questions

What happens to nested arrays?

They are kept as JSON text in the cell. Spreading a list across columns would invent structure that is not in the data.

Why do some rows have empty cells?

Because those records did not have that key. Every key found anywhere becomes a column, so the table stays rectangular.

Will it open correctly in Excel?

Yes. Fields containing the delimiter, quotes or line breaks are quoted and escaped. For Excel in a semicolon locale, choose the semicolon delimiter.