Converters
JSON to CSV Converter
Flatten JSON into CSV rows.
JSON0 chars
CSV
Guide & explanation
The JSON to CSV Converter flattens a JSON array into CSV rows you can open in a spreadsheet.
Column selection
For an array of objects, the columns are the union of every key that appears, in first-seen order. An object missing a key produces an empty cell. Values that are objects or arrays are written as JSON text.
Example
[ { "id": 1, "name": "Ada" }, { "id": 2, "role": "admin" } ]
id,name,role
1,Ada,
2,,admin
Options
- Delimiter and header row.
- A cell containing the delimiter, a quote, or a newline is quoted automatically per RFC 4180.