JSON to CSV Converter - Turn JSON Arrays into Spreadsheets
APIs speak JSON; spreadsheets, imports and managers speak CSV. Paste a JSON array below and get a CSV file that opens cleanly in Excel, Google Sheets or any importer - no mangled commas, no broken quotes.
How to use the JSON to CSV Converter
- Paste a JSON array of objects into the top box (a single object works too - it becomes one row).
- Click Convert to CSV.
- Review the CSV: the first row is the header, built from every key found in the array.
- Copy it or download it as a .csv file, ready for Excel or Google Sheets.
How it works
The converter parses your JSON with the browser built-in parser, then walks every object in the array and collects the union of all keys, in the order they first appear - so an object with an extra field never loses it. Each cell is escaped by the CSV rules: values containing a comma, quote or newline are wrapped in double quotes, and quotes inside are doubled. Numbers and booleans are written plainly, null and missing keys become empty cells, and a nested object or array is written as compact JSON inside its cell so no data is silently dropped.
Worked example
The array [{"name":"Ali","city":"Lahore"},{"name":"Ana","city":"Porto","vip":true}] becomes three columns (name, city, vip): Ali gets an empty vip cell, and Ana gets true - the union-of-keys approach keeps both rows complete.
Frequently Asked Questions
Is this JSON to CSV converter free?
Yes - completely free, with no sign-up, no size limit and no daily cap.
What JSON shapes are accepted?
An array of objects is the main case. A single object becomes a one-row CSV, and an array of plain values (numbers, strings) becomes a single "value" column. Anything else is rejected with an explanation.
What happens to nested objects and arrays?
They are written as compact JSON text inside their cell. Nothing is flattened away or dropped, and converting back with our CSV to JSON tool keeps them readable.
Why do some cells have quotes around them?
CSV rules require quoting when a value contains a comma, a double quote or a newline - otherwise the columns would shift. Excel and Google Sheets read this standard quoting correctly.
Is my data uploaded to a server?
No. Parsing and converting happen 100% in your browser. Your data never leaves your device.
Related Developer Tools
CSV to JSON Converter
Convert CSV to a JSON array of objects - a real parser that handles quoted commas and escaped quotes.
JSON Formatter
Validate, pretty-print and minify JSON, with the exact position of any error.
YAML ⇄ JSON Converter
Convert the common YAML subset (maps, lists, scalars) to JSON and JSON back to YAML - honestly scoped.