JSON to CSV Converter
Convert a JSON array of objects to CSV in your browser, ready for Excel or Google Sheets.
What it is for?What it is for?
Use this when an API response or a database export arrives as JSON and someone needs it in Excel or Google Sheets. Paste the JSON, choose the separator, then copy the CSV or download it as a file.
Columns and nested values
Every key that appears in any object becomes a column, in the order it is first seen. Nested objects and arrays are written as JSON inside their cell. A field that contains the separator, a quote or a line break is wrapped in quotes. The downloaded file starts with a UTF-8 byte order mark so Excel shows ç, ğ and ş correctly.
Only the downloaded data.csv has that mark. Text you copy from the box does not.
What input works
- An array of objects gives one row per object, under a header row of keys.
- A single object is treated as a table with one row.
- An array of arrays is written row by row, without a header row.
- null values and missing keys become empty cells.
- If the JSON is invalid, the parser's error message is shown in place of the CSV.
Which separator?
Excel opens a CSV with the list separator from the computer's regional settings. In Turkish and many European locales that is a semicolon, so the Turkish version of this page selects semicolon by default. Choose comma for English Excel, Google Sheets and most scripts. Tab is a good choice when the values themselves contain many commas.
It stays in the browser
The conversion and the download happen in this tab. The JSON is not uploaded.