逗号、分号还是制表符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

  • 列数不对:多半是分隔符识别错或引号未闭合(见 打开 CSV)。
  • 数字带千分位逗号:先去掉逗号或改用分号/制表符分隔。
  • 想彻底规范化:用 转换工具 重设分隔符与引号策略。
  • 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.

打开 CSV 转换工具 →Open the CSV Converter →