How to merge two sheets

How to work with the Merge Sheets add-on in Google Sheets

Get the add-on

Merge Sheets add-on is a great assistant for bringing the latest data from another sheet into your main table. Follow five simple steps to complete the process:

Step 1: Select your main table

Open Merge Sheets from the "Add-ons" menu

Go to Add-ons > Merge Sheets > Start to open the tool.

Your main table is the one that will be updated as the result of the process.

You can select the sheet that contains your main table in the 'Select your main sheet' drop-down list.

Please select the sheet that contains duplicates

Click on the Auto select button to select the entire range with data in your sheet.

You can edit the range either by manually typing the address in the 'Select the range with your table' field, or by selecting the necessary cells right in your sheet.

Select the 'Create a backup copy of the sheet' check box to keep the original table.

Click Next to go to the second step or Cancel to close the add-on window.

See next:

Featured customers 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.

Ultimate Suite for Excel Professionals
60+ 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
Sheila Blanchard
Excel add-ins and Outlook tools -