Data
CSV to JSON Converter
Convert CSV to a JSON array with header detection, type coercion, and RFC 4180 quoted-field handling. Supports TSV, semicolon, and pipe-delimited files.
Data
JSON to CSV Converter
Flatten a JSON array of objects into a spreadsheet-ready CSV, with a header row, RFC-4180 quoting, and your choice of delimiter (comma, tab, semicolon, pipe).
工具摘要
此工具接收结构化输入，在浏览器中返回确定性输出，无需上传到服务器。
- 工具名称
- JSON to CSV Converter
- 输入意图
- 提供需要转换、校验或分析的原始内容。
- 输出意图
- 获得可直接复制、复用或排错的规范化输出。
- 示例输入
- [{"id":1,"name":"Alice","role":"admin"},{"id":2,"name":"Bob","role":"user"}]
- 示例输出
- id,name,role 1,Alice,admin 2,Bob,user
Paste a JSON array of objects above and click Convert to CSV.
工具介绍
Flatten a JSON array of objects into a spreadsheet-ready CSV, with a header row, RFC-4180 quoting, and your choice of delimiter (comma, tab, semicolon, pipe).
工具概览
CSV remains the path of least resistance for moving tabular data between tools. This converter accepts a JSON array of objects (keys become column headers) or a JSON array of arrays (rows written as-is). Cells containing the delimiter, double quotes, or newlines are wrapped in quotes with internal quotes doubled, per RFC 4180. Nested objects and arrays are serialized back to JSON so they survive the round trip.
使用场景
- Export API responses into Google Sheets or Excel
- Seed a database import from a JSON fixture
- Ship analytics data to stakeholders who live in spreadsheets
- Create CSV test data from JSON samples
输入/输出示例
输入意图
[{"id":1,"name":"Alice","role":"admin"},{"id":2,"name":"Bob","role":"user"}]输出意图
id,name,role 1,Alice,admin 2,Bob,user
Cells containing the delimiter are automatically quoted (RFC 4180).
输入意图
[{"product":"Widget, Blue","price":19.99,"inStock":true},{"product":"Gadget","price":42,"inStock":false}]输出意图
product,price,inStock "Widget, Blue",19.99,true Gadget,42,false
Nested arrays are serialized back to JSON inside the cell so nothing is lost.
输入意图
[{"name":"Alice","tags":["admin","ops"]},{"name":"Bob","tags":["user"]}]输出意图
name,tags Alice,"[""admin"",""ops""]" Bob,"[""user""]"
常见问题
Is this JSON to CSV converter free?+
Yes. Unlimited conversions, no sign-up, no row limit, and everything runs in your browser.
What shape must my JSON have?+
Either an array of flat objects (keys become column headers) or an array of arrays (each inner array is a row). Mixed shapes will produce a validation error.
How are nested objects or arrays handled?+
They are serialized back to a JSON string inside the cell so no information is lost. If you need one column per nested field, flatten the JSON first or pre-process with jq.
Does it escape fields with commas, quotes, or newlines?+
Yes. Cells containing the delimiter, a double quote, or a newline are wrapped in quotes with internal quotes doubled, following RFC 4180.
Can I output tab-separated or semicolon-separated values?+
Yes. Change the delimiter option to Tab, Semicolon, or Pipe — ideal for Excel in European locales or TSV workflows.
探索更多工具
在下方的 Data 分类中发现相关工具。
相关工具
精选可能对你有用的实用工具