JSON to CSV Converter
Convert a JSON array of objects into a spreadsheet-ready CSV file that opens straight in Excel, Google Sheets, or Numbers. Nested objects are flattened, quoted fields are handled correctly, and everything runs in your browser, so your data is never uploaded.
Turn JSON arrays into spreadsheet rows
Most data that lands in a spreadsheet starts life as JSON — an API response, a database export, a log dump. This converter takes a JSON array of objects and lays it out as CSV: one row per object, one column per field. It scans every object first, so if some records include a field that others omit, the column still appears and missing cells are simply left empty. That keeps your columns aligned in Excel, Google Sheets, or Numbers.
Flattening nested JSON
Real-world JSON is rarely flat. When an object contains another object, this
tool flattens it into dot-notation columns — address.city,
address.zip — so the structure survives the trip to a
two-dimensional grid. Arrays and other deeply nested values are serialized
back to compact JSON inside the cell so nothing is silently dropped.
Convert JSON to Excel
There is no separate JSON-to-Excel step to learn: Excel, Google Sheets, and Numbers all open CSV files directly, so converting JSON to Excel is simply JSON → CSV, then open. Convert your JSON here, download the CSV, and open it in Excel (File → Open, or just double-click the file). The download is saved as UTF-8 with a byte-order mark, so accented characters and symbols arrive intact instead of as garbled text — the usual headache when a CSV lands in Excel. If your copy of Excel expects semicolons rather than commas, switch the delimiter before you convert.
Going the other way: CSV to JSON
Need to turn a spreadsheet export back into JSON? Flip the direction toggle to
CSV → JSON and this tool handles it, respecting
quoted fields so a value like "Doe, John" stays in one cell. For
the full treatment — delimiter auto-detection, NDJSON output, and file upload —
use the dedicated CSV to JSON converter. You
can also pair either direction with our
JSON formatter to validate and pretty-print.
Frequently asked questions
How do I convert JSON to CSV?
Paste a JSON array of objects — for example the response from an API — into the input, keep the direction on "JSON to CSV", and click Convert. Each object becomes a row and each key becomes a column. The header row is built from the combined set of keys across all objects, so rows with missing fields are left blank rather than misaligned.
How do I convert JSON to Excel?
Convert your JSON to CSV here and download it, then open the CSV in Excel (File → Open) or Google Sheets — both read CSV natively, so there is no separate JSON-to-Excel step. The file is saved as UTF-8 with a byte-order mark so accented characters display correctly in Excel rather than as garbled text. If your locale's Excel expects semicolons, choose the semicolon delimiter before converting.
What happens to nested objects and arrays?
Nested objects are flattened into dotted column names — an object like {"user": {"name": "Sam"}} becomes a column "user.name". Arrays and any remaining nested values are written as compact JSON in the cell, so no data is lost. If you need a flat spreadsheet, flatten or reshape the JSON first.
Can it convert CSV back to JSON?
Yes. Switch the direction to "CSV to JSON" and paste your CSV. The first row is treated as the header, and each following row becomes an object keyed by those headers. The parser understands quoted fields, escaped quotes ("" inside a quoted value), and values that contain commas or line breaks.
Which delimiter should I choose?
Comma is the default and works with Excel, Google Sheets, and most tools. Choose semicolon if you work in a locale where spreadsheets expect it (common in parts of Europe), or tab for TSV files. The same delimiter setting applies to both conversion directions.
Are numbers and booleans preserved when converting CSV to JSON?
With "Parse numbers and booleans" enabled, cells that look like numbers become JSON numbers and true/false become booleans; empty cells become empty strings. Turn it off to keep every value as a string, which is safer when a column contains things like ZIP codes or IDs with leading zeros.
Is my data uploaded anywhere?
No. The conversion runs completely in your browser with no network requests, so your data never leaves your device. That makes it safe for exports containing customer records or other sensitive information. Need to tidy the JSON first? Use our JSON formatter to validate and beautify it.