Convert JSON to CSV Locally
UTF-8 BOMConvert and flatten nested JSON objects and arrays into RFC 4180 CSV with automatic UTF-8 BOM for Excel — running 100% in browser memory.
- 100% browser-local
- 0 bytes uploaded
- Excel UTF-8 BOM ready
Instant Before & After Preview
UTF-8 BOM ready for Excel[
{ "id": "ORD-101", "customer": { "name": "Maya Lin", "city": "Tokyo" }, "total": 149.50, "paid": true },
{ "id": "ORD-102", "customer": { "name": "Jonas Weber", "city": "Berlin" }, "total": 89.00, "paid": true },
{ "id": "ORD-103", "customer": { "name": "Sofia Silva", "city": "Lisbon" }, "total": 210.25, "paid": false }
]id,customer.name,customer.city,total,paid
ORD-101,Maya Lin,Tokyo,149.5,true
ORD-102,Jonas Weber,Berlin,89,true
ORD-103,Sofia Silva,Lisbon,210.25,falseSource vs. target format specification comparison: JSON → CSV
| Property | Source: JSON | Target: CSV |
|---|---|---|
| Structure type | Hierarchical | Tabular |
| Human readability | High | High |
| Nesting support | Yes | No |
| LLM token efficiency | Low | High |
| File extension | .json | .csv |
| MIME type | application/json | text/csv |
| Best for | REST/GraphQL APIs, structured application state, NoSQL documents, and machine-to-machine data exchange. | Spreadsheet imports, analytics exports, SQL table loads, and uniform flat datasets. |
How it works
How to convert JSON to CSV safely in your browser
Turn nested API responses or JSON arrays into flat spreadsheet tables without sending customer rows to remote servers.
- Paste or drop JSONPaste a JSON array or single object, or drop one or multiple .json files directly into the workspace.
- Choose flattening & BOMKeep nested key flattening enabled (customer.city) and leave UTF-8 BOM checked if opening in Windows Excel.
- Copy or download CSVPreview every column live in the output pane, download the .csv (or batch ZIP), or pipe straight into CSV to SQL.
FAQ
Frequently asked questions
How does JSON to CSV handle nested objects like customer.city?
With Flatten Nested Objects enabled, nested keys flatten cleanly using dot notation (such as customer.name and customer.city) so no properties are lost.
Why enable UTF-8 BOM when exporting JSON to CSV for Excel?
Windows Excel defaults to local ANSI/CJK code pages on CSV files without a BOM. Prepending EF BB BF ensures accented and CJK names display cleanly.
Can I convert multiple JSON files into CSV at once?
Yes. Drop multiple .json files simultaneously to convert them in batch and download all generated CSVs in a single deflated ZIP.