Esc

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

Your CSV appears here.

Used between columns in the CSV you download.
Nested data

One row per record. Nested fields become dotted columns; list items get numbered columns. from.name, to.0.name, to.1.name

How to convert JSON to CSV

  1. Paste your JSON into the left box, or drop a .json file anywhere on the page. It also reads newline-delimited JSON (.ndjson).
  2. 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.
  3. 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:

OptionRows for one message with 2 recipientsChoose it when
Flatten with dots (default)1 row, columns from.name, to.0.name, to.1.nameYou want one row per record and the lists are short
Repeat rows2 rows; subject and sender repeat on bothYou will filter or pivot by the list items (one row per recipient)
Stringify objects1 row; to holds the list as JSON text in one cellYou need to keep the structure and re-parse it later
Split into multiple CSVs1 row in main.csv, 2 rows in to.csv linked by _parent_idYou 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 null as text, and null becomes 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.