How to use Merge Excel files
Merge Excel and CSV tables by matching column headers. Optionally keep source filenames and sheet names.
When to use this tool
One table has Code, Quantity and another has Quantity, Code. Both are aligned under the matching headers in the merged sheet.
Choose files and settings
Choose files and sheets → Set column and source options → Preview and download XLSX. Keep the original files until you have checked the output.
Before you save
Empty or duplicate headers must be fixed before merging.
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.
Check the result
Compare input and output row counts. Check leading zeros, blank values, and unmatched rows. Formatting and recalculated formulas are not part of the output.