How to Convert JSON to CSV
Updated June 2026
JSON to CSV
Open the free tool →
Convert a JSON array to CSV.
JSON is great for code, but spreadsheets speak CSV. Converting between them is simple once your JSON is shaped the right way.
The right shape
CSV is a table, so your JSON should be an array of objects, where each object is a row and its keys are the columns:
[ {"name": "Ada", "age": 36}, {"name": "Linus", "age": 54} ]
That becomes a CSV with a name,age header and two rows.
How to convert
- Paste your JSON array into the converter below.
- Click Convert to CSV.
- Copy the result or download a
.csvyou can open in Excel or Google Sheets.
Handling messy data
- Different keys per object? A good converter collects every key it finds, so nothing is lost — missing values are just left blank.
- Commas or quotes in values? Those get wrapped in quotes automatically so the CSV stays valid.
- Nested objects? They're stored as text; flatten them first if you need separate columns.
JSON to CSV
Open the free tool →
Convert a JSON array to CSV.
Frequently asked questions
Will it open in Excel?
Yes — download the .csv and open it in Excel, Google Sheets or Numbers. Each object becomes a row.
Is my data uploaded anywhere?
No. The conversion runs in your browser, so your JSON never leaves your device.