JSON to CSV Converter
Paste a JSON array and get a CSV you can open in Excel or Google Sheets. Nested fields are flattened into their own columns.
Do this inside Excel and Google Sheets with AI.
CoreGPT writes formulas, cleans columns and compares data right in your spreadsheet. Ask in plain English.
JSON is how apps and APIs exchange data; CSV is what spreadsheets open. This converter turns a JSON array of objects into rows and columns. Every key becomes a column, nested objects become columns such as address.city, and simple arrays are joined with semicolons. The download includes the marker Excel needs to read accented and non-Latin characters correctly. The conversion runs in your browser, so the data never leaves your computer.
- Opening an API response in Excel or Google Sheets
- Turning an app export into a spreadsheet for a report
- Sharing JSON data with someone who works in spreadsheets
- Checking JSON records as a table before importing them
- Preparing data for a pivot table or chart
- Paste an array of objects: [ {…}, {…} ]. A single object becomes one row
- Tick the semicolon option if Excel puts everything in one column when you open the file
- Objects with different keys are fine: missing values are left empty
- Very deep or irregular JSON may need tidying after conversion
- To go the other way, use the CSV to JSON converter
How do I open JSON in Excel?
Paste the JSON here, click Download .csv and open the file in Excel. Each object becomes a row and each key a column.
What happens to nested objects?
They are flattened. {"user": {"name": "Ana"}} becomes a column called user.name.
Why is everything in one column in Excel?
Your Excel expects semicolons instead of commas. Tick the semicolon option and download again.
Is my data uploaded?
No. The conversion happens in your browser.