Find & highlight duplicates or differences in 2 or more sheets and columns in Google Sheets™
Listing updated:July 5, 2024
Works with:
72K+
Overview
Compare Google Sheets™ row by row for duplicate/unique rows, or scan them cell by cell and highlight differences in contents along with non-matching rows. 3 similar yet different add-ons for Google Sheets™ will compare multiple columns and sheets for you. 

WHY THIS TOOLSET
  - no need for formulas, macros, conditional formatting
  - comparison results are clear at first glance
  - user-friendly steps to ease the job
  - save your comparison settings for later use

WHAT YOU'LL FIND

  1. Compare Sheets for Duplicates
      - compare 2 or more columns or sheets in Google Sheets™ at a time
      - match data by rows (you choose the columns to consider)
      - find duplicate or unique rows no matter their position in tables
      - quickly navigate across all found values using cross-sheet links

      HOW COMPARE SHEETS FOR DUPLICATES WORKS

      - identify the found values with color or in a status column…
      - …or clear, copy, move, delete the found values
      - mark the changes in the required sheets: main, other compared, all sheets
      - add hyperlink references to connect dupes across sheets

  2. Compare Sheets Cell by Cell
      - compare as many sheets in Google Sheets™ as you need
      - match data cell by cell
      - find cells with different values across the sheets
      - find unique rows (where no cell in a row has a match in another sheet)

      HOW COMPARE SHEETS CELL BY CELL WORKS

      - highlight differences with hues of your choice
      - label differences in a status column
      - see a short description to know what other sheets look different
      - identify the changes in every compared sheet
      - create one full report with differences grouped accordingly

  3. Compare Columns
      - compare two columns on one Google sheet
      - find dupes or uniques in a single step

      HOW COMPARE COLUMNS WORKS

      - fill cells with color or add a status column
      - copy or move them to a place of your choice
      - clear values, delete cells & shift data up, or remove entire rows from the sheet

30 DAYS OF FREE USE
Fully functional 30-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee.

If you have any questions please post them here: https://www.ablebits.com/docs/google-sheets-compare-sheets-cells/
We'll be happy to assist!

Compare Sheets is a proud member of the Ablebits product family. We build add-ons that help you make the most of Google Workspace™. Visit our official website to learn more:
https://www.ablebits.com/google-sheets-addons.php
–––––––––––––––––––––––––––––––––––––
WHAT'S NEW:
***** V1.1 (29 May 2023) *****
★ New features: ★
- Compare multiple sheets for duplicates. We enhanced 'Compare columns or sheets' so it could compare not just two but multiple sheets or columns at a time. 

Improved:
- Minor UX and UI improvements.

Fixed:
- Compare sheets for duplicates:
    1. Couldn't copy the dupes from the range returned by a formula.
    2. Couldn't run the scenario if its second sheet was protected or had a protected range within.
Additional information
PricingFree of charge trial
Developer
Privacy policy
Terms of service
Compare Sheets will ask for the permissions shown below. Learn more
Compare Sheets will need access to your Google account
This will allow Compare Sheets to :
See, edit, create, and delete all of your Google Drive files
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Loading
Search
Clear search
Close search
Google apps
Main menu