JSON to CSV
Flatten a JSON array into a spreadsheet-ready CSV.
Options
Private by design. This tool runs entirely in your browser. Your input is processed on your own device and is not uploaded by DO101.
About the JSON to CSV
Turns an array of JSON objects into CSV, building the header from the union of every object's keys so records with missing fields still line up. Values containing commas or quotes are escaped correctly.
How to use it
- 1Paste a JSON array.
- 2Choose the delimiter and whether to include a header.
- 3Copy or download the CSV.
What you get
- Header built from the union of all keys
- Correct quoting for commas, quotes and newlines
- Nested objects serialised as JSON in the cell
- Comma, semicolon, tab or pipe output
- Runs in your browser
Frequently asked questions
What happens to nested objects?
CSV is flat, so a nested object or array is written into the cell as JSON text. Flatten the structure first if you need separate columns.
Why do some rows have empty cells?
The header is the union of every object's keys, so a record missing a field gets an empty cell rather than a shifted row.
Will Excel open it correctly?
Yes. If your locale uses semicolons as the list separator, choose semicolon as the delimiter and Excel will split the columns properly.
Keep going
People who use this tool usually reach for these next.
Turn a spreadsheet export into JSON.
Beautify, minify and validate JSON with error positions.
Convert JSON into readable YAML.
Strip whitespace from JSON to shrink payloads.