How to use the JSON ⇄ CSV Converter
- Paste a JSON array (or CSV with a header row).
- Click JSON → CSV or CSV → JSON.
- Copy or download the result.
About this tool
APIs speak JSON; finance, sales and operations teams live in spreadsheets. This converter bridges the two. It collects every key across all objects to build the header row, so records with missing fields still line up, and it escapes commas, quotes and line breaks according to RFC 4180 so Excel and Google Sheets open the file cleanly.
Going the other way, the CSV parser handles quoted fields containing commas and doubled quotes, then maps each row to an object keyed by the header.
Frequently asked questions
What about nested objects?
Nested values are written as JSON strings inside the cell.
Excel shows weird characters?
Import via Data → From Text/CSV and choose UTF-8.