How to Batch Update and Deduplicate Contacts via CSV in Airtable
Learn how to import, merge, and update contact conference data in Airtable using CSVs, helper columns, and Excel deduplication techniques.
This guide explains how to batch upload and update contact lists in Airtable using a CSV file. By following these steps, you will merge new attendees into your CRM, properly update their conference history without overwriting past events, and prevent duplicate database records.
This workflow is ideal for marketing operations, CRM managers, and event coordinators who need to sync post-conference attendee lists with an existing database of contacts.
Prep the Initial CSV
Before importing your attendee list into Airtable, you need to tag the new data so you can easily identify it once it's merged with your database of thousands of existing contacts.
Import and Merge in Airtable
Now, upload the prepped CSV to your CRM. It's critical to configure the import settings correctly so existing contacts are updated rather than duplicated.
Before saving, verify your import configuration matches these required settings:
Setting | Required State | Purpose |
|---|---|---|
Merge with existing records | Checked | Prevents duplicate contacts from being created. |
Create missing select options | Checked | Ensures new conference tags are generated automatically. |
Email Address | Mapped | Acts as the primary key to match incoming records to existing ones. |
Export and Format Data
Because we used a helper column, we can easily isolate the batch we just uploaded, export it, and format the historical data.
Upload Helper equals 6 and click Apply.
Open the downloaded CSV in Excel to begin data formatting.
Process Existing vs. New Contacts
You must handle brand-new contacts differently than existing contacts who already have past conference data.
Handling New Contacts
These represent brand-new contacts. Simply copy the data from the Current Conferences column and paste it directly into the All Conferences column.
Handling Existing Contacts
=CONCAT(Past Conferences, ", ", Current Conferences).Final Import and Cleanup
Now that you've calculated the updated lifetime event history for each contact, re-import the file to apply the final changes.
Upload Helper and Conferences Upload Aid values and click Clear contacts to clean up the database.
Q: Why do we use an Upload Helper column?
A: It allows you to tag and easily filter the specific batch of contacts you just imported out of tens of thousands of existing records in the database.
Q: How do we prevent duplicate contact records during the import?
A: When importing the CSV into Airtable, ensure "Merge with existing records" is checked and explicitly map the "Email Address" field as the unique identifier.
Q: What happens if an existing contact already has past conference data?
A: You use a concatenate formula in Excel to combine their existing past conferences with the current conference, separating them by a comma so no historical data is lost.
Term | Definition |
|---|---|
CSV | Comma-Separated Values, a common plain text format used to store and transfer spreadsheet or database data. |
Concatenate | A spreadsheet function that links or combines strings of text from multiple cells together into a single cell. |
Primary Key | A unique identifier (like an Email Address) used to match and merge incoming data with existing records. |
Deduplication | The process of eliminating redundant or duplicate copies of data from a system or database. |