逗号、分号还是制表符Comma, Semicolon or Tab
- 逗号(,):国际标准与程序默认,最通用。
- 分号(;):欧洲版 Excel 的默认,因为当地用逗号作小数点。
- 制表符(Tab):形成 TSV,适合字段内常含逗号的场景。
- Comma (,): The international standard and program default — most universal.
- Semicolon (;): European Excel's default, since the comma is the decimal separator there.
- Tab: Produces TSV, good when fields often contain commas.
字段里包含分隔符怎么办When a Field Contains the Delimiter
用双引号包裹整个字段即可,例如 "北京市,朝阳区" 不会被拆成两列。若字段本身含双引号,则用两个双引号表示一个引号:"他说""你好"""。
Wrap the whole field in double quotes, e.g. "Beijing, Chaoyang" won't split into two columns. If the field itself has a quote, use two quotes for one: "He said ""hi""".
提示:365Lab 工具支持自动识别分隔符,也能在导出时指定分隔符与是否强制加引号,省去手工处理。
Tip: 365Lab auto-detects the delimiter and lets you pick the delimiter and force-quoting on export — no manual fiddling.
多字符分隔与"不规范 CSV"Multi-Char Delimiters & "Messy CSV"
真正的 CSV 分隔符是单个字符。若有人用 || 或多空格分隔,那已不是标准 CSV,导入前最好先用转换工具规范成逗号或制表符,避免被错误拆列。
A real CSV delimiter is a single character. If someone uses || or multiple spaces, that's not standard CSV — normalize it to comma or tab with a converter before importing, or columns will split wrongly.
排错清单Troubleshooting Checklist
- Wrong column count: likely wrong delimiter detection or unclosed quotes (see Open CSV).
- Numbers with thousand commas: strip commas or switch to semicolon/tab.
- To fully normalize: use the converter to reset delimiter and quoting.
想马上试试?打开在线工具,自动识别并重设分隔符,全程本地处理。
Want to try now? Open the toolkit to auto-detect and reset delimiters — locally, no upload.