JSON Toolkit

Fast, private JSON tools that run in your browser.

🔒 Data stays in your browser

JSON to CSV Converter

Turn an array of JSON objects into a CSV file that opens correctly in Excel, Google Sheets and Numbers. Every key becomes a column, missing values become empty cells, and nested objects are kept as JSON text.

JSON ⇄ CSV Converter

Convert an array of JSON objects into a CSV file for spreadsheets.

How to use the JSON to CSV Converter

  1. Paste an array of JSON objects, such as [{"name": "Amit", "age": 25}].
  2. Choose a delimiter: comma for most tools, semicolon for European Excel.
  3. Click Convert to CSV, then copy the result or download it as a .csv file.

Features

  • Columns from every key across all rows, in the order they first appear
  • Correct quoting of commas, quotes and line breaks
  • Comma, semicolon, tab or pipe delimiters
  • Downloads include a UTF-8 marker, so Excel shows accents and emoji correctly
  • Nested objects and arrays are written as JSON text in a single cell

Frequently asked questions

What kind of JSON can be converted?
An array of objects, such as [{"name": "Amit"}, {"name": "Priya"}]. Each object becomes a row and each key becomes a column.
When should I use a semicolon delimiter?
Excel in many European countries expects semicolons, because the comma is used as the decimal separator there.
What happens to nested objects?
They are written into one cell as JSON text, for example {"city":"Pune"}. Converting the CSV back with the CSV to JSON converter turns them into objects again.

Related tools