JSON to CSV Converter

Convert a JSON array of objects to CSV. Auto-detects columns, handles nested values. Instant.

JSON array

CSV output (3 rows, 3 cols)

name,age,city
Alice,30,New York
Bob,25,London
Carol,35,Sydney

Convert JSON to CSV online

Paste a JSON array of objects — the converter automatically detects all column headers from the keys across every row. Fields containing commas, quotes, or newlines are properly escaped per RFC 4180. Nested objects or arrays become JSON-encoded strings in their cell. The Download button saves the result as a.csv file readable by Excel, Google Sheets, or any spreadsheet tool. For the reverse, try the CSV to JSON Converter. To validate your JSON first, use JSON Formatter.

Frequently Asked Questions

What JSON structure works best for CSV conversion?

An array of flat objects works best: [{"name":"Alice","age":30},{"name":"Bob","age":25}]. Each object becomes a row and keys become headers. Deeply nested objects serialize as [object Object] — flatten them first.

What happens to nested JSON objects or arrays?

Nested values are stringified into a single cell. To get nested fields as separate columns, flatten the JSON first (e.g. convert {"address":{"city":"NYC"}} to {"address.city":"NYC"}) before converting.

Can I convert to TSV (tab-separated) instead?

Yes. Select the Tab delimiter option to produce a TSV file. TSV is preferred when your data contains commas, avoiding the quoting overhead of standard CSV.

How are special characters (commas, quotes, newlines) handled?

Values containing commas, double quotes, or newlines are wrapped in double quotes per RFC 4180. Embedded double quotes are escaped by doubling them (" → "").

Can I open the resulting CSV in Excel or Google Sheets?

Yes. Download the file and open it directly. If accented characters appear garbled in Excel, use Data → Import and choose UTF-8 encoding when opening.

Private & free — this tool runs entirely in your browser.