Free Developer Tool

JSON to CSV Converter

Paste a JSON array and download a CSV file ready for Excel, Google Sheets, or any data analysis tool. Instant, free, runs entirely in your browser.

JSON array → spreadsheet rows

JSON Input
[
  {"id":1,"name":"Alice","role":"admin","active":true},
  {"id":2,"name":"Bob","role":"user","active":false},
  {"id":3,"name":"Carol","role":"guest","active":true}
]
CSV Output
"id","name","role","active"
1,"Alice","admin",true
2,"Bob","user",false
3,"Carol","guest",true

From JSON to spreadsheet in 3 steps

1
Paste your JSON array
Copy a JSON array from an API response, database export, or any source and paste it into the left panel. The array should contain objects with consistent keys.
2
Select CSV mode
Click the "→ CSV" tab in the toolbar. The converter automatically extracts all unique keys as column headers and maps each object to a row.
3
Download your CSV
Click the CSV download button in the export bar. The file opens directly in Excel, Google Sheets, or any spreadsheet application.
Try it — free

What the converter handles

All JSON types
Strings, numbers, booleans, and null values are all handled correctly. Nested objects and arrays are stringified into their cell.
Download .csv
Exports a properly formatted CSV file with quoted headers, escaped commas, and correct line endings (CRLF) for maximum compatibility.
100% Private
All conversion runs in your browser. Sensitive data from API responses, user exports, or database queries never reaches any server.

Convert your JSON to CSV now

Paste JSON, get a spreadsheet. Instant, free, no account needed.

Open Converter

Common questions

What JSON structure works best for CSV conversion?
CSV conversion works best with a JSON array of objects where each object has the same keys — like a database table or API list response. Example: [{"name":"Alice","age":30},{"name":"Bob","age":25}]. Each key becomes a column header; each object becomes a row.
What happens to nested objects?
Nested objects and arrays are JSON-stringified and placed as text in their cell. For example, "address": {"city": "Delhi"} becomes "{""city"":""Delhi""}" in the CSV. If you need nested data as separate columns, flatten the JSON first.
Can I open the CSV in Excel or Google Sheets?
Yes. The downloaded .csv file opens directly in Excel, Google Sheets, LibreOffice Calc, or Apple Numbers. Values are properly quoted and escaped, with correct line endings (CRLF) for Windows and web compatibility.
Can I also convert CSV back to JSON?
Yes! JSON Studio also supports CSV to JSON conversion. Just paste your CSV data in the input panel and select the CSV → JSON mode in the toolbar.

More free tools