一款完全在浏览器本地运行的 CSV 文件合并工具上线，其核心亮点在于能够根据表头名称自动对齐不匹配的列，且全程无需上传数据 1。该工具页面仅需加载约 11KB（gzip 压缩后）的 JavaScript 代码，即可实现拖入多个 CSV 文件进行合并的功能 1。
在默认设置下，该工具开启“每个文件包含表头行”选项，严格依据列名而非位置进行匹配 1。列名匹配过程区分大小写，例如“Email”与“email”会被识别为不同的列 1。合并后的结果将包含所有文件列的并集，对于部分文件中缺失的列，系统会自动填充空单元格以避免数据错位 1。此外，该工具能够正确解析包含逗号或换行符的引号字段，但若某行实际字段数超出表头列数，多余字段将被直接丢弃 1。
在功能扩展与限制方面，用户可自定义是否启用按表头合并、是否区分大小写以及是否添加来源列等选项 1。该工具没有固定的文件数量或行数限制，其处理上限完全取决于用户设备的内存容量 1。
A new CSV merging tool has been launched that operates entirely within the browser, ensuring all data processing remains local without uploading any files to a server 1. The lightweight application requires only about 11KB of JavaScript to load after gzip compression 1. By default, the tool enables the "Each file has a header row" setting, allowing users to drag and drop multiple CSV files and align columns based on header names rather than their positional order 1.
The merger combines all columns from the input files into a single union, automatically filling missing columns with empty cells instead of misaligning the data 1. Column name matching is case-sensitive, meaning variations like "Email" and "email" are treated as distinct columns 1. Users can customize settings such as header-based merging, case sensitivity, and the addition of a source column 1. The tool imposes no fixed limits on the number of files or rows, with the maximum capacity constrained only by the device's available memory 1. Additionally, it correctly parses quoted fields containing commas or line breaks, while any extra fields in a row that exceed the number of header columns are simply discarded 1.
评论
还没有评论，欢迎留下第一条。