Remove Duplicates
Delete duplicate rows across any combination of columns.
Choose which columns define a duplicate, decide whether to keep the first or last occurrence, and remove the rest. Case and whitespace sensitivity are configurable, so “ john@x.com ” and “John@X.com” can count as the same record.
- Price
- Free
- Your files
- Never uploaded
- Runs
- In your browser
or drag it here
.xlsx, .xls, .csv · up to 50 MB · processed locally, never uploaded
Excel and spreadsheet files only. Export from Google Sheets as .xlsx or .csv.
Files stay on your device
What it does well
- Multi-column duplicate keys, not just whole-row matching
- Case-insensitive and whitespace-insensitive comparison options
- Removed rows exported to a separate sheet for auditing
How to use Remove Duplicates
- 1
Upload the workbook and select the sheet.
- 2
Tick the columns that together define a duplicate.
- 3
Choose to keep the first or the last occurrence.
- 4
Review the removal count, then download the cleaned file.
Watch a walkthrough
Common problems and fixes
Nothing was removed even though duplicates are visible.
Trailing spaces or invisible characters differ. Enable “Ignore whitespace” and “Ignore case”, or run the Data Cleaner first.
Too many rows were removed.
Too few key columns were selected. Add the columns that make each record genuinely unique, such as an ID or timestamp.
Frequently asked questions
More clean & format tools
Remove duplicates, trim whitespace, fix inconsistent dates and numbers, split or merge columns, and validate data quality before it reaches your reports.
Browse Clean & Format