Online Tool Store
JSON Array to CSV Rows
Convert a JSON array of objects into properly quoted CSV rows, automatically building the header from every key across the array, ready to copy or download.
🔒 This tool runs entirely in your browser. Your files are never uploaded to a server.
How the JSON Array to CSV Rows tool works
- Paste a JSON array of objects — the typical shape of an API response or exported record set.
- The tool collects every unique key across all objects to build the header row.
- Each object becomes one CSV row, with proper quoting applied wherever a value needs it, ready to copy or download.
Quoting rules
A value is wrapped in double quotes whenever it contains the chosen delimiter, a double quote character, or a line break, with any embedded double quotes doubled up — the standard approach most spreadsheet software expects.
FAQ
How are the CSV columns determined?
The tool scans every object in the array and builds a column list from the union of all keys it finds, in first-seen order — so if some rows are missing a field, that cell is simply left blank in the CSV rather than causing an error.
How does it handle values that contain commas or quotes?
Following standard CSV quoting rules (RFC 4180), any value containing the delimiter, a double quote, or a newline is wrapped in double quotes, with internal quotes doubled — so the output opens cleanly in Excel, Google Sheets, or any CSV-aware tool.
What happens to nested objects or arrays inside a row?
A nested object or array value is serialized back to a compact JSON string inside its CSV cell, since CSV has no native concept of nesting — you can always post-process that column separately if you need it flattened further.
How we compare
| Feature | Online Tool Store | Spreadsheet import | Writing a script |
|---|---|---|---|
| Handles inconsistent object shapes | ✓ | ✗ | ✓ |
| No coding required | ✓ | ✓ | ✗ |
For very large JSON files or recurring pipeline conversions, a scripted approach will scale better than pasting into a browser tab.