What this tool does
The Duplicate Finder scans your Airtable table for records that have the same (or similar) values in fields you specify. It can flag duplicates for review, delete them automatically, or merge their data into a single record.Settings reference
Source
Match fields
Define which fields determine whether two records are duplicates. You can add multiple match fields. A record pair is a duplicate only if all match fields satisfy their respective match type. Each match field has:Match types explained
Action
Actions explained
Keep record strategies
Preview
The Duplicate Finder has a preview panel. Run a preview to see which records would be identified as duplicates before committing to the action. Review the proposed groups and confirm before running.Common questions
What if two records have both empty values in a match field?
What if two records have both empty values in a match field?
Two empty values are not considered a match. This prevents false duplicates when many records have a blank field.
Can I use multiple match fields?
Can I use multiple match fields?
Yes. All match fields must match for two records to be considered duplicates. This creates stricter matching, which is useful when a single field alone isn’t unique enough.
Can I undo the Delete or Merge actions?
Can I undo the Delete or Merge actions?
No. Deleting or merging records in Airtable is permanent. Use the Flag action first to review duplicates, and only switch to Delete or Merge after confirming the results.