Convert JSON to CSV
Turn an array of JSON objects into a CSV file that opens in any spreadsheet.
JSON input
Paste text or drop a file here (up to 50 MB).
CSV result
Convert the other way: CSV to JSON
Free to use. Your input stays in this browser.
How to use it
- Paste a JSON array of objects, such as an API response.
- Choose the delimiter. Use a semicolon if your Excel expects one.
- Copy the CSV or download it. The downloaded file opens in Excel with the correct characters.
Each object becomes a row. Columns follow the order in which keys first appear, nested objects become columns such as address.city, and arrays are written as JSON text.
If the JSON is an object around one array, such as {"users": [...]}, that array is used. Downloads start with a UTF-8 byte order mark so Excel shows accented and non-Latin text correctly.
Example
[{"id":1,"name":"Ada","email":"[email protected]","address":{"city":"London","country":"UK"},"tags":["admin","dev"]},{"id":2,"name":"Grace","email":"[email protected]","address":{"city":"New York","country":"US"},"tags":[]}]id,name,email,address.city,address.country,tags
1,Ada,[email protected],London,UK,"[""admin"",""dev""]"
2,Grace,[email protected],New York,US,[]