JSON to CSV Converter
Paste a JSON array of flat objects and get spreadsheet-ready CSV, with the header row built from your keys and any commas or quotes escaped for you — all in your browser.
name,role,years Ada,Engineer,7 Grace,Admiral,40
How it works
The tool expects a JSON array where each item is a flat object — the kind of shape an API often returns for a list of records. It parses the array, then walks every object to collect the full set of keys, so even if one row has an extra field it still gets a column.
Those keys become the header row. For each object it then writes one line, pulling the value for each column in order. A missing key just leaves that cell blank rather than shifting the columns.
CSV has a few gotchas, so values are escaped properly: anything containing a comma, a quote, or a line break gets wrapped in double quotes, and embedded quotes are doubled. That way the file opens correctly in Excel, Sheets, or any parser without mangling your data.
Frequently asked questions
What if my objects don't all have the same keys?
Every key seen across the array becomes a column. Rows missing that key just get an empty cell, so the columns stay aligned instead of drifting.
Can the values contain commas or quotes?
Yes. Any value with a comma, quote, or newline is wrapped in double quotes and its inner quotes are doubled, which is the standard CSV escaping that spreadsheets expect.
What happens with nested objects or bad JSON?
If the JSON won't parse or isn't an array of objects, you get a clear message. Nested values are stringified into their cell rather than being flattened, so keep objects flat for the tidiest output.