How to Merge Records in Airtable

Quick summary

Merging records in Airtable requires the Dedupe extension, which lets you identify duplicate entries, select a primary record, and consolidate them without losing data. This step-by-step process helps keep your Airtable base clean, accurate, and free of redundant entries.

Steps

1. Navigate to the top-right corner and click Extensions.
2. Tap Add an Extension to open the extensions marketplace.
3. Click the search bar and type Dedupe to find the extension.
4. Locate Dedupe in the search results and click the Add button next to it.
5. Select the Table that contains the records you want to merge.
6. Specify the View within the selected table.
7. Toggle on the radio button next to the Fields that contain duplicate records.
8. Tap Review the Set of Duplicates to proceed to the review screen.
9. Select the specific duplicate you want to use as the Primary Record.
10. Tap Merge and Delete 1 Record to remove the duplicate.
11. Click Merge to confirm and finalize the record merge in Airtable.