)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
Salesforce Data Import Wizard often creates duplicate records even with duplicate rules enabled, especially when matching email addresses from Excel data. The native tool struggles with incomplete email matching and can cause data inconsistencies that damage your CRM integrity.
Here’s how to map Excel email data to existing CRM contacts using UPSERT functionality that specifically prevents duplicate record creation.
Prevent duplicates when mapping Excel emails to Salesforce using Coefficient
Coefficient UPSERT functionality automatically updates existing records when email addresses match and only creates new records when no match exists. This eliminates the duplicate creation problem that plagues standard Salesforce import processes.
How to make it work
Step 1. Configure Email as an External ID in Salesforce.
Navigate to Setup > Object Manager > Contact > Fields & Relationships and set your Email field as an External ID. This enables UPSERT operations to use email addresses as the matching criteria for record updates.
Step 2. Import your data into Google Sheets.
Use Coefficient to import your Excel data alongside existing Salesforce Contact data into Google Sheets. This creates a unified workspace where you can review and prepare your mapping before execution.
Step 3. Set up UPSERT export with Email as the External ID.
Configure Coefficient’s export to use UPSERT action with Email as the External ID field. Map your Excel columns to corresponding Salesforce Contact fields, ensuring data flows to the correct locations.
Step 4. Preview changes before execution.
Use Coefficient’s preview functionality to review all changes before execution. This lets you identify potential issues and verify that your mapping logic will update existing records rather than create duplicates.
Step 5. Process records in controlled batches.
Configure batch processing from 200-10,000 records to maintain data quality oversight. Coefficient provides detailed status columns showing exactly which records were updated, created, or encountered errors.
Start mapping without the duplicate risk
This approach gives you precise duplicate management and data quality control that standard import tools cannot provide. Begin mapping your Excel email data to Salesforce contacts with confidence today.
