Convert JSON to CSV Locally

UTF-8 BOM

Convert and flatten nested JSON objects and arrays into RFC 4180 CSV with automatic UTF-8 BOM for Excel — running 100% in browser memory.

100% Client-Side — Verify 0 bytes uploaded in Network tabVerify 0 bytes sent in Network tab

or drop files here · Ctrl V to paste · or drop a .json file · Ctrl V to paste JSON
  • 100% browser-local
  • 0 bytes uploaded
  • Excel UTF-8 BOM ready

Instant Before & After Preview

UTF-8 BOM ready for Excel
Before (Input)orders.json
[
  { "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 }
]
After (Output).csv
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,false

Source vs. target format specification comparison: JSON → CSV

PropertySource: JSONTarget: CSV
Structure typeHierarchicalTabular
Human readabilityHighHigh
Nesting supportYesNo
LLM token efficiencyLowHigh
File extension.json.csv
MIME typeapplication/jsontext/csv
Best forREST/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.

  1. Paste or drop JSONPaste a JSON array or single object, or drop one or multiple .json files directly into the workspace.
  2. Choose flattening & BOMKeep nested key flattening enabled (customer.city) and leave UTF-8 BOM checked if opening in Windows Excel.
  3. 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.