Merge two tables in Google sheets

Merge data from two sheets in 5 simple steps

This add-on simplifies the task of combining information you have in two different tables. It skilfully scans key columns in two sheets that you specify and pulls all the necessary updates into your main table. Even if the column order is different, all that matters is the key column with the same records. Follow 5 simple steps whenever you need to fetch some data from another table:

Identify your main and your lookup tables
Use one or more key columns to find matching records
Update information in any columns or add missing data to your table
Choose additional options: update only empty cells, highlight all changes with color, and more

Learn how to work with the add-on.

Get this add-on

for Google Sheets

No formulas, no copy-pasting

Update existing columns or add new ones to your main table

Let the tool automatically match and update records in your sheet. Just make sure you define common columns in two sheets that the add-on should compare in order to find the same records, e.g. product IDs or student names.

Then decide if you want to pull updated records to any existing columns and if you need to add any new data to the right of the original table.

Match and update records

Fine-tune the merge to add all missing records, update only empty cells,or highlight changes

The last step of the wizard groups several additional options for adjusting the merge process. Here you can choose to bring changes only to the empty cells in your Master table and/or only from non-empty cells in your Lookup table, and use status column and color for the updated cells to see all the changes right away.

All records from the lookup table will be placed on the rows that correspond to their key value, e.g. the ID. If you have new records that are not present in your main sheet, you can have such rows copied to the end of the table.

Click Merge and see all changes transferred from another sheet; your table is up-to-date!