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