JSON ⇄ CSV Converter
Convert a JSON array of objects to CSV, and CSV back to JSON.
Runs on your machine. Nothing you paste is uploaded.
Get JSON ⇄ CSV Converter and 121 other tools. Free for 7 days, no account needed.
What it does
Turn a JSON array of objects into CSV text you can open in a spreadsheet or import into a database. Each object becomes a row, and the header row is built from every key found across all objects, so records with extra or missing fields still line up in the right columns.
Missing values become empty cells. Nested objects and arrays are written as JSON inside the cell rather than dropped. Values containing commas, quotes or line breaks are quoted and escaped following the usual CSV rules. If the input is not a non-empty array, the tool says so instead of producing an empty file.
It also works the other way: paste CSV with a header row and get a JSON array back. Commas, tabs and semicolons are detected as separators, and numbers and true/false become JSON values, while values like zip codes with a leading zero or very long IDs stay strings so nothing is lost.
When you would reach for it
- Open an API response in Excel or Google Sheets to sort and filter it.
- Export a list of records for a teammate who works in spreadsheets.
- Prepare seed data for a database import that expects CSV.
- Turn a JSON log export into rows for a quick look.
- Turn a spreadsheet export into JSON fixtures for tests.
Also found by searching
- json
- csv
- convert
- table
- export
- import
- tsv
- parse