Compare Sheets for Google Sheets

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

3 add-ons from this toolset will compare your data in Google Sheets. One will compare several 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.

The last will compare two columns in one Google sheet and spot dupes or uniques between them.

Compare sheets for dupe rows
Compare sheets cell by cell for differences
Compare two columns for dupes or uniques

Buy license

Choose your plan

Download

Try it for free

With Compare Sheets you will

Scan your data for duplicate or unique rows Compare 2 and more 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.