↔️ CSV 更换分隔符(逗号 / 分号 / 制表符)Change CSV Delimiter
把 CSV/TSV 的分隔符换成另一种:逗号、分号、制表符或竖线。自动识别原分隔符,带引号和换行的单元格正确转换,适合在美式 Excel 和欧洲 Excel 之间互转。Switch a CSV/TSV from one delimiter to another: comma, semicolon, tab or pipe. The original delimiter is detected and quoted cells with line breaks convert correctly — handy between US and European Excel.
使用说明与常见问题How-to & FAQ
「CSV 更换分隔符(逗号 / 分号 / 制表符)」是什么?What is the Change CSV Delimiter tool?
把 CSV/TSV 的分隔符换成另一种:逗号、分号、制表符或竖线。自动识别原分隔符,带引号和换行的单元格正确转换,适合在美式 Excel 和欧洲 Excel 之间互转。Switch a CSV/TSV from one delimiter to another: comma, semicolon, tab or pipe. The original delimiter is detected and quoted cells with line breaks convert correctly — handy between US and European Excel.
如何使用「CSV 更换分隔符(逗号 / 分号 / 制表符)」?How do I use the Change CSV Delimiter tool?
在「CSV 更换分隔符(逗号 / 分号 / 制表符)」中,把内容粘贴或输入到上方输入框,按需设置「新分隔符」,结果会实时显示在下方,点击「复制结果」即可复制。Paste your CSV or TSV, leave the delimiter setting on "Detect delimiter" (or pick the one the file uses) and choose the "New delimiter". The converted file appears below; click "Copy result" to copy it.
什么时候要换成分号?When should I switch to semicolons?
德语、法语等地区的 Excel 用逗号作小数点,默认按分号分列,把逗号 CSV 换成分号后可以直接双击打开。Excel in many European locales uses a comma as the decimal mark and expects semicolons, so converting a comma CSV to semicolons lets you open it with a double-click.
含分隔符的字段会乱吗?Will fields that contain the delimiter break?
不会。先完整解析再按新分隔符输出,需要引号的字段会重新加引号。No. The file is fully parsed first and rewritten with the new delimiter; fields that need quotes get them again.
输入和输出是什么样的?What does the input and output look like?
例如在「CSV 更换分隔符(逗号 / 分号 / 制表符)」中输入 a,b ⏎ 1,2,「新分隔符」设为 分号 ;,输出为:a;b ⏎ 1;2(⏎ 表示换行)。With "New delimiter" set to Semicolon, the input a,b ⏎ 1,2 becomes a;b ⏎ 1;2 (⏎ marks a line break).
有哪些选项可以调整?What options can I adjust?
「CSV 更换分隔符(逗号 / 分号 / 制表符)」的设置:「新分隔符」可选 逗号 ,、分号 ;、制表符 Tab、竖线 |(默认 逗号 ,)。改动任一选项后结果会按新设置重新生成。You can adjust "New delimiter" — Comma / Semicolon / Tab / Pipe (default: Comma). The result updates as soon as you change a setting.
行长度不一致(有的行字段多、有的行字段少)时会怎样?What happens when rows have different numbers of fields?
不会凭空补字段,也不会删掉字段:操作只作用于每行实际存在的字段,每行保持自己原来的长度。比如某行没有要处理的那一列,这一行就原样保留。检测到这种行时,结果下方会有一行提示说明有几行。需要统一列数时,请用“CSV 补齐不完整行”。No fields are invented or dropped: the operation only touches the fields each row actually has, and every row keeps its own length. If a row does not have the column being changed, that row is left as it is. When such rows are found, a one-line note below the result says how many. To give every row the same number of fields, use Fill Incomplete CSV Records.
代码或数据会被上传吗?Is my code or data uploaded?
不会。「CSV 更换分隔符(逗号 / 分号 / 制表符)」完全用 JavaScript 在本地运行,适合处理含有密钥、内部接口等敏感内容的数据。No. The Change CSV Delimiter tool runs entirely in local JavaScript, so it is safe for data containing keys or internal endpoints.
「CSV 更换分隔符(逗号 / 分号 / 制表符)」免费吗?需要注册吗?Is the Change CSV Delimiter tool free? Do I need an account?
「CSV 更换分隔符(逗号 / 分号 / 制表符)」完全免费,无需注册或安装,打开网页即可使用,手机和电脑都能用;输入的内容只在你的浏览器本地处理。The Change CSV Delimiter tool is completely free with no sign-up or install and works on phones and desktops; what you enter is processed only in your browser.