How the Duplicate Detector Works
Upload Your File
Import your data in CSV, XLS, or XLSX format.
Choose a Reference Column
Select the column you want to use to detect duplicate values
(e.g., email, phone number, ID, name…).
Scan for Duplicates
Click “Scan for Duplicates” and let the tool analyze your file.
View Your Results
You’ll instantly see:
- Total records in the file
- Number of duplicate records
- Number of unique records
Select What You Want To Do With Duplicates
You have three options:
Highlight
- Marks all duplicate rows in red within the preview table
- Export the file with visual duplicate markers
Delete
- Removes duplicate records completely
- Export a clean file with only unique entries
Merge
- Combines duplicate entries into one organized record
- Ideal for datasets with repeated but valuable info
