About JSON to CSV
Paste a JSON array and download it as a CSV file. Headers are auto-detected from the first object in the array. Handles nested values and custom delimiters. Browser-only.
Frequently Asked Questions
What is JSON to CSV conversion?
JSON to CSV conversion flattens a JSON array of objects into a comma-separated values file. Each object becomes a row and its keys become column headers. The result can be opened directly in Excel, Google Sheets, or any data analysis tool.
How does the converter handle nested JSON objects in CSV output?
Nested objects are serialised as a JSON string in the corresponding cell by default — for example, {"address":{"city":"Madrid"}} produces a cell containing '{"city":"Madrid"}'. Fully flattening deep nesting (address.city as its own column) is not automatic; flatten the data in your code first, then convert.
Can I convert a JSON array of arrays to CSV?
If the inner arrays represent rows of values without keys, the converter treats each inner array as a CSV row and uses positional column headers (column_0, column_1, etc.). For best results, convert your array-of-arrays to an array-of-objects with explicit keys before using the converter.
How do I flatten nested JSON before converting to CSV?
In JavaScript, use a recursive flatten function or the flat-map npm package. In Python, use pandas json_normalize() or a custom recursive dict flattener. Once the JSON is a flat array of objects with only scalar values, the CSV conversion produces clean columns with no embedded JSON strings.
Can I open the converted CSV file directly in Excel?
Yes. Click Download to save the .csv file, then open it in Excel or import via Data → From Text/CSV. For non-ASCII characters (accented letters, CJK), save with UTF-8 BOM encoding or use Excel's import wizard to specify the encoding. Google Sheets handles UTF-8 CSV without any special steps.
Advertisement300 × 250
Advertisement300 × 250