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

Microsoft Excel and Google Sheets, two leading spreadsheet applications, offer many features to help users work efficiently with their data.

Remove duplicate entries from Microsoft Excel worksheets with add-in Duplicate Remover for Excel.

Launch Excel. Load the Excel worksheet file containing the duplicate rows you need to remove. Click the row number of each duplicate row. Right-click anywhere within the selected row.