Free JSON to CSV Converter
Convert JSON arrays to CSV format. Automatically detects headers from JSON keys. Download as a .csv file instantly. Free, with no sign-up required — everything happens right in your browser, so nothing you enter is sent to a server.
🔄 JSON to CSV Converter
How the JSON to CSV Converter Works
Paste a JSON array of objects and press Convert. The tool collects every distinct key used across all the objects as the column headings, then writes one row per object. If an object lacks a key, that cell is left empty. A single object instead of an array is treated as one row.
Values are written following CSV rules: a value that contains the delimiter, a double quote or a line break is wrapped in quotes, and any quote inside it is doubled, so spreadsheets read it back correctly. Nested objects and arrays do not fit into a flat table, so they are written as JSON text inside the cell. Choose the delimiter that matches your spreadsheet's regional settings, such as a semicolon where the comma is the decimal separator.
Practical Use Cases
- Open API results in Excel or Google Sheets for analysis.
- Share JSON data with colleagues who work in spreadsheets.
- Prepare data for import into a tool that accepts CSV.
- Check the keys and structure of a JSON dataset at a glance.
Tips for Best Results
- Flatten nested JSON first if you need separate columns. Nested objects and arrays are written as JSON text in a single cell, which spreadsheets cannot filter.
- Choose the delimiter that matches your spreadsheet's regional settings. In many European locales Excel expects a semicolon instead of a comma.
- Check the first rows in your spreadsheet after opening. Long numbers such as card-style IDs and values with leading zeros may be reformatted by the spreadsheet itself.
Frequently Asked Questions
Read the Guide
Want the background behind this tool? Our step-by-step guide explains how it works and when to use it: