⇌

JSON to CSV Converter

Convert JSON arrays to CSV — nested flattening · custom delimiter · live preview · Excel download · 100% Free

JSON INPUT

📂

⚙ OPTIONS

DELIMITER

Flatten Nested JSON { "address": { "city": "X" } } → address.city Flatten Arraystags[0], tags[1]… instead of "[...]"Include Header RowFirst row = column names

CSV OUTPUT

⇌

CSV output appears here

Paste JSON on the left · click a Sample · or drop a .json file

Ctrl+Enter ConvertCtrl+Shift+C CopyCtrl+L ClearCtrl+S DownloadV PreviewP Pin

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 is JSON to CSV conversion?

JSON to CSV conversion transforms JavaScript Object Notation (JSON) data into Comma Separated Values (CSV) format — a plain-text format supported by Excel, Google Sheets, and any database import tool.

What does "Flatten Nested JSON" mean?

When JSON has nested objects (e.g. { "address": { "city": "Ahmedabad" } }), flattening converts them into dot-notation columns (address.city) so every value gets its own CSV column.

Can I use a custom delimiter?

Yes. Besides comma, you can choose semicolon (common in European locales), tab (TSV format for Excel), pipe (|), or type any custom character.

Is my data safe?

Yes. All conversion happens 100% in your browser using JavaScript. No data is uploaded to any server.

What if my JSON has inconsistent keys?

The converter performs a union of all keys across all rows. Rows missing a key will have an empty cell for that column.

Can I open the CSV in Excel?

Yes. Download the .csv file and open it directly in Excel, Google Sheets, or any spreadsheet application. For non-English data, use UTF-8 import settings.