Updated 2026-08-18
JSON to CSV for Excel and Google Sheets
API dumps arrive as JSON. Spreadsheets want rows. The ToolSphere JSON to CSV converter builds comma-separated text in your tab so payloads are not uploaded for conversion.
Start from an array of objects
The cleanest input is [ { "id": "001", "name": "Ada" }, … ]. Each object becomes one row. Keys become column headers in the order they first appear. A single object is treated as a one-row table.
If JSON does not parse, fix it in the JSON Formatter first, then convert. Invalid JSON never becomes a partial spreadsheet in this tool.
What happens to nested fields
Nested objects and arrays are written as JSON text in one cell, not exploded into extra columns. That keeps the grid rectangular. Flatten in your own code if you need city as its own column instead of {"city":"Austin"}.
Excel and Sheets caveats
The download is UTF-8 CSV without a BOM. Import as UTF-8 so names and symbols survive. Spreadsheet apps may coerce numeric-looking IDs and drop leading zeros—import those columns as text when that matters.
This is the opposite of CSV to JSON, which reads a table and emits string-keyed objects. Use JSON to CSV when you already have JSON; use CSV to JSON when you start from an export.