Combine Excel sheets by column headers

This tool comes in handy when you need to merge data from many worksheets and workbooks together. The add-in combines multiple Excel sheets into a single table according to their column headers, no matter the column number or order. Their original formatting and formulas can be copied as well, or you can link the combined datasets to their sources.

You can get it done by copying and pasting your data manually or with VBA. Or, use our Combine Sheets tools for quick and easy merging.

To combine several Excel files into one, do the following:

1. Click Combine Sheets on the Ablebits Data tab.
2. Select worksheets to combine.
3. Choose columns to merge.
4. Select additional options to merge data.
5. Lastly, specify where you want to place the result.
6. Click Combine.

See a more detailed description here.

Combine Sheets recognizes the identically named columns and merges their values into one column, regardless of the position of the columns in the source tables.

Yes. You can choose to copy the formulas or their calculated values, or even create links to the source data, so the combined table will update automatically with every change you make to the original sheets.

Yes. If you choose the Preserve formatting option, each table will be copied with its own formatting.