JSON to CSV Converter
Turn JSON arrays into spreadsheet-ready CSV.
Got API output you need in a spreadsheet? Paste a JSON array of objects, and this tool flattens it into CSV with headers from the object keys, quoting values that contain commas or quotes. Nested objects are flattened with dot paths, so nothing is lost. Copy the result, download a .csv file, and open it in Excel or Sheets. Everything runs in your browser.
Loading tool…
If the tool stays on this message, make sure JavaScript is enabled, then reload the page.
About JSON to CSV Converter
API responses, logs, and config exports usually arrive as JSON, but analysis happens in spreadsheets. This converter bridges the gap: paste a JSON array of objects and get CSV with headers taken from the object keys, ready to open in Excel or Google Sheets.
Nested data is the tricky part. A flat converter would drop it or print an unreadable object blob. Here, nested objects are flattened with dot paths, so an address object becomes address.city and address.zip columns. Arrays are kept as JSON text inside a single quoted cell, so the data survives the round trip.
If objects in your array have different keys, every key found anywhere becomes a column, and rows that lack a key get an empty cell.
How to use JSON to CSV Converter
- Paste a JSON array of objects.
- Click Convert to get CSV.
- Copy the output or download it as a .csv file.
- Open the file in Excel or Google Sheets.
Why use this tool?
- Flattens nested objects with dot paths
- Quotes values that contain commas or quotes
- Copy or download the CSV output
- Free with no account or signup
Tips for best results
- Validate messy JSON first with the JSON Formatter.
- Open the downloaded file in Excel or Sheets to check column alignment.
- Nested arrays stay as JSON text inside one cell.
- If headers look wrong, check that the top level is an array of objects.