How do I convert JSON to CSV?

Paste your JSON array into the input box, pick a delimiter and the CSV appears instantly. Copy it or download a .csv file.

Can it handle nested JSON objects?

Yes. Nested objects and arrays are flattened with dot notation, such as user.address.city or tags.0, so they open cleanly in Excel or Google Sheets.

Does it also convert CSV to JSON?

Yes — switch to the CSV → JSON tab. Numbers, booleans and nulls are converted to real JSON types instead of strings.

Is my data uploaded anywhere?

No. The conversion runs entirely in your browser, so API payloads and customer exports never leave your device.

What if my records have different keys?

Headers are collected across every record and missing values are left blank, so rows stay aligned instead of shifting.

Can I use a semicolon or tab delimiter?

Yes. Comma, semicolon, tab and pipe are all supported — semicolon is the standard CSV separator in much of Europe.

Are commas and quotes inside values escaped?

Yes. Values containing the delimiter, quotes or line breaks are quoted and escaped per the RFC 4180 CSV standard.

Can I open the result in Excel?

Download the .csv file and open it directly in Excel, Google Sheets or Numbers. Use the semicolon delimiter if your locale expects it.

MyToolsBag

Search All Tools

JSON to CSV Converter

Convert JSON to CSV and CSV back to JSON in your browser — nested objects flattened, quotes escaped, nothing uploaded.

Delimiter

JSON input

CSV output

id,name,role,active
1,Ada Lovelace,Engineer,true
2,Alan Turing,Mathematician,false

This JSON to CSV converter turns an array of JSON objects into a spreadsheet-ready CSV file, and converts CSV back into clean, formatted JSON. Paste your data, pick a delimiter, then copy the result or download it as a .csv or .json file. Everything runs locally in your browser, so API payloads, exports and customer data never leave your machine.

Nested objects and arrays are flattened using dot notation — user.address.city or tags.0 — so deeply structured API responses still open cleanly in Excel, Google Sheets or Numbers. Column headers are collected across every record, so objects with different keys still line up instead of shifting rows out of place. Values that contain commas, quotes or line breaks are escaped to the RFC 4180 standard.

Going the other way, the CSV to JSON side parses quoted fields correctly and converts numbers, booleans and nulls to real JSON types rather than leaving everything as strings. Choose comma, semicolon, tab or pipe as the delimiter — semicolon is the default CSV separator across much of Europe, and tab-separated values are common in database and analytics exports.

JSON to CSV Converter

Frequently asked questions

Related tools