What this tool does
JSON to CSV turns JSON arrays into spreadsheets Excel opens directly: object arrays get a header row from the union of keys with blanks for missing ones, arrays of arrays export row by row, and field escaping follows RFC 4180 strictly.
Output starts with a UTF-8 BOM so Chinese text survives Excel; choose comma, semicolon or tab to match your regional software defaults. Everything runs in your browser; data is never uploaded.
How to use
- Paste JSON or drop a .json file Pasting is quickest; the top level must be an array — objects or arrays, up to 20MB as a file.
- Pick delimiter and header European Excel builds often prefer semicolons; the header toggle applies to object arrays only.
- Copy or download the CSV, then open it in a spreadsheet Output includes a BOM; Excel and WPS open Chinese text without garbling.
FAQ
Do uneven objects lose data?
No. The header is the union of keys; missing ones become empty cells.
Will Chinese text garble in Excel?
No. The BOM makes Excel decode as UTF-8 automatically.
How do nested values fit into a cell?
They are serialized as compact JSON strings — nothing is lost.
Is my file uploaded?
No. Conversion happens in your browser.
What if the top level is not an array?
No. The top level must be an array or the tool reports a structure error.
Can it produce .xlsx directly?
Not here — save the CSV as xlsx from your spreadsheet app; native xlsx export is a planned tool.
Limits
Up to 20MB per file; top level must be an array (objects or arrays).
Nested structures are serialized to JSON strings, not split into columns.
Dates stay as-is; no locale-aware formatting.