DEVELOPER TOOL · PRIVATE
JSON to CSV Online
Convert an array of JSON objects into CSV locally.
Convert tabular JSON data into comma-separated values for spreadsheets and analysis. Paste the input, make the change, then read the result before you copy it elsewhere.
Nested objects are serialised as JSON text.
Ready — input is processed locally.
This utility runs on the current device for the supported workflow. Kaazo does not need the pasted input to calculate the result.
JSON to CSV: what the output actually changes
Convert tabular JSON data into comma-separated values for spreadsheets and analysis.
Rows and nested objects don’t have the same shape
CSV is flat and column-based; JSON can be nested. Straightforward records convert cleanly, while arrays or nested objects need a deliberate flattening convention before they can fit ordinary CSV columns.
Flat objects convert most cleanly.
When JSON to CSV isn’t the right endpoint
Keep JSON when hierarchy matters. Use CSV when the data is genuinely tabular and meant for spreadsheets or simple imports.
Example and result checks
For an array such as [{"name":"Asha","city":"Pune"},{"name":"Ravi","city":"Delhi"}], the natural table has name and city columns. A nested value like {"address":{"city":"Pune"}} is different: it needs an explicit flattening policy rather than an assumption that every JSON structure maps cleanly to rows.
Open the resulting CSV in a text editor before relying only on a spreadsheet preview. Look for headers, escaped quotation marks, empty cells and values containing commas or newlines. For API data with nested arrays or mixed object types, preserve the JSON until you know exactly what information can be safely flattened.
FAQ
What does JSON to CSV actually do?
Convert tabular JSON data into comma-separated values for spreadsheets and analysis.
What can change the JSON to CSV result?
CSV is flat and column-based; JSON can be nested. Straightforward records convert cleanly, while arrays or nested objects need a deliberate flattening convention before they can fit ordinary CSV columns. Flat objects convert most cleanly.
Does formatted or converted output prove the data is valid for my application?
No. JSON to CSV can perform the syntax or data operation described here, but your application can still impose its own schema, business rules, encoding or security requirements.
Related tools
After JSON to CSV, validate the output before feeding it into another transform. The data-format guide has broader context if you need it.