一步一步来。One step at a time.
粘贴数据,核对分隔符Paste the data and check the delimiter
在表转选择 CSV 输入,粘贴下方示例或导入文件。默认自动识别分隔符;预览挤在一列时,手动选择逗号、Tab、分号或竖线。Select CSV input in SheetShift and paste the example below or import a file. Delimiters are detected automatically. If the preview lands in one column, choose comma, tab, semicolon, or pipe manually.
给每一列一个唯一名称Give each column a unique name
第一行作为表头。重复列名会被拒绝,避免同名字段覆盖数据。一个值内部有逗号时用双引号包住;值内的双引号写成两个双引号。The first row is the header. Duplicate column names are rejected to prevent overwritten fields. Wrap a value containing a comma in double quotes; write a quote inside that value as two double quotes.
转换为 JSONConvert to JSON
点击“转换为 JSON”。从 CSV 读取的值保持字符串,因此 00123 不会被改成数字 123,空白单元格也不会自动变成 null。Click Convert to JSON. Values read from CSV stay strings, so 00123 does not become the number 123, and an empty cell does not automatically become null.
按需要下载完整结果或当前视图Download the full result or the visible view
“下载文件”导出当前编辑区的数据;“下载当前视图”会使用当前搜索、排序与列选择。预览最多显示 50 行,不代表导出只能有 50 行。Download file exports the data in the editor. Download visible rows uses the current search, sort, and column selection. The preview displays up to 50 rows; exports are not limited to those 50 preview rows.
可以照着核对的小例子A SMALL EXAMPLE TO CHECK
逗号、编号和空值,一起核对Check commas, IDs, and empty values together
这是虚构示例,不含真实客户信息。输出中的引号很重要:这里的编号和数值都保持为文本。This fictional sample contains no real customer data. The output quotes matter: identifiers and numeric-looking values remain text.
输入或设置Input or settings
id,name,quantity,note
00123,"Tea, green",2,结果核对Result check
[
{
"id": "00123",
"name": "Tea, green",
"quantity": "2",
"note": ""
}
]这些边界,也说清楚。Keep these limits in mind.
工具不会猜测字段业务含义,也不会把字符串自动变成数字、日期或布尔值。The tool does not infer business meaning or automatically turn CSV strings into numbers, dates, or booleans.
已有 JSON 中的超长编号请使用字符串;超出 JavaScript 精确整数范围的数字会被拒绝。Use strings for long identifiers in existing JSON. Numbers outside JavaScript's exact integer range are rejected.
文件处理在浏览器中进行。页面仍可能连接托管、广告,以及你允许的访问统计服务;“本地处理”不等于整个网页没有网络连接。File processing happens in your browser. The page may still connect to hosting, advertising, and analytics you allow; local processing does not mean the entire webpage has no network connections. 查看隐私说明Read the privacy notice ↗