JSON to CSV
Free online JSON to CSV converter. Transform JSON arrays into CSV format instantly. Works with Excel, Google Sheets, and database imports.
How to Use JSON to CSV
Paste JSON Array
Paste a JSON array of objects into the input panel. Each object should have the same keys — these become the CSV column headers.
Click Convert
Click "JSON to CSV" to transform your data. The first row of the output will be the headers from your object keys.
Copy or Download
Copy the CSV output and paste it into Excel, Google Sheets, or any CSV-compatible tool.
Example
JSON
[
{"name":"John","age":30,"city":"New York"},
{"name":"Jane","age":25,"city":"London"},
{"name":"Bob","age":35,"city":"Paris"}
]CSV
name,age,city
John,30,New York
Jane,25,London
Bob,35,ParisFrequently Asked Questions
What JSON format does this tool expect?
The input should be a JSON array of objects, like [{"name":"John","age":30}, {"name":"Jane","age":25}]. Each object becomes a CSV row, and the keys of the first object become the column headers. If later objects have extra keys, they will appear as additional columns.
What about commas and quotes in my data?
Values containing commas, double quotes, or line breaks are automatically wrapped in double quotes and any internal quotes are escaped — this is standard CSV behavior and works correctly with Excel, Google Sheets, and most CSV parsers.
Can I convert nested JSON objects to CSV?
Nested objects and arrays are serialized as JSON strings in the CSV cell. For deeply nested data, you might want to use the JSON Flatten tool first, then convert the flattened result to CSV.
JSON to CSV: Practical Uses
JSON is the standard format for web APIs, but when you need to analyze data in a spreadsheet or import it into a database, CSV is what you want. This converter bridges that gap — take an API response, convert to CSV, and open it directly in Excel or Google Sheets.
A typical workflow: you call a REST API, get back a JSON array of records, run it through this converter, then import the CSV into a database with COPY (PostgreSQL) or LOAD DATA (MySQL). It's often the fastest way to get API data into a SQL database.
If your JSON has nested objects, the nested values will appear as JSON strings in the CSV cells. For flat data (like most API responses), the conversion is clean and 1:1.