Data
JSON to CSV Converter
Flatten a JSON array of objects into a spreadsheet-ready CSV with header row, RFC 4180 quoting, and comma, tab, semicolon, or pipe delimiters.
Data
CSV to JSON Converter
Turn CSV into a JSON array with one row per object. Optional header detection, configurable delimiter, and type coercion that turns 1/true/null into real JSON values.
工具摘要
此工具接收结构化输入，在浏览器中返回确定性输出，无需上传到服务器。
- 工具名称
- CSV to JSON Converter
- 输入意图
- 提供需要转换、校验或分析的原始内容。
- 输出意图
- 获得可直接复制、复用或排错的规范化输出。
- 示例输入
- id,name,active 1,Alice,true 2,Bob,false
- 示例输出
- [ { "id": 1, "name": "Alice", "active": true }, { "id": 2, "name": "Bob", "active": false } ]
Paste CSV above and click Convert to JSON.
工具介绍
Turn CSV into a JSON array with one row per object. Optional header detection, configurable delimiter, and type coercion that turns 1/true/null into real JSON values.
工具概览
The parser is RFC-4180 compliant: it handles quoted fields, escaped quotes ("" → "), mixed \n and \r\n line endings, and trailing blank lines. With header mode on, the first row becomes the JSON object keys; with it off, each row is output as an array. Type coercion converts bare integers, floats, true/false, and null into their JSON-native form — leaving ambiguous strings (like "007" or "01-02") alone.
使用场景
- Convert an Excel export to JSON for an API test
- Seed a web app fixture from a CSV file
- Pipe spreadsheet data into jq for filtering
- Prepare CSV survey data for a charting library
输入/输出示例
输入意图
id,name,active 1,Alice,true 2,Bob,false
输出意图
[
{ "id": 1, "name": "Alice", "active": true },
{ "id": 2, "name": "Bob", "active": false }
]Quoted fields handle commas and escaped quotes per RFC 4180.
输入意图
product,price,notes "Widget, Blue",19.99,"On ""sale""" Gadget,42,ships 2 weeks
输出意图
[
{ "product": "Widget, Blue", "price": 19.99, "notes": "On \"sale\"" },
{ "product": "Gadget", "price": 42, "notes": "ships 2 weeks" }
]TSV input with the header row disabled outputs an array of arrays. Numeric cells are coerced to numbers.
输入意图
1 Alice 2 Bob 3 Carol
输出意图
[ [1, "Alice"], [2, "Bob"], [3, "Carol"] ]
常见问题
Is this CSV to JSON converter free?+
Yes. Convert as much as you need — unlimited rows, no sign-up, no upload to any server.
Does it support tab-separated or semicolon-separated files?+
Yes. Change the delimiter option to Tab, Semicolon, or Pipe before converting. Excel exports from European locales typically use semicolons.
What is type coercion?+
When enabled, 1 becomes the number 1, "true" becomes the boolean true, and "null" becomes null. Turn it off to keep every cell as a string — useful when you want to preserve leading zeros like "007".
Can it handle quoted fields with commas inside?+
Yes. The parser follows RFC 4180: "a, b" is a single cell containing "a, b", and "" inside a quoted cell is treated as a literal double quote.
Is the first row always treated as the header?+
Only when the "First row is header" option is on (default). Turn it off and you get an array of arrays instead of an array of objects.
探索更多工具
在下方的 Data 分类中发现相关工具。
相关工具
精选可能对你有用的实用工具