验证 JSON
验证 JSON 代码是否存在错误
JSON 转 CSV
将 JSON 数据转换为 CSV 格式。支持嵌套对象和数组、自动检测表头以及可配置的分隔符和引用符——适用于 Excel、Google Sheets 或任何电子表格应用程序。
JSON 工具
JSON 输入
CSV 输出
工具选项
分隔符
字符串引用
自动（推荐）
仅引用包含分隔符、双引号或换行符的单元格。保持输出干净且最小化。始终引用
无论内容如何，都用双引号包裹每个单元格。表头
将 JSON 键用作第一行的列名。推荐用于可读性和导入兼容性。
JSON 转 CSV 示例
Array of objects
Convert multiple JSON objects into CSV rows, one row per object.
Input
[
{ "name": "John Doe", "age": 25, "city": "New York" },
{ "name": "Jane Doe", "age": 30, "city": "Los Angeles" },
{ "name": "Bob Smith", "age": 22, "city": "Chicago" }
]
[
{ "name": "John Doe", "age": 25, "city": "New York" },
{ "name": "Jane Doe", "age": 30, "city": "Los Angeles" },
{ "name": "Bob Smith", "age": 22, "city": "Chicago" }
]
Output
name,age,city
John Doe,25,New York
Jane Doe,30,Los Angeles
Bob Smith,22,Chicago
name,age,city
John Doe,25,New York
Jane Doe,30,Los Angeles
Bob Smith,22,Chicago
分隔符
字符串引用
自动（推荐）
仅引用包含分隔符、双引号或换行符的单元格。保持输出干净且最小化。始终引用
无论内容如何，都用双引号包裹每个单元格。表头
将 JSON 键用作第一行的列名。推荐用于可读性和导入兼容性。
Nested object (dot notation)
Nested keys are flattened using dot notation (e.g. address.city).
Input
[
{
"name": "John Doe",
"age": 25,
"address": {
"street": "123 Main St",
"city": "New York",
"state": "NY",
"postalCode": "10001"
},
"hobbies": ["reading", "running"]
}
]
[
{
"name": "John Doe",
"age": 25,
"address": {
"street": "123 Main St",
"city": "New York",
"state": "NY",
"postalCode": "10001"
},
"hobbies": ["reading", "running"]
}
]
Output
name,age,address.street,address.city,address.state,address.postalCode,hobbies[0],hobbies[1]
John Doe,25,123 Main St,New York,NY,10001,reading,running
name,age,address.street,address.city,address.state,address.postalCode,hobbies[0],hobbies[1]
John Doe,25,123 Main St,New York,NY,10001,reading,running
分隔符
字符串引用
自动（推荐）
仅引用包含分隔符、双引号或换行符的单元格。保持输出干净且最小化。始终引用
无论内容如何，都用双引号包裹每个单元格。表头
将 JSON 键用作第一行的列名。推荐用于可读性和导入兼容性。
Sparse rows
Missing keys are filled with empty values to keep columns aligned.
Input
[
{ "name": "Alice", "age": 30 },
{ "name": "Bob", "city": "Paris" },
{ "name": "Carol", "age": 25, "city": "Rome" }
]
[
{ "name": "Alice", "age": 30 },
{ "name": "Bob", "city": "Paris" },
{ "name": "Carol", "age": 25, "city": "Rome" }
]
Output
name,age,city
Alice,30,
Bob,,Paris
Carol,25,Rome
name,age,city
Alice,30,
Bob,,Paris
Carol,25,Rome
分隔符
字符串引用
自动（推荐）
仅引用包含分隔符、双引号或换行符的单元格。保持输出干净且最小化。始终引用
无论内容如何，都用双引号包裹每个单元格。表头
将 JSON 键用作第一行的列名。推荐用于可读性和导入兼容性。