Remove duplicates in Excel or CSV
Remove duplicate rows from an Excel or CSV file. Choose which columns to compare, ignore case and spaces, and keep the first or last match. Free, and your file never leaves your browser.
When to use it
Duplicate rows creep into spreadsheets when you paste lists together, export from two systems, or import the same file twice. They break totals, counts and mail merges.
Use this tool when Excel's own Remove Duplicates is too blunt. You choose exactly which columns decide a match, ignore capital letters and stray spaces, and see the removed rows before you download. It works on .xlsx and CSV files.
How it works
- Drop in an Excel (.xlsx) or CSV file.
- Pick the columns that decide whether two rows are the same. Leave all ticked to compare whole rows.
- Check the count and the preview of removed rows, then download the cleaned file.
Questions
How does it decide a row is a duplicate?
It compares the columns you tick. If every ticked column matches, the row counts as a duplicate. You can ignore upper and lower case and extra spaces at the start or end of a value.
Which row is kept?
You choose. Keep the first occurrence to preserve the earliest row, or keep the last to preserve the newest. Kept rows stay in their original order.
Is my file uploaded anywhere?
No. The file is read and processed inside your browser tab. Nothing is sent to a server, so it is safe to use with client or business data.
Does it work with .xls files?
Only .xlsx and CSV files are supported. If you have an older .xls file, open it in Excel and use Save As to create an .xlsx copy first.
Did this help?
Tell me what worked, what broke, or what tool you want next. I read every message.
Send feedback