1. Home
  2. Code
  3. JSON to CSV Converter

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?
Runs in your browser Free, no sign-up

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.