JSON to CSV Converter — Convert JSON to CSV Online
Convert JSON arrays to CSV — nested flattening · custom delimiter · live preview · Excel download · 100% Free
JSON is great for APIs but terrible for spreadsheet analysis. Converting JSON to CSV makes your data accessible to business teams in Excel, analysts in Google Sheets and data scientists in pandas. This converter handles flat JSON and nested JSON (with flattening), arrays of objects, custom delimiters and proper CSV escaping — download the output directly as a .csv file.
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
What JSON structures can be converted to CSV?
CSV is tabular — it works best with: (1) Array of flat objects: [{...},{...}] — each object becomes a row. (2) Array of objects with consistent keys — same keys across all objects. Not ideal for: deeply nested JSON (requires flattening decisions), arrays within arrays (which level to tabulate?), JSON with inconsistent keys across objects (missing values filled with empty).
How does nested JSON get flattened to CSV columns?
Flattening uses dot-notation: {"user":{"name":"Raj","city":"Mumbai"}} → columns: user.name, user.city. Nested arrays become one column per index: {"tags":["a","b"]} → columns: tags.0, tags.1. You can choose flattening depth — flatten only 1 level, or flatten all the way. Deep flattening can create many columns for complex JSON.
How do I convert JSON to CSV for use in Excel?
Download as .csv from this tool, then: (1) Open Excel → Data → From Text/CSV. (2) Or drag the .csv file directly into Excel. (3) Excel opens CSV import wizard — select comma delimiter, UTF-8 encoding. Tip: if your data contains commas, use semicolon or tab delimiter instead to avoid column splitting issues.
What about special characters in JSON when converting to CSV?
CSV escaping rules: values containing commas must be quoted: "London, UK". Values containing double quotes: escaped as "": "He said ""hello""". Newlines within values: the entire value is quoted. This tool handles all these cases correctly. For international characters (Hindi, Gujarati), ensure UTF-8 encoding is selected when opening in Excel.