Merge Excel files
Merge Excel and CSV tables by matching column headers. Optionally keep source filenames and sheet names.
Output XLSXChoose filesProcessed on your device
Choose files to select sheets and columns.
Results contain values stored as text cells. Formatting and formula recalculation are not supported.
Example
One table has Code, Quantity and another has Quantity, Code. Both are aligned under the matching headers in the merged sheet.
Supported features and limits
- The first row supplies column headers. By default, every file must have the same set of headers.
- Enable all columns to keep unmatched columns and leave missing values blank. Duplicate rows are kept.
- Values are saved as text cells. Original formatting, macros, charts, and formula recalculation are not supported. Each sheet supports up to 50,000 rows, 200 columns, and 1 million cells; selected input files support up to 2 million cells in total.
Frequently asked questions
Will my original files change?
No. The tool creates new result files. Review the downloaded results before using them.
Are my files uploaded?
Selected files are processed in your browser. File contents and filenames are not sent to a server. Aggregate tool-use counts are collected as described in the privacy notice.