JSON 转 CSV 有什么用?
CSV(Comma-Separated Values)是一种简单的表格数据格式,被 Excel、Google Sheets 等电子表格软件广泛支持。将 JSON 数据转换为 CSV 格式,可以方便地在电子表格中查看和编辑数据。
本工具的功能特点:
- 自动提取列:从所有 JSON 对象中收集键名作为 CSV 列
- 自定义分隔符:支持逗号、分号和制表符分隔
- 表头控制:可选择是否包含列名表头行
- 字段转义:自动处理包含分隔符、引号和换行的字段
输入必须是 JSON 数组格式,数组中的每个元素应该是一个对象。所有数据在浏览器本地处理。
Why Convert JSON to CSV?
CSV (Comma-Separated Values) is a simple tabular data format widely supported by Excel, Google Sheets, and other spreadsheet software. Converting JSON data to CSV makes it easy to view and edit data in spreadsheets.
Features:
- Auto Column Extraction — Collects keys from all JSON objects as CSV columns
- Custom Delimiter — Supports comma, semicolon, and tab separators
- Header Control — Option to include or exclude the column name header row
- Field Escaping — Automatically handles fields containing delimiters, quotes, and newlines
Input must be a JSON array where each element is an object. All data is processed locally in your browser.