Home › Toolkit › Developer › JSON to CSV

📤 JSON to CSV

The API gave you JSON; the boss wants a spreadsheet. Paste an array of records and get a proper CSV back — headers from the keys, commas and quotes escaped the correct way.

About this tool

CSV looks like the simplest format in computing — values separated by commas — right up until a value contains a comma, a quote or a line break. This converter follows the actual rules: fields that need quoting get quotes, quotes inside fields are doubled, and nested objects are written as compact JSON inside their cell rather than exploding your columns. The header row is the union of every key in the array, so a record with an extra field does not silently lose it.

The input it expects is the shape APIs actually return: an array of flat objects. Feed it that and the output opens cleanly in Excel, Google Sheets or any database importer. Feed it something else — a single object, deeply nested structures — and it will still do something sensible, but flat records are where CSV shines, because a spreadsheet is flat too.

How to use it

  1. Paste a JSON array of objects.
  2. Press Convert to CSV.
  3. Copy the result or download it as a .csv file.

Good to know

  • Check the first data row against the headers after opening in a spreadsheet — a two-second sanity check that catches shape surprises.
  • Booleans and numbers export as their plain values; null becomes an empty cell, which is what spreadsheet tools expect.
  • For the return trip, the CSV to JSON tool sits in the same category.

Frequently asked questions

What if my objects have different keys?

The header includes every key seen anywhere in the array; records missing a key get an empty cell in that column.

How are nested objects handled?

They are written as JSON text inside the cell, so no data is lost and the row count stays one per record.

Is my data uploaded?

No — conversion happens entirely in your browser.

More Developer tools

Making videos too? Try our YouTube SEO Checker, or browse the full Toolkit and the free YouTube tools.