JSON to CSV
Convert an array of JSON objects into CSV text.
How to use JSON to CSV
- Paste a JSON array of objects.
- Select Convert to CSV.
- Copy the result into a CSV file and check the column headings and escaped quotation marks in your spreadsheet program.
Practical example
Objects with name and city properties produce name and city columns. If another object has an extra property, that property is included as another column.
What to check before using the result
Nested objects and arrays are not flattened into a relational table. Missing values become empty cells. Treat text beginning with a spreadsheet formula character cautiously when opening untrusted CSV data; CSV quoting is not protection against spreadsheet formula execution.