Data converters
JSON to CSV Converter
Turn an API response into a spreadsheet-ready file. Columns are the union of all keys across records, nested objects are flattened with dot notation, and quoting is always correct.
- Runs 100% in your browser
- No signup · No uploads
- Free, unlimited use
JSON array
Examples: Orders · Simple list — ⌘/Ctrl + Enter converts · drop a file to load it · processed locally
CSV output
Output is read-only. Use Copy, Download or Share to move it out.
How to use the json to csv tool
-
Paste a JSON array
An array of objects becomes a table. A single object becomes one row; scalar arrays become a one-column table.
-
Choose delimiter and header
CSV for Excel, TSV for pasting directly into spreadsheet cells. Header rows can be toggled off when the target already has one.
-
Download and open
Download the .csv file and open it in Excel, Numbers or Google Sheets — or paste the TSV straight into a sheet.
What makes this one different
- Column set is the union of every key in every record — nothing is silently dropped
- Nested objects flattened to dot notation (customer.name)
- Arrays inside records become JSON strings, so no data is lost
- RFC 4180 quoting: commas, quotes and newlines inside values stay safe
- CSV or TSV output; optional header row
Privacy by architecture: this page contains no analytics that receive your input, and the conversion code runs in your tab. You can disconnect from the network after loading and keep working.
JSON to CSV — frequently asked questions
What happens to nested objects?
They are flattened with dot notation, so {"customer":{"name":"Ada"}} becomes the column customer.name. Nested arrays cannot be flattened meaningfully and are serialised as JSON inside the cell.
Why do some rows have more columns?
The column list is the union of all keys across all records. A missing key simply produces an empty cell, which keeps every row aligned to the same header.
Can Excel open the file directly?
Yes. The output is standard RFC 4180 CSV with UTF-8 encoding. In Excel, use Data → From Text/CSV if double-clicking mangles encoding on older versions.
Can I convert JSON Lines to CSV?
Yes — each line is parsed as one record, so JSONL input produces the same table as an equivalent JSON array.
Related tools
Searching for “json to csv online”, “convert json to excel”, “json array to csv”? You are in the right place — browse all 19 tools.