May 2023 – Release notes

Compare Sheets v1.1

Tip. Install the latest version of Compare Sheets from the Google Workspace Marketplace to see all the new tools in action.

New features

Compare multiple sheets for duplicates

This one is an enhanced version of our long-existing Compare Columns or Sheets. It used to compare just two columns or Google sheets. Now it will deal with several sheets at a time :)
Compare data from multiple Google sheets using the add-on.

Add sheets from Drive

Even if your sheets are in different spreadsheets, you'll be able to add them all from your Drive to the add-on right on the first step:
Add all files to the add-on.

Select main sheet

One of these sheets will still have to be the main one. Each of the other selected sheets will be checked against the main one.

Apply the action to certain sheets

Another nice thing this version offers: you can handle the found duplicates or uniques not just on the main sheet. That is, color them, delete them, etc.

Of course, you can still do that only on the main sheet:
Color duplicates on the main sheet only.

But also on each compared sheet (BUT the main one):
Process values on the compared sheets.

And even on all sheets altogether:
Handle dupes on all sheets.

Connect your dupes with cross-sheet links

Having compared multiple sheets, you'll probably wonder where those duplicates are in other compared sheets. For that, the add-on will add cross-sheet links if you choose to:
Add cross-sheet links.

These references will lead right to the related duplicates in the compared sheets as well as to the source sheets when you copy/move the records:
Hyperlinks referring to the same rows in other compared sheets.

Check out this tutorial for all the details on all the available options.

Compare 2 columns within a sheet

Since Compare Two Sheets or Columns has been changed to support multiple sheets, we had to make this separate quickie: Compare Two Columns.

It's for when you must compare two columns on the same Google sheet. Many of you asked to keep this ability, so here it is :)
Compare two columns in Google Sheets.

It's now a one-step add-on with just a few settings to tweak:

  1. the range containing your columns
  2. two actual compared columns
  3. whatever you want to find: dupes or uniques
  4. the action

All options in just one step.

Easy-peasy, right? This tutorial digs deeper into the options if you'd still like to explore them :)

Post a comment

Seen by everyone, do not publish license keys and sensitive personal info!

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.