JSON to CSV
Convert JSON arrays to CSV.
JSON to CSV Converter Online
The JSON to CSV converter turns JSON arrays into CSV files that open in Excel, Google Sheets, Numbers, or any database import tool. Nested objects are flattened into dot-notation columns, all rows get the same columns, and special characters are quoted correctly.
How it converts
- The tool finds the list of records: a top-level array, a single object, or an object wrapping one array (like
{"data": [...]}). - It collects every key that appears in any record, in order of first appearance, to build the header.
- Each record becomes one row; missing keys produce empty cells.
Flattening nested data
CSV is flat, JSON usually isn't. With Flatten nested objects on, {"address": {"city": "Rome"}} becomes a column named address.city, and arrays of simple values like ["admin", "editor"] are joined as admin, editor. Turn flattening off to keep nested structures as JSON text in a single cell — handy if you'll parse them again later.
RFC 4180 quoting
Values containing the delimiter, double quotes, line breaks, or leading/trailing spaces are wrapped in quotes, and quotes inside are doubled (" → ""). The result imports cleanly everywhere. Choose comma, semicolon, or pipe as the delimiter, and switch the header row on or off.
Typical uses
Exporting API responses for analysis, handing data to colleagues who live in spreadsheets, importing JSON into SQL databases or CRMs, and creating reports from logs.
Related tools
Need tabs instead of commas? Use JSON to TSV. For a real spreadsheet file, try JSON to Excel, or render the data as a web table with JSON to HTML.
Frequently Asked Questions
What JSON structure works best?
An array of objects, like most API list responses: each object becomes a row and each key a column. A single object becomes one row, and an object that wraps one array (such as {"users": [...]}) is unwrapped automatically.
How are nested objects and arrays handled?
With “Flatten nested objects” on, nested keys become dot-separated columns (address.city), and arrays of simple values are joined with commas in one cell. With it off, nested values are written as compact JSON text.
Why choose a semicolon delimiter?
In many European locales, Excel expects semicolons because the comma is the decimal separator. If your CSV opens in Excel with everything in one column, switch to semicolons.
Are quotes and commas inside values handled?
Yes, following RFC 4180: fields containing the delimiter, quotes, or line breaks are wrapped in double quotes and inner quotes are doubled. “Quote all fields” quotes every field for tools that require it.