✅ CSV 格式校验器CSV Validator
检查 CSV/TSV 是否格式正确:未闭合的引号、引号后多余的字符、各行列数和表头不一致、空行、重复或空白的表头,并按行号逐条列出问题。Check whether a CSV or TSV file is well formed: unclosed quotes, stray characters after a closing quote, rows whose column count differs from the header, blank lines, and duplicate or empty header names — every problem listed with its line number.
使用说明与常见问题How-to & FAQ
「CSV 格式校验器」是什么?What is the CSV Validator tool?
检查 CSV/TSV 是否格式正确:未闭合的引号、引号后多余的字符、各行列数和表头不一致、空行、重复或空白的表头,并按行号逐条列出问题。Check whether a CSV or TSV file is well formed: unclosed quotes, stray characters after a closing quote, rows whose column count differs from the header, blank lines, and duplicate or empty header names — every problem listed with its line number.
如何使用「CSV 格式校验器」?How do I use the CSV Validator tool?
在「CSV 格式校验器」中,把内容粘贴或输入到上方输入框,结果会实时显示在下方,点击「复制结果」即可复制。In the CSV Validator: Paste or type into the input box; the result appears below instantly — click "Copy result" to copy it.
按什么标准校验?What standard does it check against?
按 RFC 4180 的 CSV 规则:含分隔符、引号或换行的单元格要用双引号包起来,单元格里的引号写成两个(""),每一行的列数应该相同。分隔符可自动识别逗号、制表符、分号或竖线。RFC 4180 CSV rules: cells containing the delimiter, a quote or a line break are wrapped in double quotes, a quote inside a cell is written twice (""), and every row should have the same number of columns. The delimiter (comma, tab, semicolon or pipe) can be detected.
✗ 和 △ 有什么区别?What's the difference between ✗ and △?
✗ 是会让程序读错数据的格式错误(引号问题、列数不一致);△ 是提醒,文件仍然合法,但可能导致导入问题(空行、重复或空白表头、表头前后空格)。✗ marks format errors that make programs read the data wrongly (quote problems, mismatched column counts). △ marks warnings: the file is still valid, but these often cause import trouble (blank lines, duplicate or empty headers, spaces around headers).
行号是怎么算的?How are line numbers counted?
行号是文本里的物理行号(从 1 开始),和你在编辑器里看到的一致。带引号的单元格里如果有换行,一条记录会占多行,报告的是这条记录开始的那一行。Line numbers are physical lines in the text (from 1), the same as in your editor. A quoted cell with line breaks makes one record span several lines; the report gives the line where the record starts.
代码或数据会被上传吗?Is my code or data uploaded?
不会。「CSV 格式校验器」完全用 JavaScript 在本地运行,适合处理含有密钥、内部接口等敏感内容的数据。No. The CSV Validator runs entirely in local JavaScript, so it is safe for data containing keys or internal endpoints.
「CSV 格式校验器」免费吗?需要注册吗?Is the CSV Validator free? Do I need an account?
「CSV 格式校验器」完全免费,无需注册或安装,打开网页即可使用,手机和电脑都能用;输入的内容只在你的浏览器本地处理。The CSV Validator is completely free with no sign-up or install and works on phones and desktops; what you enter is processed only in your browser.