About the JSON to CSV Converter
APIs and apps usually export data as JSON, but spreadsheets expect CSV. The JSON to CSV Converter turns a JSON array of objects into a clean table where every object becomes a row and every property becomes a column, ready for Excel, Google Sheets, LibreOffice or database imports.
Nested objects are flattened into dotted column names like address.zip, simple arrays are joined into one cell, and objects with different fields are merged into a single set of columns. Values containing commas, quotes or line breaks are escaped correctly. Choose comma, semicolon (common in Europe) or tab separators, and download a UTF-8 CSV file that opens correctly in Excel, even with Urdu or Arabic text.
How to use the JSON to CSV Converter
- Paste a JSON array (or a single object).
- Choose the separator.
- Check the CSV preview on the right.
- Copy it or download data.csv.
Frequently asked questions
How are nested objects handled?
They are flattened into columns with dotted names, for example user.name and user.email.
Why do special characters look wrong in Excel?
The download includes a UTF-8 byte order mark so Excel recognizes the encoding. If you copy and paste instead, use Excel's Data → From Text/CSV import with UTF-8.
