What is it?
JSON to CSV turns a JSON array of objects (for example an API response or an export) into a table you can open in Excel or Google Sheets.
Who is it for?
Analysts and office staff who receive JSON exports or API data but work in Excel or Google Sheets, and developers making reports for non-technical colleagues.
How to use it
- Paste JSON: ideally an array like
[{"name":"Ravi","city":"Delhi"}, …]. - Choose the Separator (comma for most; semicolon for Excel in countries that use a decimal comma).
- Keep Excel-friendly (keeps ₹, é, Hindi…) ticked if you’ll open it in Excel. Download the CSV.
How the table is made
- Each object is a row; every key found in any object becomes a column, so rows with missing keys get empty cells.
- Nested objects become columns with dotted names, like
address.city. - Lists inside a row are written into one cell.
Problems and fixes
- ₹, é or Hindi show as garbage in Excel: tick Excel-friendly, which adds a marker that tells Excel the file is UTF-8.
- Everything is in one column in Excel: your Excel expects semicolons. Choose semicolon as the separator, or use Data → From Text/CSV and choose comma.
- Long numbers become 9.19877E+11: Excel’s display, not the file. Format the column as Text, or import it as Text.
- Not valid JSON: check it with the JSON Formatter first. If your JSON is one object holding the array (like
{"data":[…]}), paste just the array.
Open the tool: JSON to CSV
Still stuck?
Contact support. Tell us which tool or page you were using, what you tapped, what you saw, and your phone or computer and browser (for example: Android phone, Chrome). We reply by email.
Questions, or an error not listed here?
Tell us in the comments: what you were doing, the exact message you saw, and your device and browser. We read every comment and add new fixes to this article.