JSON to CSV Converter
Convert JSON to CSV or CSV to JSON, choosing how nested objects and arrays are represented in the output.
- Free
- No sign-up
- Runs in your browser
JSON
Paste JSON here
or drag & drop a file anywhere on this page. You can also paste anywhere on the page (Ctrl+V)
CSV
How to convert JSON to CSV
- Paste your JSON into the left box, or drop a
.jsonfile anywhere on the page. It also reads newline-delimited JSON (.ndjson). - If your JSON has nested objects or lists, pick how they should be laid out under Nested data. Flatten with dots is selected for you; the preview updates as you change it.
- Click Download for the .csv (or a .zip when you split into several CSVs), or Copy to paste it straight into a sheet.
To go the other way, paste or drop a CSV — the tool detects it and converts to JSON. The swap button in the middle moves the current result back into the input so you can round-trip.
How nested JSON becomes CSV
CSV is a flat table, so anything nested has to go somewhere. Using an email with two recipients as the example:
| Option | Rows for one message with 2 recipients | Choose it when |
|---|---|---|
| Flatten with dots (default) | 1 row, columns from.name, to.0.name, to.1.name | You want one row per record and the lists are short |
| Repeat rows | 2 rows; subject and sender repeat on both | You will filter or pivot by the list items (one row per recipient) |
| Stringify objects | 1 row; to holds the list as JSON text in one cell | You need to keep the structure and re-parse it later |
| Split into multiple CSVs | 1 row in main.csv, 2 rows in to.csv linked by _parent_id | You are loading the data into a database or a relational model |
When a record has two separate lists (say recipients and attachments), Repeat rows lists one after the other instead of multiplying them, so you never get a recipient paired with an attachment they have nothing to do with.
What it reads
- A JSON array of objects, a single object, or newline-delimited JSON.
- API-style responses: an object holding one array of objects (for example
{"data": [...]}) is unwrapped to that array automatically. - CSV with commas, semicolons, tabs or pipes — the separator is detected — including quoted fields, escaped quotes and line breaks inside cells.
- UTF-8, UTF-16 (with a byte-order mark) and Windows-1252 text files, so older Excel exports keep their accents.
Check it yourself
The converter handles the data in your browser. Your option choices are saved in this browser's local storage. See the privacy page for everything that is and isn't collected.
Known limitations
- Files are capped at 50 MB. Very large files can make a phone tab run out of memory well before that.
- The on-page preview shows the first 200 rows; Copy and Download always include every row.
- CSV has no types. Converting to CSV writes numbers, booleans and
nullas text, andnullbecomes an empty cell. - Flatten with dots creates a column per list position, so a list of 500 items becomes 500 columns. Use Repeat rows or Split for long lists.
- A key that contains a literal dot (
"a.b") is indistinguishable from nesting when the CSV is converted back to JSON. - Downloaded CSVs start with a byte-order mark so Excel reads accents and non-Latin text correctly. Some strict parsers show it as a stray character on the first header.
FAQ
How do I convert nested JSON to CSV?
Paste it and choose a nested-data option. Flatten with dots keeps one row per record and is right for most data; Repeat rows gives one row per list item.
Why are some cells empty?
Records don't all have to share the same keys. The CSV gets a column for every key that appears anywhere, and a record without that key gets an empty cell.
Why did my phone number or ID lose its leading zero?
It didn't in the file — the CSV holds 007 as written. Excel strips the zero when it opens the file; import the column as text instead of double-clicking the CSV.
Can I convert CSV back to JSON?
Yes. Headers like from.name are rebuilt into nested objects, and numbers and true/false are turned into real JSON values unless you switch that off.
Does conversion send my data to a conversion server?
No. The conversion runs in a background thread in your browser. The page also loads third-party advertising code; see the privacy page for details.
Related tools
Tool details last reviewed 2026-10-03. See the changelog.