How to use it
- Choose the files to merge (CSV, TSV, XLSX, XLS or ODS).
- Check the merged header preview and each file's column coverage.
- Tick Add a column with each row's source file if you want it; keep Output format on Excel workbook (XLSX) or switch to CSV.
- Select Merge and download the file.
Worked example
jan.csv has the columns Name and Email; feb.csv has Name and Phone. The merged workbook has Name, Email and Phone, with Email blank for rows from feb.csv and Phone blank for rows from jan.csv. With the source column on, a source_file column names each row's file.
Formats and limits
| Input | XLSX, XLS, ODS, CSV, TSV |
|---|---|
| Output | XLSX, CSV |
| Engine | Streaming Papa Parse; header union alignment |
Limitations
- Only the first sheet of each workbook is read.
- Cell text is copied as shown; formulas and formats from the source are not kept.
- Column names that differ in spelling are kept as separate columns.
Questions
What if the files have different columns?
The merged table has every column that appears in any file, in order of first appearance. Rows from a file without a column get a blank cell there, and the file list says which columns each file lacks.
Does it read every sheet of a workbook?
No. Only the first sheet of each workbook is read. Save the sheet you need as its own file first.
Will Excel change my ZIP codes or IDs?
No. The XLSX is written with every cell as text, so values such as 00501 keep their zeros. Choose CSV output if you prefer a text file.
Are my files uploaded?
No. The files are read and merged in your browser.
Privacy
Runs on your device. Files and text are processed in this browser tab and are not uploaded.
This page opens the CSV merger and splitter ready for this task. See the privacy policy for how toolsdocks handles data.