JSON ⇄ CSV converter
Paste JSON or CSV, or open a file. It converts as you type, entirely in your browser: your data is never uploaded.
Options
Paste JSON or CSV above to convert it.
Questions people ask
Is my file uploaded anywhere?
No. The conversion runs entirely in your browser. Files you open are read on your own device, and nothing you paste is sent to a server or put in the page address. You can even use it offline once the page has loaded.
How are nested JSON objects turned into columns?
With "Flatten nested objects" on, {"address": {"city": "Kolkata"}} becomes a column called address.city. Lists (arrays) are written into one cell as JSON text. Converting back, "Rebuild nested objects" turns address.city into nested JSON again.
Why do PIN codes and phone numbers stay as text?
Columns named like PIN, phone, mobile, Aadhaar, PAN, account number, IFSC or GSTIN are always kept as text, and so is any value with a leading zero (like 070019) or a very long digit string, because turning them into numbers can lose digits. Other plain numbers like 12.5 become numbers when "Detect numbers and true/false" is on.
The CSV looks wrong in Excel. What should I do?
Keep "Excel-friendly download" on: it adds a marker that tells Excel the file is UTF-8, so Hindi, Bengali and ₹ show correctly. If your Excel uses semicolons (common with European regional settings), pick the semicolon delimiter.
Spotted a wrong number? Tell us and we'll fix it.