You can delete duplicate rows in Excel and Google Sheets using this simple trick. You need Remove Duplicates add-on for Google Sheets.

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 ...