正在加载，请稍候…

JSON to CSV Converter

Convert JSON arrays to CSV format online with automatic column header detection. Paste your JSON data and download a ready-to-use CSV file for Excel, Google Sheets, or databases.

How to Use

  1. Step 1: Paste your JSON array into the input field.
  2. Step 2: The tool auto-detects column headers from the JSON keys.
  3. Step 3: Review the CSV output and click Copy or Download.

Frequently Asked Questions

What JSON structure is supported?

The tool supports a JSON array of objects.

What if my JSON objects have different keys?

The tool merges all unique keys as column headers. Missing fields are left empty in the CSV output.

How does the tool handle nested objects when converting JSON to CSV?

The tool automatically flattens nested objects using dot notation as column headers — for example, address.city becomes its own column. Nested arrays are serialized as strings within their cell. This approach preserves all data, though complex deeply nested structures may require manual post-processing for specific use cases.

How do I handle nested objects and arrays when converting JSON to CSV?

CSV is a flat 2D structure with no native support for nesting. Common strategies: flattening (expand user.address.city into a column named user_address_city); serialization (convert nested objects to JSON strings in a cell — poor readability); normalization (split into multiple CSVs linked by IDs). Choose based on downstream use: flattening for data analysis, normalization for database import.