🔢 CSV 删除单元格内的逗号(千分位等)Delete Commas Inside CSV Cells
去掉 CSV 单元格内部的逗号(常用于清除千分位:1,250 → 1250),可选只处理“看起来像数字”的单元格,避免误伤地址等文本。分隔符本身不变。Remove commas inside CSV cells (often thousands separators: 1,250 → 1250). Optionally only touch cells that look like numbers so addresses stay intact. The delimiter itself is unchanged.
使用说明与常见问题How-to & FAQ
「CSV 删除单元格内的逗号(千分位等)」是什么?What is the Delete Commas Inside CSV Cells tool?
去掉 CSV 单元格内部的逗号(常用于清除千分位:1,250 → 1250),可选只处理“看起来像数字”的单元格,避免误伤地址等文本。分隔符本身不变。Remove commas inside CSV cells (often thousands separators: 1,250 → 1250). Optionally only touch cells that look like numbers so addresses stay intact. The delimiter itself is unchanged.
如何使用「CSV 删除单元格内的逗号(千分位等)」?How do I use the Delete Commas Inside CSV Cells tool?
在「CSV 删除单元格内的逗号(千分位等)」中,把内容粘贴或输入到上方输入框,按需设置「列(留空 = 全部)」,结果会实时显示在下方,点击「复制结果」即可复制。Paste your CSV. By default only number-like cells such as 1,250 are cleaned; untick "Only numeric-looking cells" to remove every comma inside cells, and use "Columns" to limit the change to certain columns. Click "Copy result" to copy the output.
为什么默认只处理数字?Why only numeric cells by default?
地址、名单里也常有逗号(“New York, NY”)。只处理像 1,250 或 $1,250.50 的单元格更安全;需要清掉所有单元格内逗号时取消勾选。Addresses and names often contain commas (e.g. New York, NY). Limiting to values like 1,250 or $1,250.50 is safer; untick the option to strip commas from every cell.
会改掉分隔用的逗号吗?Does it remove delimiter commas?
不会。只改单元格内容,列与列之间的分隔符保持原样。No. Only cell contents change; the delimiter between columns stays.
输入和输出是什么样的?What does the input and output look like?
例如在「CSV 删除单元格内的逗号(千分位等)」中输入 a,b ⏎ "1,250",x,「列(留空 = 全部)」设为 1,输出为:a,b ⏎ 1250,x(⏎ 表示换行)。With "Columns (blank = all)" set to 1, the input a,b ⏎ "1,250",x becomes a,b ⏎ 1250,x (⏎ marks a line break).
有哪些选项可以调整?What options can I adjust?
「CSV 删除单元格内的逗号(千分位等)」的设置:「列(留空 = 全部)」可留空;可勾选:「只处理数字单元格」(默认勾选)、「第一行是表头」(默认勾选)。改动任一选项后结果会按新设置重新生成。You can adjust "Columns (blank = all)" (optional); and the "Only numeric-looking cells" (on by default) and "First row is a header" (on by default) checkboxes. 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 Delete Commas Inside CSV Cells tool runs entirely in local JavaScript, so it is safe for data containing keys or internal endpoints.
「CSV 删除单元格内的逗号(千分位等)」免费吗?需要注册吗?Is the Delete Commas Inside CSV Cells tool free? Do I need an account?
「CSV 删除单元格内的逗号(千分位等)」完全免费,无需注册或安装,打开网页即可使用,手机和电脑都能用;输入的内容只在你的浏览器本地处理。The Delete Commas Inside CSV Cells 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.