JSON to CSV Converter
A JSON to CSV converter flattens a JSON array of objects into rows, using the union of every object’s keys as the header row, with proper quoting for values containing commas, quotes, or line breaks. Using the union of every object’s keys as the header row means objects with missing fields simply get an empty cell in that column rather than causing an error, keeping every row aligned to the same column structure even when the source JSON is not perfectly uniform.
How it works
- Paste a JSON array of flat objects, e.g. [{"name":"Ada"}].
- Read the converted CSV immediately below.
- Copy the result and paste it into a spreadsheet.
Formula headers = union of all object keys; each object becomes one CSV row
Frequently asked questions
What if objects have different keys?
The header row is the union of every key seen across all objects; missing values become empty cells.
Does this handle nested objects or arrays as values?
No — every array item must be a flat object (string/number/boolean/null values only). Flatten nested data first.
Are values with commas or quotes handled correctly?
Yes — they are quoted and escaped per standard CSV (RFC 4180) rules so spreadsheets read them correctly.
What line endings does the output use?
CRLF (\r\n), the CSV convention most spreadsheet software expects.
Is my data uploaded anywhere?
No. Conversion runs entirely in your browser.