Remove duplicate Excel rows

Delete repeated rows from a sheet, comparing all or some columns.

Choose spreadsheetsor drop them here · XLSX, XLS, ODS, CSV, XLSM
Sheet name or number (several: 1, 3). Leave empty for every sheet. Not used for CSV.
Leave empty to compare whole rows. Otherwise header names, letters or numbers, like Email or B, D.
  • Runs on your device. Files are never uploaded.
  • Free and unlimited. No sign-up, no watermark.
1

Add your file

Choose or drop it in. It opens right here in your browser.

2

Pick the settings

Or keep the defaults, which suit most files.

3

Download

Your file is made on your own device, then saved like any download.

More spreadsheets tools

Remove duplicate CSV rowsDelete repeated rows from a CSV file and keep the first of each.Delete blank Excel rowsRemove every empty row from a sheet or CSV file.Delete empty columnsRemove columns that have no values from a sheet or CSV file.Trim Excel whitespaceStrip stray spaces from the start and end of every text cell.Find and replace spreadsheet valuesReplace text in every cell of a sheet or CSV, with regular expressions if you like.Remove spreadsheet formulas (keep values)Replace formulas with their results; XLSX formatting stays exactly as it was.Sort CSV rowsSort a CSV by one or more columns, as numbers, dates or text.Filter CSV rowsKeep only the CSV rows that match a condition on a column.