↔️ CSV 插入列(指定位置)Insert Columns into CSV
在 CSV/TSV 表格的任意位置插入一列或多列:指定插在第几列之前,填写新列名和填充值(可含行号)。自动识别分隔符,行长度不齐时先补齐。Insert one or more columns at any position in a CSV or TSV table: choose the column to insert before, then give the new names and a fill value (which can include the row number). The delimiter is detected and short rows are padded first.
使用说明与常见问题How-to & FAQ
「CSV 插入列(指定位置)」是什么?What is the Insert Columns into CSV tool?
在 CSV/TSV 表格的任意位置插入一列或多列:指定插在第几列之前,填写新列名和填充值(可含行号)。自动识别分隔符,行长度不齐时先补齐。Insert one or more columns at any position in a CSV or TSV table: choose the column to insert before, then give the new names and a fill value (which can include the row number). The delimiter is detected and short rows are padded first.
如何使用「CSV 插入列(指定位置)」?How do I use the Insert Columns into CSV tool?
在「CSV 插入列(指定位置)」中,把内容粘贴或输入到上方输入框,按需设置「新列名(逗号分隔)」、「填充值({n} = 行号)」、「插在第几列之前」,结果会实时显示在下方,点击「复制结果」即可复制。In the Insert Columns into CSV: Paste or type into the input box, adjust "New column names (comma separated)", "Fill value ({n} = row number)", "Insert before column"; the result appears below instantly — click "Copy result" to copy it.
“插在第几列之前”怎么填?How do I fill in 'Insert before column'?
填一个列号(最左边是第 1 列)。新列会出现在这一列的左边:填 1 等于插在最前面,填“总列数 + 1”等于追加在最后。超出范围时会提示允许的范围。Give a column number (the leftmost is column 1). The new columns appear to the left of it: 1 puts them first, and the column count + 1 puts them last. Out-of-range values show the allowed range.
填充值里的 {n} 是什么?What does {n} in the fill value do?
{n} 会被替换成数据行的序号(表头不算,从 1 开始),比如填 ID-{n} 会得到 ID-1、ID-2……留空则新列是空单元格。所有新列使用同一个填充值。{n} is replaced with the data row number (the header doesn't count; it starts at 1), so ID-{n} gives ID-1, ID-2 and so on. Leave it blank for empty cells. Every new column gets the same fill value.
不勾选“第一行是表头”会怎样?What if 'First row is a header' is off?
那么每一行(包括第一行)都当作数据行,都会填入填充值;新列名只用来决定要加几列。Then every row, the first included, is a data row and gets the fill value; the new column names only decide how many columns are added.
含逗号或引号的单元格会被破坏吗?Will cells with commas or quotes break?
不会。输入按 CSV 规则解析(带引号的单元格里可以有逗号、引号和换行),输出时需要引号的单元格会重新加上引号,分隔符保持和输入一致。行长度不齐时先补齐空单元格,空行原样保留。No. The input is parsed by CSV rules (quoted cells may contain commas, quotes and line breaks), cells that need quotes get them again on output, and the delimiter stays the same as the input. Short rows are padded with empty cells first, and blank lines are kept.
代码或数据会被上传吗?Is my code or data uploaded?
不会。「CSV 插入列(指定位置)」完全用 JavaScript 在本地运行,适合处理含有密钥、内部接口等敏感内容的数据。No. The Insert Columns into CSV runs entirely in local JavaScript, so it is safe for data containing keys or internal endpoints.
「CSV 插入列(指定位置)」免费吗?需要注册吗?Is the Insert Columns into CSV free? Do I need an account?
「CSV 插入列(指定位置)」完全免费,无需注册或安装,打开网页即可使用,手机和电脑都能用;输入的内容只在你的浏览器本地处理。The Insert Columns into CSV is completely free with no sign-up or install and works on phones and desktops; what you enter is processed only in your browser.