Turn a JSON array of objects into CSV, with correct escaping.
An array of objects
The standard case
[{"a":1,"b":"x"}]Uneven keys
Every key still gets a column
[{"a":1},{"b":2}]Nested data
Serialised or rejected, your choice
[{"tags":["x","y"]}]An array of objects, or a single object for one row.
Write them as JSON text, or reject the input so you can flatten it first.
Ready to open in a spreadsheet.
Columns come from every record, not just the first. A key present only in the last object still gets a column, so data is never silently dropped.
Commas, quotes, newlines and padded spaces are quoted per RFC 4180, so the file opens correctly rather than shifting into the wrong columns.
CSV is flat and JSON is not. Rather than inventing a flattening scheme, the tool asks what you want and says what it did.
Convert a JSON array of objects into CSV ready for a spreadsheet. Columns are discovered across every record in first-seen order, so a key that appears only in the last object still gets a column and nothing is lost. Fields are quoted exactly when RFC 4180 requires it — when they contain the delimiter, a quote, a line break, or leading and trailing spaces — and internal quotes are doubled. Nested objects and arrays have no canonical CSV form, so you choose explicitly: serialise them as JSON text in the cell, or reject the input. The tool will not guess.
Keep going
Related pages in Developer Tools, plus what others are using right now.
More developer tools that pair well with this one.
Turn CSV into JSON, with quoted fields and embedded commas handled properly.
Format, validate and minify JSON, with errors that point to the exact line.
Tidy YAML indentation, validate structure and convert between YAML and JSON.
Indent and validate XML, with clear messages when tags do not match.
Explain a cron expression in plain English and see exactly when it will next run.
Turn JSON into readable YAML, with quoting and multiline strings handled properly.
Create strong random passwords with full control over length and characters.
Work out any percentage — of a number, as a share, or as a change.
Count words, characters, sentences and paragraphs as you type.
Convert between length, weight, temperature, volume, speed, data and more.
Count characters with and without spaces, against the limits that matter.
Find the mean, median, mode and range of a list of numbers, with the working shown.
Sample and population standard deviation and variance, both shown, with the working.
Turn a logo into favicon.ico, the PNG sizes a site needs, and the HTML to declare them.
Check a downloaded file against its published checksum, without uploading anything.
Stamp text like DRAFT or CONFIDENTIAL across a PDF, in your browser.
See how savings grow with compounding, including regular contributions.
Shrink JPEG, PNG and WebP files with a quality slider and a live size comparison.