JSON to CSV Converter — Free, Instant, No Signup

Q: How do I convert JSON to CSV for Excel?

Simply paste your JSON, let the tool auto-convert it, and click the Export Excel button. This generates a native .xlsx spreadsheet that opens perfectly in Microsoft Excel.

Q: How does the converter handle nested JSON arrays and objects?

Our parser automatically flattens nested JSON objects into distinct columns. You can also check the Expand arrays option to break complex nested arrays into multiple CSV rows.

Q: Why is my CSV output showing weird characters in Excel?

Excel struggles with standard UTF-8 CSVs. To fix this, change the Encoding dropdown to UTF-8 with BOM before downloading, or use our direct Export Excel button.

Delimiter

Encoding

Headers Flatten nested Expand arrays Trim values

🔗 URL

Line ending

Quote all fields Auto-convert

JSON Input

📂 File

📁

Drop JSON file here

CSV Output

Toggle columns

Rows: —Cols: —Size: —

Preview

JSON to CSV FAQ

How do I convert JSON to CSV for Excel?

Simply paste your JSON code or upload your file, let the tool auto-convert it, and click the "Export Excel" button. This generates a native `.xlsx` spreadsheet file that opens perfectly in Microsoft Excel without the garbled character encoding issues common with standard CSVs.

How does the converter handle nested JSON arrays and objects?

Our advanced parser automatically flattens nested JSON objects into distinct columns (e.g., `address.city`). If you have complex nested arrays, you can check the "Expand arrays" option to automatically break them down into multiple, easy-to-read CSV rows.

Why is my CSV output showing weird characters in Excel?

Excel often struggles to read standard UTF-8 CSV files natively. To fix this, change the "Encoding" dropdown to "UTF-8 with BOM" before downloading, or simply use our built-in "Export Excel" button for a flawless result.

JSON to CSV — Complete Guide

JSON (JavaScript Object Notation) and CSV (Comma-Separated Values) are two of the most widely used data interchange formats. JSON is the dominant format for REST APIs and NoSQL databases, while CSV is universally understood by spreadsheet applications and data pipelines.

What Makes a Good JSON-to-CSV Converter?

A robust converter handles: nested objects (flattened to dot-notation keys), arrays (either stringified or expanded to rows), mixed schemas (objects with different keys — missing values become empty cells), proper RFC 4180 quoting (fields containing commas, quotes, or newlines are wrapped in double-quotes), and character encoding (UTF-8 BOM for Excel compatibility).

Nested JSON Example

Input JSON:
[{"name":"Alice","address":{"city":"New York","zip":"10001"}}]

Output CSV (flattened):
name,address.city,address.zip
Alice,New York,10001

When to Use Which Delimiter

Comma (,) — Standard CSV, works everywhere
Semicolon (;) — Used in European locales where comma is the decimal separator
Tab (\t) — TSV format, best when data contains commas
Pipe (|) — Legacy systems, log files, avoids conflicts with both comma and semicolon

Convert JSON to CSV Online