Free tools
JSON to CSV converter
Paste a JSON array and get CSV that opens in Excel, Google Sheets or any database import. Every key becomes a column, and values with commas, quotes or line breaks are quoted properly.
Runs in your browser. Nothing you type or open on this page is uploaded; it works with your connection switched off once the page has loaded.
How to use it
- Paste a JSON array, or open a .json file (it is read in the browser, not uploaded).
- Pick the delimiter: comma for most programs, semicolon if your Excel expects it, tab for pasting into a spreadsheet.
- Press Convert. Copy the CSV or download it as a .csv file.
Need this in bulk, or from code?
The same job is one HTTP call to our API: POST /v1/convert/json-to-csv. 100 calls a day free with no key; paid plans from $9 a month. One key
works for every API.
Questions
What JSON can it convert?
An array of objects (each object a row, each key a column), or an array of arrays (each inner array a row). If you paste an object that holds exactly one list, like an API response {"data": [...]}, that list is used and the page says so.
What happens when objects have different keys?
Every key that appears in any object becomes a column, in the order they first appear. A row without a key gets an empty field; nothing is dropped.
How are nested objects and arrays written?
As their JSON text in one field, for example [1,2]. Numbers and true/false are written as JSON writes them, and null as an empty field.
Will Excel open it correctly?
Values holding the delimiter, a quote or a line break are quoted, with quotes doubled, and lines end in CRLF, as Excel writes CSV itself. The file is UTF-8. Excel can garble accented letters when you double-click a UTF-8 CSV; tick “Mark as UTF-8 for Excel” before downloading and it reads them correctly.
Is my data uploaded?
No. The conversion happens in your browser.