JSON to CSV converter
Turn an array of JSON objects into spreadsheet rows. Pick the columns you want, check the preview, and download a CSV for Excel or Google Sheets. Your JSON isn’t uploaded; the conversion runs in your browser.
JSON array of objects
How your JSON becomes columns
Each object in the array becomes a row, and each field becomes a column. [{"name":"Maya","address":{"city":"Boston"}}] gives you the columns /name and /address/city, and one row with Maya and Boston. If some objects have fields that others don’t, you still get a column for every field, in the order they first appear.
Nested objects are flattened into path-style column names like /address/city. Arrays can’t be spread across columns, so they’re kept as JSON text in a single cell, like ["customer","vip"]. Missing fields, null, and empty strings all end up as empty cells, since CSV has no way to tell them apart. If an object repeats a key, you’ll get an error rather than having one of the values quietly dropped.
Commas, quotes, and line breaks inside values are handled, so each value stays in its own cell.
Opening the result in Excel
If you double-click a CSV, Excel guesses each column’s type, and it often guesses wrong. ZIP codes lose their leading zeros, and long numbers turn into things like 1.23457E+15. Use Data > From Text/CSV instead, and set those columns to Text before you load the data. The worked example below walks through it step by step.
By default, any cell that starts with =, +, -, or @ gets an apostrophe in front, so a spreadsheet won’t run it as a formula. That includes negative numbers. Turn the option off if you need every value exactly as it is.
The input has to be an array of objects. For an API response wrapped in something like {"results":[...]}, paste just the array inside. The limits are 2 MB, 10,000 rows, 200 columns, and 500,000 cells in the download. If the JSON has errors, fix them in the JSON validator first.
Follow a worked example: nested JSON to CSV for Excel
Going the other way? The CSV to JSON converter turns the file back into JSON, nested objects and all.