JSON to CSV
Converter.
Convert JSON data to CSV format instantly. Transform JSON arrays and objects into spreadsheet-ready CSV files. Free online tool.
Input
Must be an array of objects. Each object becomes a row.
Output
Paste input and click
Convert to CSV to see results.
Need to do this on any website, at scale?
Browzey runs this — and hundreds of other browser tasks — in plain English. No copy-paste, no limit. Install the Chrome extension and try it yourself.
About This Tool
What is JSON to CSV Converter?
This tool converts JSON arrays into CSV (Comma-Separated Values) format. Perfect for exporting API data to spreadsheets or preparing data for import into Excel, Google Sheets, or databases.
How to Use This Tool
- Paste your JSON array into the input field
- Click "Convert to CSV"
- Copy or download the generated CSV
Input Requirements
- Format: JSON array of objects [{...}, {...}]
- Nested objects: Flattened with dot notation (e.g., address.city)
- Arrays in values: Converted to JSON strings
Example
Input JSON:
[
{"name": "John", "age": 30},
{"name": "Jane", "age": 25}
]Output CSV:
name,age John,30 Jane,25
Common Use Cases
- Export API responses to spreadsheets
- Convert database exports for analysis in Excel
- Prepare data for import into other systems
- Create reports from JSON data sources
Frequently Asked Questions
What JSON formats are supported?
The tool works best with an array of objects where each object has the same properties. Nested objects are flattened into dot-notation columns.
How are nested objects handled?
Nested properties are flattened using dot notation. For example, {user: {name: 'John'}} becomes a column named 'user.name'.
What happens to arrays in JSON?
Array values are converted to comma-separated strings within a single CSV cell. For complex arrays, you may need to preprocess the JSON.
Can I open the CSV in Excel?
Yes, the generated CSV uses standard formatting with UTF-8 encoding and is fully compatible with Excel, Google Sheets, and other spreadsheet applications.