Nested objects flattened to dotted columns
[{ "sku": "TL-001", "stock": { "warehouse": 12, "shelf": 3 } }]sku,stock.warehouse,stock.shelf TL-001,12,3
JSON to CSV
Flatten a JSON array into a CSV that opens cleanly in Excel.
Without it, Excel on Windows can show accented characters incorrectly.
CSV output
The result will appear here.
Was this tool useful?
About this tool
Exporting JSON to CSV is what you do when the data has to reach a spreadsheet: an accountant, a marketplace bulk upload, a supplier who works in Excel. The conversion is straightforward for a flat array of objects and needs a decision as soon as the objects are nested.
This tool flattens nested objects into dotted column names, so { customer: { name: "…" } } becomes a customer.name column rather than a JSON blob inside a cell. Union of all keys across rows becomes the header, so a field missing from one row still gets its column.
How to use it
- Paste a JSON array of objects, or upload a .json file.
- Choose the delimiter. Semicolon is safer if the file will be opened in Excel on a Turkish or European locale.
- Leave the UTF-8 BOM on unless you know the consumer rejects it — it is what makes Excel read accented characters correctly.
- Turn flattening off if you would rather keep nested objects as JSON text in a single cell.
- Convert and download the .csv file.
Examples
Common problems
- Turkish characters appear as mojibake in Excel.
- Excel on Windows assumes the system codepage unless the file starts with a UTF-8 byte-order mark. Keep the BOM option on.
- Everything lands in column A.
- Excel splits on the list separator from your regional settings, which is a semicolon in Turkish Windows. Export with semicolons, or use Data → From Text and pick the delimiter.
- The input is refused because it is not an array.
- CSV is a table, so it needs a list of rows. Wrap a single object in square brackets, or select the array inside your document first.