JSON to CSV
Convert a JSON array to CSV that opens cleanly in Excel or Google Sheets.
Runs in your browser
JSON array
Delimiter
| id | name | address.city | address.pin | tags | active |
|---|---|---|---|---|---|
| 1 | Asha | Surat | 395007 | ["new"] | |
| 2 | Ravi | Ahmedabad | 380015 | true |
CSV · 2 rows × 6 columns · 109 B
id,name,address.city,address.pin,tags,active 1,Asha,Surat,395007,"[""new""]", 2,Ravi,Ahmedabad,380015,,true
How to use JSON to CSV
1
Paste a JSON array or choose a file.
2
Review the column preview.
3
Download CSV.
When to use JSON to CSV
- Opening API data in Excel or Google Sheets to filter and analyse it.
- Sharing a report with someone who doesn't work with JSON.
- Exporting app data for accounting or a CRM import.
Tips for best results
- Input should be an array of objects; each object becomes a row.
- Nested fields become dotted column names like address.city.
- If Excel shows strange characters, import the CSV as UTF-8 instead of double-clicking it.
Related workflows
Frequently asked questions
How are nested objects handled?
Nested fields become dotted column names like address.city. Arrays are written as JSON text.
About this tool
Flatten nested JSON objects into columns and export a spreadsheet-ready CSV.
Arrays inside records are written as JSON text in a single cell so no information is lost. Column order follows the first time each key appears.
JSON to CSV runs entirely in your web browser. Your data are processed on your own device and are never uploaded to our servers, which makes it safe for personal and business files.