Compare Sheets for Google Sheets

Compare columns or sheets for dupes or differences by rows & by cells

2 add-ons from this toolset will compare your data in Google Sheets. One will compare two columns or sheets for duplicates & uniques row by row. It will color, delete, copy or move them to another location. Another tool will scan multiple sheets cell by cell and either highlight differences in each sheet or group them all in one comparison report.

Try it for 30 days for free
  • Compare 2 columns or sheets for dupe rows
  • Compare sheets cell by cell for differences

With Compare Sheets you will

  • Scan your data for duplicate or unique rows Compare 2 columns or Google sheets for dupe or unique rows based on records in the selected columns.
  • Compare sheets from the same or different spreadsheets Match sheets from one file or import other files from Drive using the add-on.
  • Handle found dupes and uniques Color, copy, move, delete found dupes/uniques or label them in a status column.
  • Create a comparison report With grouped rows, colored differences and description columns.
  • Go through records in all sheets cell by cell Have the add-on compare multiple Google sheets for differences and highlight them on each sheet.
  • Identify different cells and unique rows Find distinct cells and rows that are missing from some of the sheets.
  • Highlight differences Pick fill colors for different cells and unique rows to spot them amid other values.
  • Set up status & description columns for differences Name all differences and refer to the sheets they are linked with.

How to compare Google sheets

Choose to show differences on the sheets.
Choose to show differences on the sheets.
Compare Google sheets and highlight differences.
Compare Google sheets and highlight differences.
Have the add-on create a full report with all differences.
Have the add-on create a full report with all differences.
Get the report with grouped rows showing different cells & unique/missing/equal rows.
Get the report with grouped rows showing different cells & unique/missing/equal rows.
Choose what to do with the found values.
Choose what to do with the found values.
Compare columns in 2 Google sheets and highlight duplicate rows.
Compare columns in 2 Google sheets and highlight duplicate rows.

Compare your data

with 2 different add-ons

Find different and unique rows across the sheets.
Find different and unique rows across the sheets.
Compare two columns or sheets for duplicates.
Compare two columns or sheets for duplicates.

License benefits

Our customers get

Unconditional
30-day money-back guarantee
Free support
Volume discounts: the more you buy, the less you pay

These companies choose Ablebits products

Frequently asked questions

What is Compare Sheets and what do I need it for?

This is a set of 2 add-ons for Google Sheets that compare your columns and sheets for duplicate and unique data.

Compare Columns or Sheets tool scans 2 ranges and checks if there are duplicate (or unique) rows between them. If so, the add-on marks them with color or in a status column in the main sheet, copies or moves duplicate rows to a sheet of your choice, clears records from such rows, or deletes the rows completely.

Compare Sheets Cell by Cell tool compares multiple Google sheets against your main one for differences. It looks into each and every cell in the main sheet and tests their contents against the same cells in every other sheet. You'll see these differences highlighted and labeled in a status column.

Doesn't Google Sheets provide a free way to compare columns?

There's no native way to compare in Google Sheets. You need to incorporate functions & conditional formatting and tweak them to your needs.

Our add-on leads you through user-friendly steps where you control everything by simply ticking off the required checkboxes.

Can I compare only two Google sheets or more using your extension?

Compare Columns or Sheets handles two columns or sheets at a time. Compare Sheets Cell by Cell works with as many sheets as you need.

Should my sheets belong to the same Google file?

Not at all. You are free to add other spreadsheets from Drive right to the add-on and work with sheets from these different files.

How to compare two Google sheets?

Run Compare columns or sheets from the Extensions menu and follow these steps:

  1. Select the main sheet.
  2. Select the second sheet.
  3. Choose what to find:
    • Duplicates
    • Uniques
  4. Select the columns to check.
  5. Decide what to do with the found values.
  6. Click Compare.

See a more detailed description here.

Does Compare Columns or Sheets process duplicates in both tables?

Not really. It handles found dupes or uniques only in the main sheet. Your second sheet remains intact.

If you'd like to work with repeated data in both tables, you will need to run the add-on twice and switch the sheets.

How to compare Google sheets for differences?

Open Compare sheets cell by cell and do the following:

  1. Select all required sheets.
  2. Identify your main sheet.
  3. Choose what to do with differences:
    • Show them on each sheet
    • Place everything into full report
  4. Click Compare.

See a more detailed description here.

What differences does your add-on show?

Only distinctions in records (cell contents).

If the record in a cell varies between the sheets, the cell is considered to be different.

If all cells in a row are different, it means this row doesn't have even a partial equivalent in other sheets. In this case, it's marked as a completely unique row.

Does your extension find differences in all sheets?

Yes. Although it doesn't compare all Google sheets against each other. It weighs each selected sheet with the main one individually. So the colors will show the differences between the main sheet and every other sheet.

Choose your plan

12-month

  • 12-month access with all updates
$33.60
$19.99
Buy now

Lifetime

  • Get all new features and updates for free ever!
$59.90
Buy now

System requirements

Windows IconOperating Systems
  • Microsoft: Windows 7 and up
  • Mac: High Sierra 10.13 and up
  • Chrome OS™
Google Chrome IconBrowsers
  • Chrome™
  • Firefox
  • Safari (Mac only)