Merge two worksheets in Excel

Got stuck with tricky Vlookup formulas? Match and merge Excel worksheets an easy way. The Merge Tables Wizard can combine data from two sheets based on any number of common columns that you select. You can choose to update data in the main table, add new columns from the lookup table, pull non-matching rows and additional matches.

Free download for Excel 2016 - 2007

With Merge Tables Wizard you will

Merge two spreadsheets without copy-pastingMatch and combine data from two tables in seconds, even if they are in different Excel files. Update data in the main tableUpdate the selected columns in your main worksheet with information from the lookup table. Insert non-matching rowsAdd non-matching rows to the end of the main table after all other data. Ignore empty cells in the lookup tableUpdate values in the main table only if the corresponding cells in the lookup table contain data. Perform case-sensitive matchingWhen text case matters, do a case-sensitive lookup to distinguish uppercase and lowercase characters.

Match one or multiple columnsAuto-detect all matching columns and use any number of such columns as the unique identifier. Add new columns from the lookup tableIf needed, pull some columns from the lookup table to the main table. Retrieve additional matchesPaste additional matching rows at the end of your main worksheet or after the row with the same key value. Update only empty cells in the main tableThis option comes in handy when you don't want to overwrite any existing values in your main table. Identify updated cells and added rowsAdd a status column to mark the changes or highlight the updates cells and added rows with color.

How to merge two Excel worksheets together

  

Video: Merge Excel sheets in 6 quick steps

Select the table you are going to update

Pick your Excel lookup table

Choose the key columns

Select the columns you want to update

Choose the columns you need to add to your main table

Choose additional options: add rows, identify updates in a status column, etc.

Two Excel files are merged together

Merge your Excel tables

Exactly the way you want

Update the existing column and add non-matching rows to the end of the main table

Add a new column from the lookup table and put non-matching rows to the end

Paste additional matching rows at the end of the main table

Insert multiple matches after the row with the same key value

Update only empty cells in the main table