📊 JSON 转 CSV 在线转换器
Convert JSON arrays to CSV spreadsheet format online. Handles nested values, quoted fields, and special characters. Free, instant, no signup.
Paste a JSON array of objects and switch to JSON → CSV mode. Each key becomes a column header, each object becomes a row. Download the result or copy to clipboard. Table preview shows your data before you export.
How to Use
1
Choose direction
Select CSV → JSON to convert a spreadsheet to data, or JSON → CSV to export JSON as a table.
2
Paste your data
Paste CSV (with header row) or valid JSON array into the input area. The table preview updates live.
3
Copy or download
Click Copy or Download to save the output. Use the table preview to verify your data looks correct.
Frequently Asked Questions
How does CSV to JSON conversion work?
The first row of the CSV becomes the keys of each JSON object. Each subsequent row becomes one object in the JSON array. Values are trimmed of whitespace. Numbers and booleans are kept as strings unless you enable type inference.
How are commas inside values handled?
Values containing commas must be enclosed in double quotes in CSV format: "New York, NY". This tool correctly parses quoted fields including escaped double quotes (two consecutive double quotes represent one literal quote).
Can I convert nested JSON to CSV?
JSON→CSV works with flat arrays of objects. Nested objects are serialized as JSON strings within their cell. For deeply nested structures, flatten your JSON first using the JSON Formatter tool.
What does the table preview show?
After conversion, a table preview renders the data as an HTML table so you can visually inspect rows and columns before downloading. This helps catch misaligned columns or parsing errors.
Is there a file size limit?
There is no hard limit, but processing very large files (over 5MB) in the browser may be slow. Everything runs client-side — your data never leaves your device.
完整指南：CSV ↔ JSON转换工具
为什么需要转换？
CSV是表格数据的通用格式（Excel、Google表格、数据库导出），JSON是API标准。CSV→JSON用于将电子表格数据加载到API；JSON→CSV用于将API数据导出到Excel进行分析。
如何使用
- 选择方向：CSV转JSON或JSON转CSV。
- 粘贴数据。
- 配置选项：分隔符、标题处理、数据类型。
- 复制或下载结果。
专业技巧
- CSV值中包含逗号时，需用双引号括起来。
- 特殊字符需确保编码为UTF-8。
- CSV中的数字默认转为字符串——如需数值类型请启用自动类型检测。