JSON to CSV Converter

How to convert JSON to CSV

1. Paste a JSON array into the input box. It can be an array of objects (e.g. [{"name":"Alice","age":30}]) or an array of arrays.
2. Choose the Delimiter for the output CSV: Comma, Tab, or Semicolon.
3. If your JSON is an array of arrays, check First row as headers to use the first array as the header row; otherwise leave it unchecked.
4. Click Convert to CSV. The CSV appears in the output box. Use Copy to clipboard to paste it into a spreadsheet or file.

Conversion runs in your browser; no data is sent to a server. For arrays of objects, keys from the first object become the CSV column headers. All processing is done locally for speed and privacy.

Example

This JSON array of objects:

[
  { "name": "Alice", "age": 30, "city": "NYC" },
  { "name": "Bob", "age": 25, "city": "LA" }
]

converts to CSV with a header row built from the keys:

name,age,city
Alice,30,NYC
Bob,25,LA

How the conversion behaves

• Columns come from all objects. The header row lists every key found, in the order each key first appears, so objects with different fields still line up. A missing value becomes an empty cell.
• Nested data is kept as text. If a value is itself an object or an array, it is written into the cell as JSON text rather than being flattened into extra columns.
• Special characters are escaped properly. A value containing the delimiter, a double quote, or a line break is wrapped in quotes, and any quote inside it is doubled, so spreadsheet programs read it back correctly.
• Null values become empty cells.
• The input must be an array. A single object on its own is not accepted; wrap it in square brackets to make it a one-item array.

Common uses

• Opening API responses in a spreadsheet to sort, filter, or share them with colleagues.
• Exporting records from a script or database tool into a format that Excel and Google Sheets understand.
• Choosing a semicolon or tab delimiter when your spreadsheet software expects it instead of a comma.

Troubleshooting and FAQ

I see "Invalid JSON". What should I check?

JSON requires double quotes around keys and text values, no trailing commas, and matching brackets. The message from your browser usually points to the position of the problem.

Why does my spreadsheet put everything in one column?

When you open the file, choose the same delimiter you selected here, or switch the delimiter option to match what your spreadsheet expects.

Is my data uploaded?

No. The conversion runs entirely in your browser.

How do I go the other way?

Use the CSV to JSON converter.