How to Compare Two Excel Spreadsheets for Duplicate Rows. Excel 2013 can locate duplicate rows as long as one column contains a unique identifier for each record, such as a product ID or account ...