Skip to content

Free JSON to CSV Converter

Convert JSON arrays to CSV format. Automatically detects headers from JSON keys. Download as a .csv file instantly. Free, with no sign-up required — everything happens right in your browser, so nothing you enter is sent to a server.

🔄 JSON to CSV Converter

How the JSON to CSV Converter Works

Paste a JSON array of objects and press Convert. The tool collects every distinct key used across all the objects as the column headings, then writes one row per object. If an object lacks a key, that cell is left empty. A single object instead of an array is treated as one row.

Values are written following CSV rules: a value that contains the delimiter, a double quote or a line break is wrapped in quotes, and any quote inside it is doubled, so spreadsheets read it back correctly. Nested objects and arrays do not fit into a flat table, so they are written as JSON text inside the cell. Choose the delimiter that matches your spreadsheet's regional settings, such as a semicolon where the comma is the decimal separator.

Practical Use Cases

  • Open API results in Excel or Google Sheets for analysis.
  • Share JSON data with colleagues who work in spreadsheets.
  • Prepare data for import into a tool that accepts CSV.
  • Check the keys and structure of a JSON dataset at a glance.

Tips for Best Results

  • Flatten nested JSON first if you need separate columns. Nested objects and arrays are written as JSON text in a single cell, which spreadsheets cannot filter.
  • Choose the delimiter that matches your spreadsheet's regional settings. In many European locales Excel expects a semicolon instead of a comma.
  • Check the first rows in your spreadsheet after opening. Long numbers such as card-style IDs and values with leading zeros may be reformatted by the spreadsheet itself.

Frequently Asked Questions

An array of objects works best. Each object becomes a row and each key becomes a column heading. A single object is converted to one row.
All the distinct keys across the objects become headers, and missing values are left blank.
They are written as JSON text in a single cell, because CSV cannot represent nested data. Flatten the JSON first if you need separate columns.
Values containing the delimiter, quotes or line breaks are wrapped in double quotes, with inner quotes doubled, as the CSV standard requires.
No. The conversion is done in your browser, and your data is not sent to a server.