Search tools...⌘K
JSON to CSV Converter
Turn JSON arrays into spreadsheet-ready CSV, and CSV back into JSON.
Delimiter
JSON input
CSV output
3 rows
How to Convert JSON to CSV
- 1
Paste a JSON array
Provide an array of objects — one object becomes one row. A single object works too and produces a one-row file.
- 2
Choose how to handle nesting
Leave Flatten on to expand nested objects into dot-notation columns such as role.title. Turn it off to keep nested values as JSON inside a single cell.
- 3
Pick a delimiter
Comma is standard. Semicolon suits locales where the comma is the decimal separator, and tab produces a TSV that pastes cleanly into spreadsheets.
- 4
Download the CSV
Download the file and open it in Excel, Numbers, Google Sheets or your data pipeline.
Frequently Asked Questions
Nested objects are flattened into dot-notation columns, so {"role":{"title":"Engineer"}} becomes a column named role.title. Arrays get indexed columns like tags[0] and tags[1]. Turn Flatten off if you would rather keep each nested value as raw JSON inside one cell.
No. Parsing and conversion happen in your browser. Nothing is transmitted or stored, so you can safely convert exports containing customer records or other personal data.
They are quoted and escaped per RFC 4180: the field is wrapped in double quotes and any internal double quote is doubled. That is exactly what Excel, Sheets and standard CSV parsers expect, so values with commas, line breaks or quotes survive the round trip.
The header is the union of every key seen across all records, in first-seen order. Records missing a key get an empty cell rather than a shifted row, so ragged JSON still produces a rectangular file.
Yes. Cells that look like numbers, true, false or null are converted to real JSON types. Values that would not survive a round trip — a zero-padded id like 007, for instance — are kept as strings.
Yes. With Flatten enabled, dot-notation headers are expanded back into nested objects and bracket indices back into arrays, so a file exported from this tool round-trips to its original shape.