Question 1

What JSON structure works best for CSV conversion?

Accepted Answer

An array of flat objects is ideal: [{"name":"Alice","age":30},{"name":"Bob","age":25}]. Each object becomes one CSV row; object keys become column headers. Nested objects or arrays require flattening first, as CSV is inherently two-dimensional.

Question 2

What happens to nested JSON objects during conversion?

Accepted Answer

This tool flattens one level of nesting using dot notation (e.g. address.city becomes a column). Deeply nested structures or arrays within objects may need manual preprocessing. For complex transformations, consider jq or a dedicated ETL tool.

Question 3

How are special characters handled in CSV output?

Accepted Answer

Values containing commas, double quotes, or newlines are automatically wrapped in double quotes. Double quotes within values are escaped by doubling them (""). This follows RFC 4180 CSV standard, which is compatible with Excel, Google Sheets, and most data tools.

JSON 到 CSV 转换器

输入

结果

常见问题