Merge Sheets for Google Sheets – version 2.0. What's new?

Meet the brand new version of our Merge Sheets add-on – 2.0! Per your demand, it comes with a handful of new features and improvements that will make your merge even more precise and tailored to your liking.

Tip. Install Merge Sheets from the Google store to view all new features firsthand.

NEW: Merge multiple lookup sheets in one go

Merging 2 sheets is good but merging multiple sheets is way better! Merge multiple lookup sheets.

With this major upgrade, you can now add numerous files from your Drive right to the add-on and select as many lookup sheets from them as you need: Select multiple lookup sheets.

The add-on will go through each lookup sheet one by one (in the order you add them to the add-on and they appear in the tree view), matching them with your main sheet and merging the necessary information.

Tip. Learn more about this step and its settings: Choose the lookup sheets

Example 1. Update records & add non-matching rows

Match & merge sheets: update records & add non-matching rows.

Example 2. Update records, mark the changes in the status columns

Merge sheets & add a status column.

Example 3. Update only empty cells in the main sheet

Merge sheets & update only blank cells in the main one.

Example 4. Update records, add non-matching rows & new columns

Merge sheets, add non-matching rows and new columns.

Note. Introducing multiple lookup sheets made us put our thinking caps on. What will happen if there are identically named columns in several lookup sheets and you choose to add them to the end of your main sheet? A few identical columns in lookup sheets.

Should they update one another or what? Learn how the add-on handles such columns in this part of the Merge Sheets help page. Forewarned – forearmed, right? ;)

NEW: Insert additional matching rows

Make Merge Sheets not just update your main sheet with the 1st value, but also take all extra matching rows belonging to the same key value with it: Additional matching rows right after the row with the same value.

You can also personalize this merge a bit and put all those additional matching rows at the end of your main table (rather than right after the row with the same key value): Add extra matching rows to the end of the main table.

This new setting resides on the 5th step: The new option among other settings on step 5.

Tip. There are some peculiarities regarding the work of this option and several matches in your main sheet. Find them out in this part of the add-on tutorial.

IMPROVED: Enhanced user experience

All this talk about the new options and multiple lookup sheets would be pointless if we didn't review the add-on completely. We significantly improved the algorithm so you could have a faster and more reliable Merge Sheets at hand.

Instead of loading arrows, there is now a percent count and the process name for your convenience: User-friendly progress.

It's a game changer for handling large amounts of data because you will understand how much longer (at least approximately) it's going to work.

Even if Merge Sheets catches some problem, it'll show you a gentle notification with the issue description & its possible solution.

Tip. The upcoming release will deal with possible issues even better! The add-on will skip the problem sheets (if any) and merge what it can. The resulting message will then say what sheets will have been omitted and why exactly. Hence, you won't be left in the dark if something goes wrong. We can't wait! :)

IMPROVED: 10 million cells available in your main spreadsheet

Speaking of enhancements! The limit for total cells in a spreadsheet is finally expanded to 10 million. This allowed us to include more lookup sheets & pull those additional matching rows to your main sheet. Yay!

IMPROVED: Add sheets from more places of your Drive

In addition to your personal and shared Drives, you can now search for the necessary main or lookup files among your starred ones: Search among shared or starred files.

IMPROVED: No more missing notes from the lookup sheets

If your lookup sheets have notes, the add-on doesn't leave them behind anymore. It pulls them to the main sheet along with their corresponding values: Take notes along with their values to the main sheet.

You may also be interested in

Table of contents

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)