Merge two or more sheets in Google Sheets

Merge Sheets is an indispensable tool for matching and merging Google sheets. The add-on matches the records from the columns you select and updates your main table with the corresponding data from as many lookup tables as you need.

Using the tool, you control what will be pulled:

1. You can update the entire main table.
2. Add unique rows from the lookup tables to the main one.
3. Add extra matching rows to the main sheet if necessary.
4. Fill only empty cells in the main table.
5. Update only if cells from the lookup table contain data.

The updated version of the tool lets you add as many lookup sheets as you need! The add-on will merge them with the main sheet one by one – in the order they appear in your tree view.

You can always go with the VLOOKUP or INDEX/MATCH functions to combine the sheets. However, practice shows that these are difficult to understand. Also, they often need to be combined with other Google functions to make your lookup criteria more advanced and flexible.

Our tool offers 5 simple steps that will take about a minute of your time to adjust the settings.

Find Merge Sheets in the Extensions menu (or in the Merge & Combine group in Power Tools) and do the following:

1. Select the main sheet.
2. Select the lookup sheets.
3. Choose key columns – columns that match across all tables.
4. Decide what columns you need to add or update in the main table.
5. Fine-tune extra options.
6. Click Finish.

See a more detailed description here.

You can actually control this behavior.

If you'd like, you can have all additional matching rows pulled to your main sheet as well, either to the end of the whole table or right after the row with the same value.

If you don't opt for these, our Merge Sheets add-on will update your main sheet with the record from the first matching row.

Merge Sheets can color the changes for you. Once you choose the corresponding option on the last step, you'll be offered a palette with different hues — pick the one you like and enjoy the results.

Alternatively, you can make use of the status column. It will appear to the right of your table indicating the type of values: updated, new, matching, etc.

Feel free to use both options at the same time to your best convenience :)

No worries, you'll be able to choose whether your tables have headers and what columns to update with the data.

For that, simply skip the step where you choose columns to update, and head straight for extra options — Add non-matching rows to the main table is the one you need.

That again depends on the options you select. :) Have Merge Sheets to fill only empty cells in your main table or don't pull those blanks from the lookup tables.