Upload your dataset, choose the fields that should uniquely identify each record, and instantly see every duplicate — grouped, labelled, and ready to export. Your data never leaves your browser.
Drop your CSV or Excel file here, or click to browse
Supports .csv and .xlsx / .xls · Your data never leaves your browser
Reading file…
This may take a moment for large datasets
Works with any tabular dataset — beneficiary registers, monitoring forms, facility lists, survey exports. First row must be column headers. For large files (>50,000 rows) analysis may take a few seconds.
Step 2 — Choose your key fields
Select the column(s) that should uniquely identify each record. A duplicate is any row that shares the same values in all selected fields. Example: select "Beneficiary ID" to find the same person appearing twice. Select "Beneficiary ID + Visit Date" to allow repeat visits but flag same-day duplicates.
Smart presets — click to auto-select likely key fields:
No columns match your search.
No fields selected — select at least one above.
Duplicate Records Found
—
—
Total Rows
—
Unique Records
—
Duplicate Rows
—
Duplicate Groups
No duplicates found
Every record is unique across the selected key fields. Your dataset is clean for this combination.
Duplicate Groups
Exact duplicate — all fields identical (likely double submission)
Near duplicate — key fields match, other fields differ (Click cells to inline edit before export)
Download: Copied!
Generating…
Duplicate records at collection point — repeated submissions, double entry, merged datasets — are best prevented through form design and data governance, not just post-collection cleaning. See how I approach data systems →
Results will appear here
Upload a file, choose your key fields, and run the detector to see duplicate groups.
Processing…
This may take a moment for large datasets
Built by Cynthia Muyunda-Kambobe · Kithms EnterpriseYour data never leaves your browser