JSON to CSV Converter
Convert JSON to CSV instantly. Paste JSON or upload a file. Choose delimiter (comma, semicolon, tab) and how to handle nested objects (flatten or stringify). All processing runs locally.
How it works
When to Export JSON to CSV
Converting JSON to CSV is useful when:
- Spreadsheet import: Import API data or app exports into Excel or Google Sheets
- Database export: Export JSON from document stores to tabular format for analysis
- Data sharing: Share structured data in a universal format that non-developers can open
- Reporting: Feed JSON into reporting tools that expect CSV input
Examples
Example 1: Array of Objects
Input: [{"name":"John","age":30},{"name":"Jane","age":25}]
Output: name,age\nJohn,30\nJane,25
Example 2: Nested with Flatten
Input: [{"user":{"name":"Alice","city":"NYC"}}]
Select "Flatten". Output: user.name,user.city\nAlice,NYC
Example 3: Array of Arrays
Input: [[1,2,3],[4,5,6]]
Output: one row per inner array. Use comma delimiter.
Frequently Asked Questions
When should I use JSON to CSV?
Use it when you need to open JSON data in Excel, import into a database that expects CSV, or share data with stakeholders who prefer spreadsheets.
How are nested objects handled?
Choose "Flatten" to expand nested objects into columns like parent.child, or "Stringify" to keep the full JSON string in a single column.
Can I use semicolon or tab as delimiter?
Yes. Select comma, semicolon, or tab. European spreadsheets often use semicolons.
Is there a file size limit?
Yes. Paste is limited to 1 MB and file upload to 5 MB. Larger files may cause performance issues.
Does it support arrays of objects?
Yes. The converter expects an array of objects (or a single object, which is wrapped automatically). Array of arrays is also supported.