Skip to content
toolsdocks

Merge Excel and CSV Files into One

Stack several Excel or CSV files into one table. This page opens the merge and split tool in Merge mode with an Excel workbook as the output; columns are matched by header name and a file that lacks a column gets blanks there.

Runs on your device

More options in the full CSV merger and splitter.

Loading tool…

How to use it

  1. Choose the files to merge (CSV, TSV, XLSX, XLS or ODS).
  2. Check the merged header preview and each file's column coverage.
  3. 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.
  4. 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

InputXLSX, XLS, ODS, CSV, TSV
OutputXLSX, CSV
EngineStreaming 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.