When to use it
Use SheetDiff when you have two versions of the same data in Google Sheets and need to find differences without writing VLOOKUP, XLOOKUP, INDEX MATCH, or conditional formatting formulas again.
Use SheetDiff when you have two versions of the same data in Google Sheets and need to find differences without writing VLOOKUP, XLOOKUP, INDEX MATCH, or conditional formatting formulas again.
Pick the original tab, pick the tab to compare against, and choose a key column such as invoice number, order ID, SKU, email, employee ID, or customer ID. SheetDiff matches rows by that key and builds a report of missing rows, changed values, and matches.
The add-on creates a SheetDiff Report tab in your spreadsheet. The report groups differences so you can quickly answer: what is only in the first sheet, what is only in the second sheet, and which fields changed.