🔍

首页Home › 开发工具Developer Tools

🧩 CSV 补齐不完整行(短行补空单元格)Fill Incomplete CSV Records

把列数不足的 CSV 行补齐到与最宽行(或表头)相同的列数,空位填空白或指定值。自动识别分隔符,方便导入要求“每行列数一致”的程序。Pad short CSV rows to the width of the widest row (or the header) with blanks or a value you choose. The delimiter is detected — handy for importers that require a consistent column count.

使用说明与常见问题How-to & FAQ

「CSV 补齐不完整行(短行补空单元格)」是什么?What is the Fill Incomplete CSV Records tool?

把列数不足的 CSV 行补齐到与最宽行(或表头)相同的列数,空位填空白或指定值。自动识别分隔符,方便导入要求“每行列数一致”的程序。Pad short CSV rows to the width of the widest row (or the header) with blanks or a value you choose. The delimiter is detected — handy for importers that require a consistent column count.

如何使用「CSV 补齐不完整行(短行补空单元格)」?How do I use the Fill Incomplete CSV Records tool?

在「CSV 补齐不完整行(短行补空单元格)」中,把内容粘贴或输入到上方输入框,按需设置「填充值(留空 = 空单元格)」,结果会实时显示在下方,点击「复制结果」即可复制。Paste your CSV and, if you like, enter a "Fill value" for the new cells (leave it blank for empty cells). Short rows are padded to the header width, or to the widest row if you untick "Pad to header width". Click "Copy result" to copy the output.

和“查找不完整行”有什么关系?How does this relate to Find Incomplete CSV Records?

先用“查找”列出短行,确认无误后再用本工具补齐。Use Find Incomplete CSV Records to list short rows, then fill them here once you are happy.

多出来的列会删掉吗?Are extra columns removed?

不会。比目标更长的行保持原样,只补短行。No. Rows longer than the target are left alone; only short rows are padded.

输入和输出是什么样的?What does the input and output look like?

例如在「CSV 补齐不完整行(短行补空单元格)」中输入 a,b,c ⏎ 1,2 ⏎ 3,输出为:a,b,c ⏎ 1,2, ⏎ 3,,(⏎ 表示换行)。The input a,b,c ⏎ 1,2 ⏎ 3 becomes a,b,c ⏎ 1,2, ⏎ 3,, (⏎ marks a line break).

有哪些选项可以调整?What options can I adjust?

「CSV 补齐不完整行(短行补空单元格)」的设置:「填充值(留空 = 空单元格)」可留空;可勾选:「按表头列数补齐」(默认勾选)。改动任一选项后结果会按新设置重新生成。You can adjust "Fill value (blank = empty cell)" (optional); and the "Pad to header width" (on by default) checkbox. The result updates as soon as you change a setting.

代码或数据会被上传吗?Is my code or data uploaded?

不会。「CSV 补齐不完整行(短行补空单元格)」完全用 JavaScript 在本地运行,适合处理含有密钥、内部接口等敏感内容的数据。No. The Fill Incomplete CSV Records tool runs entirely in local JavaScript, so it is safe for data containing keys or internal endpoints.

「CSV 补齐不完整行(短行补空单元格)」免费吗?需要注册吗?Is the Fill Incomplete CSV Records tool free? Do I need an account?

「CSV 补齐不完整行(短行补空单元格)」完全免费,无需注册或安装,打开网页即可使用,手机和电脑都能用;输入的内容只在你的浏览器本地处理。The Fill Incomplete CSV Records 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.

相关工具Related tools

🔍 CSV 查找不完整行(列数不足)Find Incomplete CSV Records✅ CSV 格式校验器CSV Validator🔃 CSV 列排序(按表头名或指定顺序重排)Sort CSV Columns🔀 CSV 交换两列Swap CSV Columns✂️ CSV 去除单元格首尾空格Trim CSV Columns📏 CSV 截断单元格(限制最大长度)Truncate CSV Columns🔗 CSV URL 编码(编码单元格)URL-Encode CSV🔓 CSV URL 解码(解码单元格)URL-Decode CSV🔀 十六进制 OR 运算(按位或)OR Hex Numbers⊼ 十六进制 NAND 运算(与非)NAND Hex Numbers⊕ 十六进制 XOR 运算(按位异或)XOR Hex Numbers🔁 反转十六进制数字Reverse Hex Digits

← 全部工具All tools