JSON to CSV

Convert an array of JSON objects into a CSV table with a merged header row and properly escaped values.

The output will appear here.

How JSON to CSV works

Convert an array of JSON objects into a CSV table with a merged header row and properly escaped values.

Input JSON
Output CSV
Works done 2,057

Related tools

JSON to CSV Details

JSON to CSV Converter turns an array of JSON objects into a CSV table you can open in a spreadsheet.

Use it to shape an API response into a report, hand data to a colleague as a table, or scan records quickly.

How to use it

Everything runs on the page itself:

  1. Paste the JSON array into the box; a single object is accepted too.
  2. Run the tool; a header row and data rows are produced.
  3. Copy the output and save it as .csv, or download it directly.

Limits and processing behaviour

Conversion rules:

  • The header row is the union of the keys found across all objects.
  • A field missing from an object becomes an empty cell.
  • Every value is wrapped in double quotes, with inner quotes doubled to escape them.
  • The work happens in your browser; nothing is uploaded.

Is this the right tool

This page moves JSON into a table. For the other direction use CSV to JSON, and for readability only use the JSON Formatter.

Nested objects and arrays are not flattened — they land in the cell as they are, so deep structures need flattening first. Invalid JSON surfaces the parser error in the output panel.

Small things that help

  • Some spreadsheet locales open comma CSV in a single column; choose the comma separator on import.
  • Produce your objects with the same shape so column order stays stable.
  • For very large arrays, convert the first few records first and check the column layout.

Data and privacy

Because the input never reaches the server, nothing is left behind when you close the page. No request is made beyond the usage counter, and its body carries only the count itself.

Frequently asked questions

Type or paste your data into the JSON field, run the tool, then copy or download the CSV result.

Yes. While the text field is focused, Ctrl + Enter (Cmd + Enter on macOS) runs the tool.

You can copy the output or save it as a text file with the download button. The file name is based on the tool name.

The tool shows the error message in the output area. Fix the input and run it again.