a11y.skipToMainContent
1

JSON 呼叫CSV

将任何JSON阵列(对象或阵列)——甚至单个对象——转换为干净的CSV. 勾选将嵌入嵌入对象扩展为点注释列的平面选项(例如:<code>address.city</code>).

More options
Was this tool helpful?
Send output to:
Advertisement

How to use JSON to CSV

  1. 贴上JSON.
  2. 选择分隔符; 可选择启用平分符 .
  3. 点击转换.

{姓名}是什么来着?

Columns由所有对象上的所有密钥的结合而得到,因此相异的数组仍然产生完整的CSV. 选择分隔符(comma、分号、制表符、管子)以及是否包含页眉行。

Advertisement

FAQ

筑巢阵列呢?
被嵌入的阵列由JSON-string化为一单元. 为了完全正常化,手动平地或先使用Jq等工具.
如果阵列中的物体有不同的密钥呢?
该工具收集了所有对象的每一个独特的密钥,并将其作为CSV头. 任意行中缺失的值为空 .
我的JSON档案有多大?
由于转换完全运行在您的浏览器中,实用限制取决于您的设备的RAM. 大多数机器处理的文件高达几百兆字节,没有问题.

Related tools

Author

SC
Sarah Chen"The Data Whisperer"

Data Analyst & CSV Specialist

Sarah has spent more than a decade wrangling spreadsheets, debugging CSV exports, and teaching teams how to make data work for them. She previously led data-quality initiatives at a fintech unicorn, where she reduced reporting errors by 40 percent through automated validation pipelines. When she is not optimizing queries or writing about data tooling, you will find her mentoring junior analysts at local bootcamps and speaking at data literacy meetups.

← Back to CSV Tools · All tags

Last updated:

Advertisement