Convert JSON to CSV for Excel
Paste a JSON array of objects and get CSV with a header row and flattened nested fields — ready to open in Excel or Google Sheets.
Open the tool, then paste the sample input below. Everything runs locally in your browser.
The problem
An API returned JSON but a stakeholder wants a spreadsheet. JSON does not open in Excel, and nested objects do not map cleanly to columns. Converting to CSV with flattened keys and a header row gives you a file that opens and sorts like any other sheet.
Sample input
[
{ "id": 1, "name": "Ada", "address": { "city": "London" } },
{ "id": 2, "name": "Ben", "address": { "city": "Paris" } }
]Expected output
id,name,address.city
1,Ada,London
2,Ben,ParisThe nested address.city is flattened into a dotted column header, and the first object's keys define the column order.
How to do it
- Paste the JSON array of objects.
- Confirm how nested fields are flattened.
- Convert to CSV.
- Copy or download the CSV.
- Open it in Excel or Google Sheets.
Common mistakes
- Passing a single object instead of an array of objects.
- Objects with different keys, leaving ragged columns.
- Nested arrays that do not flatten into a single cell cleanly.
- Commas inside values not being quoted for Excel.
- Expecting Excel to detect UTF-8 without a byte-order mark.
Related tools
Related guides
FAQ
How do I convert JSON to CSV for Excel?
Paste a JSON array of objects and convert. The keys become a header row, each object becomes a row, and the CSV opens directly in Excel or Google Sheets.
How are nested objects handled?
Nested fields are flattened into dotted column headers such as address.city, so each leaf value gets its own column.
What if objects have different keys?
The column set is the union of keys; objects missing a key get an empty cell, so the columns stay aligned.
Will values with commas break the CSV?
No. Values containing commas, quotes, or newlines are quoted so spreadsheets parse them as a single cell.
Is my JSON uploaded?
No. Conversion runs locally in your browser. Your data is not sent to a server.
JSON to CSV conversion runs locally in your browser. Nothing is uploaded.
Convert JSON to CSV, inspect data, build SQL and compare files — grouped in one place.