Three Alice Johnsons? Not Anymore.
New submission comes in. The Duplicate Finder checks email, name, and phone against 10,000 existing records. Match found? Flagged instantly. No more merging spreadsheets at month-end.
You've been here before
CRM Administrator
Your contact table has 3 entries for the same person with different capitalization and one typo in the email. Merge campaigns go to all three.
Nonprofit Director
Donors submit the form twice because the confirmation page was slow. Now you have duplicate donation records and incorrect totals.
HR Manager
Job applicants apply through multiple channels. You have 4 records for one candidate across different tables.
One tool, four superpowers
Multi-field matching
Match on email, name, phone, or any combination. Add multiple match fields to catch duplicates more accurately.
Configurable actions
Flag duplicates with a field value, delete them outright, or merge them into the primary record.
Batch scanning
Scan your entire table for existing duplicates. Find and clean up historical data in one run.
Flag first, delete later
Start in Flag mode to review results. Switch to Delete or Merge once you trust the match fields.
Up and running in minutes
Choose matching fields
Select which fields to compare. Email is the most reliable, but you can add name, phone, or company for multi-field matching.
Set the action
Choose Flag (mark duplicates with a field value), Delete (remove duplicates), or Merge (combine into the primary record).
Configure flag field
If using Flag mode, pick a field and value to mark duplicates. Review the preview to see which groups would be flagged.
Run the scan
Hit Run to scan all records. Check the results and adjust match fields if needed before running destructive actions.
Power features when you need them
AMatch fields
- Add multiple fields for combined matching
- Exact match comparison
- Normalized matching (case-insensitive)
- Email, phone, or ID fields work best
BActions on match
- Flag duplicates with a field value
- Delete duplicate records
- Merge into the primary record
CExecution options
- Configurable batch size
- Error handling (skip or stop)
- Filter to scan a subset of records
- Preview duplicate groups before running
Frequently asked questions
How does it decide which record is the primary?
The first record found in the table order is treated as the primary. Subsequent matches are flagged, deleted, or merged into it.
Can it merge duplicates automatically?
Yes. The Merge action combines duplicate records into the primary. Flag mode lets you review matches before running destructive actions.
Can I combine multiple fields for matching?
Yes. Add multiple match fields to require records to match on all of them. Email (exact) + Name (normalized) catches more with fewer false positives.
Can I run it on existing records?
Yes. Batch-scan your entire table to find and flag existing duplicates. Great for cleaning up historical data.
More processor tools
Related reading
Delete Duplicates Without a Unique Key
Manual methods for deduplication when you don't have a unique field.
Remove Duplicates at Scale
Strategies for cleaning large Airtable tables with thousands of records.
Remove Duplicates in Lookup Fields
Handle duplicate values in lookup and rollup fields.
Volunteer Registration
Prevent duplicate volunteer signups across events.
Explore by industry
See Duplicate Finder in action
Five forms free, unlimited submissions, no credit card. Add duplicate finder to your first form in under two minutes.
Create Your First Form Free