What this tool does
Spreadsheets need flat rows and columns; JSON is nested key-value data. This tool reads every object in your array, collects every field name it finds across all of them, and lays them out as CSV columns — filling in a blank where a particular object doesn't have that field.
Example
JSON input:
[{"name":"Ali","city":"Jhelum"},{"name":"Sara","city":"Lahore","age":30}]
CSV output:
name,city,age Ali,Jhelum, Sara,Lahore,30
The age field exists only in the second object, so the first row has an empty cell in that column.
Handling nested values
If a field's value is itself an object or array, it's written into the CSV cell as a JSON string rather than dropped, so you don't lose any data — you can flatten it further in your spreadsheet if needed.
Common uses for JSON to CSV
Turn an API response into a spreadsheet. Paste the JSON array an API returns, convert it, and open the CSV in Excel or Google Sheets to sort, filter and chart it.
Export data for analysis. JSON logs, product lists, survey answers and database exports become rows and columns that a spreadsheet or a database import tool can read.
Share data with people who do not read code. A CSV opens in any spreadsheet app, so it is the simplest way to hand JSON data to a colleague or client.
The conversion runs in your browser, so private data is never uploaded, and there are no usage limits.
Frequently asked questions
What happens if my JSON objects have different fields?
The tool collects every field name found across all objects and uses that combined list as the CSV columns. If a particular object is missing a field, that cell is left blank in the output row instead of breaking the conversion.
Can I convert nested JSON to CSV?
Yes, but nested objects or arrays are written into their cell as a JSON string rather than split into separate columns, since CSV itself has no concept of nesting. This keeps all your data intact for further flattening if you need it.
Does this work with a single JSON object, not just an array?
Yes — if you paste a single object instead of an array, it's treated as one row and converted the same way.
Is my JSON uploaded to a server?
No. The conversion runs in your browser with JavaScript, so what you paste stays on your device.
How do I open the CSV in Excel or Google Sheets?
Download the .csv file and open it in Excel. In Google Sheets, use File, then Import, and choose the downloaded file.
Can I convert CSV back to JSON?
Yes, use the CSV to JSON converter.
Related tools
Check your JSON with the JSON Formatter before converting. Combine files first with Merge JSON, or break a large array into parts with the JSON Splitter. Prefer a config format? Try JSON to YAML.