JSON to CSV Converter

Turn a JSON array of records into a CSV file that opens cleanly in a spreadsheet.

How to use

What it checks and how it works

The tool writes CSV with Papa Parse, following the quoting rules of RFC 4180. The columns are the union of the keys across all records, in the order they first appear, and a missing key becomes an empty cell. Nested objects are flattened into dot-separated columns, and arrays are written as JSON text inside the cell. A cell that starts with = + - or @ can run as a formula when opened in a spreadsheet; the OWASP CSV injection guidance recommends prefixing such cells, which the guard option does. The guard changes the text of those cells, so leave it off for trusted data.

Why does Excel show broken Arabic letters?

Excel often assumes a legacy encoding for a CSV file. Tick the UTF-8 byte order mark option so that Excel reads the file as UTF-8.

What happens to arrays inside a record?

An array is written as JSON text in one cell, because a CSV row cannot hold a list. Flatten the data first if you need one row per item.

What is the formula guard for?

It stops a cell such as =SUM(A1) from running when the file is opened in a spreadsheet, which matters when the data came from untrusted users.

Sources

Related tools

Privacy

Runs in your browser; nothing is uploaded. The interactive tool needs JavaScript.