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.

Select the table you want to update

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!

Screenshots

Select the table you want to update
Choose key columns to compare and match the records
Update existing columns or add new ones to your main table
Fine-tune the merge to add all missing records, update only empty cells,or highlight changes
See the combined data in less than a minute

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish your message on our support forum
 

Our working hours: 0am to 10am PST; 3am to 1pm EST; 8am to 6pm CET.

Excel add-ins and Outlook tools - Ablebits.com