What is JSON arrays?
The object arrays APIs and scripts produce. Flexible and nested, but spreadsheets cannot open them — and pasting raw JSON into Excel invites both chaos and formula attacks.
JSON to CSV
Convert flat JSON arrays to spreadsheet-safe CSV with formula protection.
Preparing the tool…
The tool could not be loaded. Check your connection and try again.
No file selected
How to convert JSON to CSV
Paste your JSON
Paste an array of flat objects or load a .json file locally.
Set the safety option
Keep spreadsheet-safe mode on to guard against formula injection in Excel.
Download the CSV
Copy or save the resulting CSV, ready to open in any spreadsheet app.
Frequently asked questions
Which JSON structure can be converted?
Only a flat array of flat objects — no nested objects or arrays inside rows. Nested data is rejected with a clear error rather than silently stringified.
How is the column order decided?
Columns follow the key order of first appearance across all objects. Missing or null values become empty cells.
What does the spreadsheet-safe option do?
It prefixes values starting with =, +, − or @ with a single apostrophe, preventing Excel and Sheets from executing them as formulas. The UI tells you when this guard is applied.
Does my data leave my device?
No. The conversion runs entirely in your browser — nothing is uploaded, logged or stored.
Objects into spreadsheet rows
Here is what each format is for, and when converting JSON arrays into CSV tables is the right move.
What is CSV output?
A rectangular table with a strict header row, RFC 4180 quoting, and optional formula-injection protection so opening it in Excel does not execute cell contents.
When you need it
Use it to hand API data to non-technical colleagues, build reports in Excel or Sheets, or archive exports in a universal format. Flatten nested structures yourself first — this converter refuses rather than guessing.