JSON 转 CSV
对象数组转 CSV:嵌套键点号扁平化、并集表头、逗号/分号/tab 三种分隔符,RFC 4180 引号转义。
Delimiter
Behaviour
The union of keys across all objects becomes the header row, in first-seen order. Missing fields become empty cells. Values that are objects or arrays are embedded as JSON strings (double-quoted per RFC 4180), e.g. {inner}. Delimiters, quotes and line breaks inside any value are escaped correctly so Excel, Numbers and Sheets can import the file directly.
如何使用JSON 转 CSV
粘贴对象数组,CSV 预览自动生成:嵌套键用点号扁平化成可读表头,形状不同的行合并成并集表头、缺字段留空。分隔符可选逗号、分号或 tab,复制或下载一键完成。
输出遵循 RFC 4180——含分隔符、引号或换行的单元格自动包裹并双写转义,Excel、Sheets 与数据库导入器都读不出意外。数组值默认行内序列化,切换数组展开模式可让每个元素独占一行。