Developer Tools
JSON to CSV Converter
Turn JSON from an API or database export into a CSV file you can open in Excel or Google Sheets. Nested objects are flattened into columns and every key becomes a header.
Convert JSON to CSV
Paste a JSON array of objects or open a .json file.
How to Convert JSON to CSV
- Paste JSON or open a .json file. The input should be an array of objects, such as a list of users or orders. If it is an object that contains an array (for example
{"data": [...]}), the first array is used. - Choose the delimiter. Use semicolons if your Excel uses a comma as the decimal separator.
- Press Convert to CSV and download the file.
How Nested Data Is Handled
CSV is a flat table, while JSON can be nested. With Flatten nested objects ticked, {"address": {"city": "Lahore"}} becomes a column named address.city. Arrays are written as JSON text in a single cell. All keys found in any object become columns, so records with missing fields simply get empty cells.
Opening the CSV in Excel
- If Urdu, Arabic, Hindi or other non-English characters show as strange symbols in Excel, tick Add BOM for Excel. It adds an invisible marker that tells Excel the file is UTF-8.
- Values containing commas, quotes or line breaks are automatically wrapped in quotes so columns stay aligned.
- Google Sheets reads UTF-8 CSV correctly without the BOM: use File → Import.
Privacy
Conversion runs in your browser. Your JSON is never uploaded.
Frequently Asked Questions
What JSON structure can be converted?
An array of objects works best. A single object becomes one row, and an object containing an array uses that array.
How are nested objects converted?
They are flattened into columns with dot notation, such as address.city. Arrays are stored as JSON text in one cell.
Why does Excel show garbled Urdu or Arabic text?
Excel does not assume UTF-8. Tick "Add BOM for Excel" and download the file again.
Is my data private?
Yes. Everything is processed in your browser.