JSON to CSV
This free online JSON to CSV converter turns an array of JSON objects into a spreadsheet-ready CSV file in one paste.
How to use
- Paste a JSON array of objects into the editor below — each object becomes one CSV row.
- Check the generated table: headers come from your keys, nested values stay visible as JSON in their cell.
- Download the CSV file, or copy the text directly into your spreadsheet.
Frequently asked questions
What happens to nested objects and arrays?
Each nested value is serialized with JSON.stringify into the single cell of its column, so an address object stays one readable JSON string instead of being chopped into invented columns like address.city. Nothing is lost — paste the cell back through the JSON formatter to read it.
Which columns does the CSV have and in what order?
The header row is the union of all keys across your objects, in the order each key is first seen. Objects missing a key simply get an empty cell, so ragged records still line up under the right headers.
Will the file open correctly in Excel with Chinese text?
Yes — the download is UTF-8 encoded, so Chinese, Japanese and Korean characters are preserved. If your Excel version shows mojibake on double-click, use Data > From Text/CSV and pick UTF-8 once; Google Sheets opens it directly.
Why does my input have to be an array of objects?
CSV is a row-and-column format, so the converter maps each object to a row and each top-level key to a column. A bare object, a bare array of numbers or deeply heterogeneous input cannot be expressed as rows unambiguously, and the tool tells you so instead of guessing.
Related tools
About this tool
This free online JSON to CSV converter turns an array of JSON objects into a spreadsheet-ready CSV file in one paste. It is built for exporting API responses into Excel or Google Sheets, turning a product catalog into a shareable sheet, archiving log events for colleagues who live in spreadsheets, and preparing test fixtures your QA team can edit. Column headers are collected from the union of your object keys in first-seen order, values are quoted and escaped by the battle-tested CSV rules, so commas, quotes and line breaks inside your data cannot corrupt the table. Nested objects and arrays are serialized into their single cell as JSON text — visible, lossless and honest about the nesting instead of silently flattened into wrong columns. The conversion happens entirely in your browser: customer lists, order exports and analytics events with personal fields are processed locally on your own device and never uploaded, stored or logged. The result appears as text for a quick copy and as a downloadable .csv file with UTF-8 encoding that opens correctly in Excel and Google Sheets. Paste your JSON array below and get a table.