JSON to CSV Converter

Turn a JSON array into a CSV table, or a CSV file into JSON. More data tools

Convert JSON to CSV and CSV to JSON

Paste an array of objects to get CSV that opens in Excel or Google Sheets. Nested objects are flattened into columns such as address.city, and every key that appears in any item becomes a column.

In the other direction, CSV to JSON reads the first row as headers, detects numbers and booleans, and can rebuild nested objects from dotted headers. Choose comma, semicolon, tab or pipe as the delimiter.

Features

  • Live: the result updates while you type.
  • Clear errors: the line, the reason and, where possible, a one-click fix.
  • Open and drop files, copy or download the result, and share your input as a link.
  • Send to another tool: pass the result straight to a related tool.
  • Private: Everything runs in your browser. Your data is not uploaded to any server.

Related data tools

Frequently asked questions

How are nested objects handled?

They are flattened into dotted columns. Turn flattening off to keep them as JSON text in one cell.

Will Excel open it?

Yes. Use the Download button and open the .csv file. Choose semicolon if your Excel uses it as the list separator.

What if some items have extra keys?

Every key becomes a column and missing values are left empty.

Is my data private?

Everything runs in your browser. Your data is not uploaded to any server. You can even use the tool offline once the page has loaded.