⇄

JSON to CSV Converter

Convert JSON arrays to CSV format. Preview your data, choose a delimiter, and download the file.

About this tool

Last updated:

Convert a JSON array to CSV

This JSON to CSV converter turns a JSON array of objects into a table you can open in Excel, Google Sheets or any CSV reader. Nested objects are flattened into their own columns, and you can preview the first rows before you copy or download the file.

How to use it

  1. Paste a JSON array into the input box, for example [{ "name": "Alice", "age": 30 }].
  2. Choose a Delimiter: comma, semicolon or tab.
  3. Tick or untick Include header row.
  4. Click Convert to CSV.
  5. Check the preview, then use Copy or Download .csv. The downloaded file is named output.csv.

How it works

Each object in the array becomes one row. The column list is built from every key found in any object, so objects with missing keys simply get empty cells. Nested objects become dotted column names: { "address": { "city": "Dubai" } } gives a column called address.city. Arrays and empty objects are not split up. They are written into one cell as JSON text.

What you see

  • Preview: the first 10 rows as a table with the column names as headers.
  • CSV Output: the full CSV text, with the Copy and Download buttons.
  • Errors: a message if the JSON is invalid, is not an array, is empty, or contains items that are not objects.

Assumptions and limits

  • The top level must be an array, and every item in it must be an object.
  • Cells containing the delimiter, quotes or line breaks are wrapped in double quotes, with inner quotes doubled.
  • A text value that starts with =, +, - or @ gets a leading apostrophe so spreadsheets do not run it as a formula. Real numbers are left as they are.
  • The download is plain UTF-8 text with no byte-order mark, so some older spreadsheet apps may need the encoding set on import.

Frequently asked questions

What happens to arrays inside an object?

They stay in a single cell as JSON text, such as ["admin","user"]. Only nested objects are flattened into separate columns.

Can I use semicolons for a European Excel?

Yes. Pick Semicolon as the delimiter before converting. Tab is also available for TSV-style output.

Why is there an apostrophe in front of some values?

It is added on purpose to text that begins with =, +, - or @, which spreadsheets can treat as a formula. If you do not want it, remove the apostrophe after import.

More to explore

Related Developer Tools

Browse all tools from the same category.

Showing 1-2 of 49