Remove Duplicate Rows from Excel or CSV

Choose which columns decide a duplicate, keep the first or last copy, and download the cleaned file with a record of every removed row.

Your files are read in this browser tab and never uploaded.

Choose an Excel or CSV file

.xlsx, .xls or .csv

Ignore extra spaces

Ignore upper/lower case

How to remove duplicates by one or more columns

Upload your .xlsx, .xls or .csv file and pick the sheet if there is more than one.
Select the column(s) that identify a duplicate, for example Email, or Order ID + SKU. Select none to remove only rows that are identical in every column.
Tick Keep the last copy if newer entries are lower in the file.
Click Remove Duplicates and download. The Excel download has two sheets: the unique rows and the removed duplicates, so you can check what was dropped.

When people use this

Cleaning a mailing list exported from several forms before importing it into an email tool.
De-duplicating order or transaction exports that overlap because they were downloaded for overlapping date ranges.
Keeping only the latest record per customer or SKU (select the ID column and tick "keep the last copy").

Frequently Asked Questions

It works the same way on the columns you choose, but it also ignores extra spaces and letter case if you want, and it gives you a separate sheet listing every removed row, which Excel does not.

Columns stay in their original order. Cell formatting and formulas are not kept; values are exported as they appear in the file.

Yes. Completely empty rows are skipped.

No. The file is read and processed in your browser tab.