JSON to CSV Converter
Local ProcessingConvert a JSON array of objects into a CSV table or an Excel (.xlsx) file.
How It Works & Processing Standards
Convert a JSON array of objects into a CSV table or an Excel (.xlsx) file.
Tool processing runs in your browser. If you create a calculator or conversion share link, its values are included in the URL. See the privacy policy for account, analytics and advertising data.
Current Limits
- Desktop max file size: 50MB
- Mobile max file size: 20MB
Turns [{…}, {…}] data from an API into a table that Excel or Google Sheets can open. Keys from every object become columns; missing values are left blank.
What You Can Do
- Keys to columns
- Collects keys across objects for the header row.
- CSV or Excel
- Copy as text or download .xlsx.
How to Use JSON to CSV Converter
- 1Paste JSONPaste an array of objects.
- 2Choose outputText or Excel.
- 3Copy or saveCopy the CSV or download the file.
Examples
List of people
Input: [{"name":"민수","age":30},{"name":"지영","age":28}]
Result: name,age
민수,30
지영,28
Common Use Cases
- Tidying API responses in a spreadsheet
- Handing data to non-developers as a table
Frequently Asked Questions (FAQ)
What happens to nested objects?
Values that are objects or arrays cannot go into a table, so an error is shown. Flatten the JSON to dotted keys such as user.name first.