3 ways to merge multiple Google sheets. Part 1 – Merge Sheets add-on

Part 1 of the video series on combining Google sheets. In this video, we use Merge Sheets add-on to merge two sheets in Google Sheets.

Get Merge Sheets as part of Power Tools collection at Google Workspace Marketplace:
https://workspace.google.com/marketplace/app/power_tools/1058867473888

00:00 Introduction to Part 1
00:18 The task
00:38 Run Merge Sheets
00:48 Steps 1-2 - Select main and lookup sheets
01:25 Steps 3-5 - Fine-tune the options to merge two sheets
02:47 Enjoy the result
03:11 Wrap-up

Part 2 – combine data from multiple sheets: https://youtu.be/Hzlk8LMtVfI
Part 3 – consolidate in Google Sheets: https://youtu.be/ibAGqXd0q1Y

Read all 3 video transcripts in this blog post: https://www.ablebits.com/office-addins-blog/2020/12/24/ways-to-merge-google-sheets-videos/

👋 Let's be friends on socials!
LinkedIn: https://linkedin.com/company/apps4gs/
Facebook: https://www.facebook.com/ablebits/

#merge #spreadsheet #googlesheets #ablebits

---

Closed Caption:

In this first video
of a 3-part series on combining Google Sheets,
I'm going to show you our Merge Sheets add-on.
Use it whenever you need to match and merge two sheets into just one table
by common values in one or more columns.
Here's an example:
a small business needs to purchase
some winter equipment based on last year's sales.
The thing is,
this time they've got a much shorter list of essentials.
I will use Merge Sheets to match both lists
and update the necessary information for all essential items.
I go to the 'Add-ons' menu and run the tool.
It is available as an individual tool
and as part of the add-ons collection – Power Tools.
Once the add-on is started,
it picks up my current table immediately.
On the next step,
I need to select a lookup sheet:
it's a table with the info
that I need to pull to my first main table.
It's in a separate file
which is not a problem for the add-on at all.
The tool lets me select any spreadsheet from Drive
and even search the entire Drive by a part of the spreadsheet name.
I Add the file to 
the add-on,
select the sheet,
can also open and double-check the range,
and go to the next step.
Here I am to pick matching columns to compare:
I have 'Item' in my current file
and, as you can see, the add-on
auto-detects the same column in another spreadsheet.
But, if necessary, I am free 
to choose any other column between existing ones.
Then goes the most important part:
select columns to update
or even add to my current list.
Let's see:
I need to pull the correct ArticleIDs into my ID column.
Then, I think, I want to see Categories
in my sheet as well –
let's add it to the end of the table.
And all Sold numbers will become my Stock 
values –
I mean the number of items to buy.
I press Next,
and see some extra options 
that will help me merge two Google Sheets:
I'm going to tick off the first one to pull rows 
with all non-matching items just in case.
They can be optional purchases for future.
Then I will go with a status column –
it will help me filter the merged 
result by updated or new items.
And I also want to color updates 
cells just to see them right away.
As for the place for the result, I'd 
like to update my main table directly.
I hit Finish
and wait for the resulting message.
Now let's see what I've got.
The fill color hints right away
that all ID and Stock numbers have been 
successfully updated based on the Items.
The Category column has been 
added based on the Items as well.
Thanks to the Status column, I can 
also see the rows
that have a match and have been updated,
as well as all newly added rows.
I've got all these in just 5 quick steps of the 
Merge Sheets add-on.
I invite you to install the tool from the add-ons' store
to match and merge two
similar Google sheets of your own.
If you have any questions, feel free to leave 
them in the comments section down below.
And look for part 2 of the Combine 
data series
where I will show you our next add-on – Combine Sheets.
Thank you.