JSON to CSV
Flatten a JSON array into spreadsheet-ready columns
- 100% Free
- Files stay private
- Works in your browser
Runs entirely in your browser. Objects with different keys are unioned into one header row; nested values are written as compact JSON inside the cell.
How it works
Paste your JSON
Type or paste a JSON array of objects into the JSON input box. It converts live as you type.
Pick a delimiter
Choose the Delimiter: Comma, Semicolon, Tab or Pipe. The header row is built from every key found in your objects.
Copy or download CSV
The CSV output shows its Rows, Columns and Size. Press Copy, or Download .csv to save it as a file.
Flatten a JSON array of objects into a clean CSV table you can open in any spreadsheet, with a delimiter picker and proper quoting, all live in your browser.
What is JSON to CSV?
JSON to CSV is a free online converter that turns a JSON array of objects (or a single object, or an array of arrays) into comma-separated rows. It builds the header from the union of every object's keys, in first-seen order, so records with slightly different fields still line up in one consistent table. It matters because spreadsheets, BI tools and many legacy systems consume CSV, while modern APIs speak JSON, and you constantly need to bridge the two.
Who Benefits from This Tool
- Analysts: pull a JSON API response into a spreadsheet for pivots and charts.
- Developers: export application data into CSV for reporting or import elsewhere.
- Ops and finance teams: convert JSON records into a format their tools accept.
- Data engineers: generate CSV inputs for pipelines that expect flat files.
- Anyone with a JSON export: get a table they can open in Excel or Google Sheets.
Key Features
- Key-union header: collects every object's keys in first-seen order so ragged records align.
- Flexible input: accepts an array of objects, an array of arrays, or a single object.
- Delimiter picker: comma, semicolon, tab or pipe.
- Proper CSV quoting: cells with the delimiter, quotes or line breaks are quoted and quotes doubled.
- Nested value handling: objects and arrays in a cell are serialised to compact JSON.
- Precise error messages: invalid JSON is flagged with a line and column.
- Row, column and size stats plus copy and .csv download.
How to Use
- Choose the output delimiter you want in the CSV.
- Paste your JSON, or click Try sample to load an example.
- The CSV is generated live; review the row, column and size stats.
- Copy the result or download it as a .csv file.
- Open the file in your spreadsheet or import it into your target system.
Common Use Cases
- Converting a JSON API response into a spreadsheet for analysis.
- Exporting application or database records to CSV for a report.
- Producing semicolon- or tab-delimited files for locale-specific or strict importers.
- Flattening a list of records where objects have slightly different fields.
- Turning configuration or log data into a table for review.
Tips and Best Practices
- Feed an array of objects for the cleanest table. Each key becomes a column.
- Choose semicolon or tab if your spreadsheet locale misreads commas.
- Expect nested objects to land as JSON text in a single cell; flatten them in code first if you need separate columns.
- If a column is missing for some rows, those cells come out empty. That's the key-union behaviour working as intended.
- Open the downloaded file with the matching delimiter setting in your spreadsheet's import dialog.
Limitations and Notes
Conversion runs entirely in your browser and nothing is uploaded, with input capped at roughly 2 MB. Nested objects and arrays are written as compact JSON inside a single cell rather than expanded into extra columns, so deeply nested data is not fully flattened. The input must be valid JSON that is an array or object; primitives alone won't convert. Cells are quoted only when they contain the delimiter, a double quote or a line break, following standard CSV escaping.
FAQs
An array of objects (the common case), an array of arrays, or a single object. A bare string or number on its own cannot be converted to a table.
The tool gathers the union of all keys in first-seen order to form one header row, leaving cells empty where a record lacks that key.
They are serialised to compact JSON and placed inside a single cell rather than split into their own columns.
Comma, semicolon, tab and pipe. Choose the one your target system or spreadsheet expects.
CSV requires quoting any cell containing the delimiter, a double quote or a line break; internal quotes are doubled to stay valid.
No. Everything runs locally in your browser and your data never leaves your device.