JSON to Excel Online Converter — Download CSV for Excel
Convert JSON arrays to CSV — nested flattening · custom delimiter · live preview · Excel download · 100% Free
Excel remains the king of business data analysis — and this tool creates Excel-compatible CSV files from any JSON data. Choose comma, semicolon or tab delimiter based on your regional Excel settings (semicolon is default in many European and Indian Excel installations). Download UTF-8 encoded CSV that opens cleanly in all Excel versions.
What is JSON to CSV Conversion?
JSON to CSV conversion transforms JavaScript Object Notation (JSON) data into Comma Separated Values (CSV) — a flat, plain-text format that can be opened in Microsoft Excel, Google Sheets, LibreOffice Calc, or imported into any database. CalcNation's JSON to CSV converter handles nested objects, arrays, inconsistent keys, and custom delimiters — all 100% in your browser.
Options Explained
Flatten Nested JSON — Converts nested objects to dot-notation columns. E.g. { "address": { "city": "X" } } becomes the column address.city. Flatten Arrays — Expands array items to separate columns: tags[0], tags[1]… Delimiter — Choose comma (standard), semicolon (European Excel), tab (TSV for Excel paste), pipe, or a custom character. Header Row — Toggle whether the first CSV row contains column names.
Frequently Asked Questions
Why does my CSV show garbled text when opened in Excel?
Excel encoding issue — classic problem. Fix: (1) Enable "UTF-8 with BOM" in this converter (adds byte order mark). (2) Or open Excel → Data → From Text/CSV → select UTF-8 encoding in wizard. (3) Or use Data → Get External Data → From Text for older Excel. Hindi/Gujarati characters need UTF-8 — not the default ANSI that Excel uses.
What delimiter should I use for Excel CSV in India?
Comma (,) works for most Indian Excel installations. But if your data contains amounts like "1,23,456" (Indian number format with commas), use Tab or Semicolon as delimiter to avoid column splitting. For European Excel installations (Germany, France), Semicolon is the default delimiter. Always test with your target Excel environment.
Can I create an Excel table with filters from JSON?
CSV doesn't support Excel features like filters, formulas or formatting. For proper Excel files: use SheetJS (xlsx npm package) to create .xlsx with tables. Example: const wb = XLSX.utils.book_new(); const ws = XLSX.utils.json_to_sheet(jsonData); XLSX.utils.book_append_sheet(wb, ws, "Data"); XLSX.writeFile(wb, "output.xlsx"). This creates a full .xlsx file with column auto-sizing support.
How do I convert JSON dates to Excel date format?
JSON dates are usually strings like "2025-03-01" or Unix timestamps like 1740844800. CSV stores them as text — Excel may not recognise them as dates. Fix: (1) Format as Excel date serial: Excel dates = days since Jan 1, 1900. (2) Or keep as ISO string — Excel understands "YYYY-MM-DD" format and auto-converts. (3) In Excel: select column, Format Cells → Date.