What JSON shapes work for CSV export?

Arrays of objects are ideal. A single object becomes one row. Nested objects and arrays flatten into dot-separated column names.

Does CSV conversion change my JSON values?

Values stay the same where CSV can represent them. Nested structure is flattened to columns; convert CSV back to JSON to rebuild nesting.

Can I open the output in Excel?

Yes. Download the CSV file and open it in Excel, Google Sheets, or any CSV-aware tool.

No. Conversion runs locally in your browser. Nothing is sent to a server.

What delimiter does the CSV use?

Comma-separated values with standard double-quote escaping. Fields containing commas or quotes are wrapped in quotes per typical CSV conventions.

JSON to CSV

Turn API JSON into spreadsheet-ready CSV. Arrays of objects become rows; nested objects flatten to dot-separated column names so Excel and Google Sheets can open the file.

JSON input

Result

CSV output

Paste JSON, then Convert. Nested fields flatten to columns.

How to convert JSON to CSV

Paste JSON — an array of objects works best; a single object becomes one row.
Click Convert.
Nested fields flatten to dot-separated column names (for example address.city).
Copy the CSV or download the file for Excel or Google Sheets.

FAQ

: Arrays of objects are ideal. A single object becomes one row. Nested objects and arrays flatten into dot-separated column names.
: Values stay the same where CSV can represent them. Nested structure is flattened to columns; convert CSV back to JSON to rebuild nesting.
: Yes. Download the CSV file and open it in Excel, Google Sheets, or any CSV-aware tool.
: No. Conversion runs locally in your browser. Nothing is sent to a server.
: Comma-separated values with standard double-quote escaping. Fields containing commas or quotes are wrapped in quotes per typical CSV conventions.

Result

How to convert JSON to CSV

FAQ

Related tools