How To Compare Two Sheets In Google Sheets 5 Steps

In other words, if you have two theoretically identical spreadsheets you want to compare to find any differences, put one in each tab. By default, these tabs will be named “Sheet1” and “Sheet2,” but you can customize the names if you’d like.

If you’ve changed your sheets so they’re not called Sheet1 and Sheet2, adjust the names as needed. For example, if your first sheet is called “Original Data” and the second is called “New Data,” your formula would be =IF(‘Original Data’!A1<> ‘New Data’!A1, ‘Original Data’!A1&" | “&‘New Data’!A1, “”)[1] X Research source

If you don’t see any text in the comparison sheet at all, it means the two sheets are identical. Only differences will show up.