JSON to CSV Converter

APIs, exports and config files often hand you data as JSON, but spreadsheets and many databases want rows and columns. This JSON to CSV converter turns a JSON array into a clean CSV file in one step, flattening nested objects into their own columns and quoting values exactly as the RFC 4180 CSV format describes. Preview the table, then copy the result or download a file ready for Excel or Google Sheets.

What Does Converting JSON to CSV Do?

JSON stores data as objects made of key and value pairs, and those objects can contain further objects and lists. CSV is flat: a header row of column names, then one line per record, with values separated by a delimiter. Converting means turning every object in your array into one row and every key into one column.

The tool collects every key it finds across all records, so a field that appears in only some objects still gets a column and is left blank where missing. With flattening on, a nested object such as address becomes columns like address.city and address.postcode. Any value containing the delimiter, a quote mark or a line break is wrapped in double quotes, and quotes inside are doubled, so spreadsheets read it correctly.

How to Use the JSON to CSV Converter

Step 1: Paste Your JSON

Paste a JSON array of objects into the box. A sample customer list is loaded so you can see how it works. If your JSON is an object that wraps an array, such as a typical API response with a data list, the tool finds that array for you.

Step 2: Choose Your Options

Pick a comma for most tools, a semicolon if your Excel uses a comma as the decimal separator, or a tab for pasting straight into a spreadsheet. Untick the header row if you are appending to an existing file, and untick flattening to keep nested objects as JSON text.

Step 3: Check the Output

The CSV updates as you type. The preview table shows the first five rows so you can confirm the columns line up. If a field holds Unix dates, the Unix timestamp converter turns them into readable dates before you share the sheet. If the JSON has a mistake, a message explains what went wrong instead.

Step 4: Copy or Download

Press Copy CSV to paste it elsewhere, or Download .csv to save a file. Need test records with IDs first? The UUID generator creates unique keys you can add to each object before converting. The stats show how many rows and columns were created.

Common JSON Errors and Fixes

Problem	Example	Fix
Single quotes	{'name': 'Olivia'}	Use double quotes for keys and text
Trailing comma	{"id": 1,}	Remove the comma after the last item
Unquoted key	{name: "Olivia"}	Wrap every key in double quotes
Several objects, no array	{...} {...}	Wrap them in [ ] and separate with commas

JSON is stricter than JavaScript, which is why these small slips cause errors. The official JSON syntax reference shows exactly which characters and structures are allowed.

Frequently Asked Questions