{ }
No signupJSON Formatter
Format, validate, and minify JSON with syntax highlighting.
Open toolCSV
JSON to CSV
Convert JSON arrays into clean, downloadable CSV files.
json-to-csv.tool
0 chars
CSV output will appear hereNothing you paste here is ever sent to a server - conversion happens locally in your browser.
What is a json to csv?
This tool converts a JSON array of objects into a CSV (comma-separated values) file - the format spreadsheets, databases, and most data-import tools expect. It automatically works out the full set of columns across all your rows, so even objects with slightly different fields still line up correctly, with missing values left blank.
How to use this tool
- 1Paste a JSON array of objects - or a single object, or an array of plain values - into the input box.
- 2Pick a delimiter (comma, semicolon, tab, or pipe) to match what your target tool expects.
- 3Toggle Headers on or off depending on whether the first row should contain column names.
- 4Click Convert, then Copy the result or Download it directly as a .csv file.
Common use cases
Turning an API response into a spreadsheet you can open in Excel or Google Sheets
Preparing a JSON export for import into a CRM, database, or analytics tool
Converting a list of log entries or records into CSV for quick filtering
Sharing structured data with someone who doesn't work with JSON
Good to know
Frequently asked questions
What happens if my objects have different fields?
The tool collects the full set of keys across every object in the array and uses that as the column list. Any row missing a particular key just gets an empty cell there - nothing breaks.
What if a value contains a comma or a quote?
It's automatically wrapped in quotes and any internal quotes are escaped, following standard CSV quoting rules - so the file still opens correctly in Excel, Sheets, or any CSV parser.
Can I convert a single JSON object instead of an array?
Yes - a single object is automatically treated as one row. An array of plain values (like a list of strings) is converted into a single-column CSV.
What happens to nested objects or arrays inside a field?
Since CSV is flat, any nested object or array value is converted to its JSON string representation inside that cell, rather than being split into extra columns.
quick_facts.json
{
"runs_in_browser": true,
"data_sent_to_server": false,
"signup_required": false,
"price": "free",
"category": "JSON Tools"
}