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 9am PST; 3am to 12am EST; 9am to 6pm CET.

Ultimate Suite for Excel Professionals
 
 
50+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard
 
 
Excel add-ins and Outlook tools - Ablebits.com