App Icon
Find & highlight duplicates or differences in 2 or more sheets and columns in Google Sheets™
Listing updated:December 20, 2022
Works with:
4,871
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. 2 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 Columns or Sheets
      - compare 2 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 another table

      HOW COMPARE COLUMNS OR SHEETS WORKS

      - identify the found values with color or in a status column…
      - …or clear, copy, move, delete the found values
      - mark the changes in your main sheet

  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

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
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
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
No comments
Search
Clear search
Close search
Google apps
Main menu