JSON to CSV

Convert a JSON array into CSV that opens in Excel and Google Sheets.

🔒 Everything runs in your browser. Nothing you choose or type is uploaded. How to verify

How to use it

Paste a JSON array.
Pick the separator.
Select Run and copy or download the CSV.

Handy for

Opening API data in Excel or Google Sheets.

Good to know

Columns are the combined keys of all objects. A missing value becomes an empty cell. Use the semicolon separator for spreadsheets that expect it in your region.

Privacy: where the work happens

Everything you enter or choose is processed by JavaScript in your browser and never sent anywhere. Only the page code, and any library this tool needs, is downloaded from cdnjs or jsDelivr.

Questions

What JSON shape works?

An array of objects, or an array of arrays. Nested values are written as JSON text.

What is the spreadsheet safety option?

It adds a leading apostrophe to cells starting with = + - or @, so spreadsheets do not run them as formulas.