Convert a JSON array (or object) into a clean CSV file — nested fields are flattened automatically. Runs entirely in your browser; nothing is uploaded.
{"market":{"cap":100}} becomes a column named market.cap), and arrays are joined with semicolons. Copy the result or download it as a .csv file you can open directly in Excel, Google Sheets, or Numbers.| JSON input | CSV column | Value |
|---|---|---|
| {"city": "Muscat"} | city | Muscat |
| {"addr": {"city": "Muscat"}} | addr.city | Muscat |
| {"tags": ["a", "b"]} | tags | a;b |
| {"note": null} | note | (empty cell) |
| {"ok": true} | ok | true |
| Symptom | Cause | Fix |
|---|---|---|
| Everything in one column | Your locale expects semicolons, not commas | Switch the delimiter to Semicolon above |
| Accented characters look wrong | Excel assumed the wrong encoding | Use Data, then From Text/CSV and choose UTF-8 |
| Leading zeros disappeared | Excel read a code as a number | Import as text, or prefix the value with an apostrophe |
| Long numbers became 1.23E+15 | Excel applied scientific notation | Format the column as text before importing |
Smith, John is written as "Smith, John", and a value containing a quotation mark becomes "He said ""hello""". This converter applies the rule automatically. It is worth knowing because it explains why hand-editing a CSV in a text editor so often breaks it.No. The conversion runs entirely in your browser using JavaScript. Your data never leaves your device, which makes it safe for confidential records.
Nested objects are flattened into dot-notation columns (e.g. address.city). Arrays of values are joined with a semicolon so they fit in a single cell.
Yes. Download the .csv file and open it in Excel, Google Sheets, LibreOffice, or Numbers. If your locale uses semicolons, switch the delimiter to Semicolon.
The tool collects every key across all objects and creates a column for each. Missing values are left as empty cells.
Your Excel locale expects semicolons rather than commas as the separator — common across much of Europe. Switch the delimiter to Semicolon above and re-download.
Excel read the value as a number. Import via Data then From Text/CSV and set the column type to Text, rather than double-clicking the file.
There is no clean flat representation for them. Simple arrays are joined with semicolons, but if your data contains arrays of objects, consider exporting each as its own CSV.
Yes. Objects are flattened to dot notation at any depth, so a.b.c.d becomes a single column.
Every key found across all objects becomes a column, and objects missing a key get an empty cell in it.
No. Conversion runs entirely in your browser, so confidential exports and customer records never leave your device.