JSON to CSV
Convert JSON arrays into CSV with automatic flattening of nested objects.
About JSON to CSV
Turn a JSON array of objects into a CSV file that opens in Excel, Numbers or Google Sheets. Nested objects are flattened into columns such as address.city, arrays are kept as JSON, and every key that appears in any row becomes a column.
How it works
-
1
Paste a JSON array (or an object containing one) or drop a .json file.
-
2
Pick a delimiter — comma, semicolon or tab.
-
3
Preview the table, then copy or download the CSV.
Frequently asked questions
What JSON structure is supported?
An array of objects works best. A single object is treated as one row, and if the top-level object contains exactly one array, that array is used.
How are nested objects handled?
They are flattened with dot notation, e.g. {"user":{"name":"Ann"}} becomes a column named user.name.
Why use a semicolon delimiter?
Excel in many European locales expects semicolons because the comma is the decimal separator.