JSON ↔ CSV 转换器

About JSON to CSV Converter

This free online tool converts JSON data to CSV (Comma-Separated Values) format for use in spreadsheet applications like Microsoft Excel, Google Sheets, and LibreOffice Calc. It also converts CSV data back to JSON for use in web applications and APIs.

Supported JSON Structures

• Array of objects — The most common format. Each object becomes a row.
• Nested objects — Flattened using dot notation (e.g., address.city).
• Mixed types — Numbers, booleans, and null values are all handled correctly.
• Arrays within objects — Converted to JSON string representation in the cell.

Delimiter Options

• Comma (,) — Standard CSV format. Compatible with most applications.
• Semicolon (;) — Common in European locales where comma is the decimal separator.
• Tab — TSV format. Useful for data with commas in values.
• Pipe (|) — Alternative delimiter for data containing commas and semicolons.

How Nested Objects Are Flattened

When a JSON object contains nested objects, the "Flatten nested objects" option converts them using dot notation. For example, {"address": {"city": "NYC", "zip": "10001"}} becomes columns address.city and address.zip.