JSON to CSV Converter

JSON to CSV, without the data loss. Paste JSON and download clean CSV in seconds. Nested objects become readable columns, keys are never dropped, and quoting follows the standard so nothing breaks in Excel. Runs entirely in your browser.

Convert JSON to CSV Online

Built for exporting API responses, log files, and database dumps to spreadsheets. Flattens nested objects into dot-notation columns, unions keys across records, and quotes cells per RFC 4180. A direction toggle converts CSV back to JSON with type inference. Fully client-side: nothing leaves your browser.

Direction:
Nested values:
Delimiter:

Messy JSON first? Open the JSON Formatter. Need to diff two exports? Try JSON Compare.

Paste JSON above and the CSV preview appears here. The direction switch also converts CSV back to JSON.

How to use:

  1. Paste your JSON into the input box, or drop a .json or .txt file onto it
  2. Pick how nested values become columns: Flatten (dot/bracket columns like user.tags[2]) or Keep JSON (compact JSON in the cell)
  3. Pick the delimiter (comma, semicolon, or tab) and whether the output starts with a header row
  4. Read the preview table, then Copy CSV or Download .csv
  5. To go the other way, switch the direction to CSV to JSON, set the header and type options, then Copy JSON or Download .json

Everything runs in your browser: no network calls, no analytics on your input, nothing stored.

Why use this JSON to CSV converter?

Nested JSON, done honestly

Nested objects become real columns (user.name, user.tags[2]) or stay as compact JSON. No [object Object] cells.

Keys are never dropped

Columns are the union of every key across all records. An object missing a key leaves an empty cell, so nothing disappears silently.

RFC 4180 quoting

Cells with commas, quotes or line breaks are quoted and escaped per the standard, so the CSV round-trips through any parser unchanged.

Private by default

The conversion runs entirely in your browser: no upload, no storage, no tracking of your data.

Frequently Asked Questions

Is my data uploaded anywhere?

No. Parsing, converting and rendering all happen in your browser: no network calls, nothing stored, no analytics on your input. Close the tab and your data is gone.

How are nested objects handled?

Your choice, with the nesting toggle. Flatten turns nested objects and arrays into dot and bracket columns: user.name, user.tags[2]. Keep JSON puts the nested value into the cell as compact JSON instead. The default is Flatten.

Why do long numbers change in Excel?

Excel displays big numbers in scientific notation, drops digits beyond 15 significant figures, and strips leading zeros. The CSV file itself is unchanged: the output here is standards-correct. To keep the exact text, import the file through the Excel CSV import wizard and set those columns to Text.

Which delimiter should I pick?

Comma is the default and what most tools expect. Pick semicolon if you open the file in Excel with a European locale, where the list separator is a semicolon. Tab suits quick pastes into editors and spreadsheets.

Can it read JSON Lines / NDJSON?

Yes. Newline-delimited JSON, one JSON value per line (the format of many log exports and streaming APIs), is detected automatically and each line becomes one row.

Can I convert CSV back to JSON?

Yes: flip the direction switch to CSV to JSON. Quoted fields with embedded commas and newlines parse correctly, the delimiter is auto-detected with an override, and numbers, booleans and null become JSON types. Turn type inference off to keep every cell as a string.