# When an import mapped columns wrong and created duplicates

> One wrong column mapping can turn an import into hundreds of duplicates with data in the wrong fields. How to find the damage and clean it up.

- URL: https://dedupe.ly/blog/duplicates/import-mapped-columns-wrong-duplicates
- Section: blog
- Published: 2026-11-18
- Site index: https://dedupe.ly/llms.txt
- Any page: append `.md` to its URL for this plain-text form

---

Skip to content
[New Dedupely Intelligence Now on every paid plan, monthly or yearly.](https://dedupe.ly/ai-deduplication)
[Blog](https://dedupe.ly/blog)
[Duplicates](https://dedupe.ly/blog/duplicates)

## When an import mapped columns wrong and created duplicates

By
[Gaby Salinas](https://www.linkedin.com/in/gbyslns)
Updated November 18, 2026
#
min read
TL;DR
- One wrong mapping can put names in the company field, skip the email column or swap first and last names.
- The CRM can't match those rows to existing records, so it creates new ones.
- First find the import's records by date or import name, and decide whether to delete the batch or merge it.
- If the import added anything new, like real contacts or activities, merge the duplicates instead of deleting.
- In Dedupely, filters focus a search on one import, and cross-field matching catches values in swapped fields.
An event list goes into the CRM at the end of a long day. The email column was mapped to "Secondary email". Or first and last name were swapped. Or the company column landed in "Job title". The import ran, and the CRM couldn't match any row to the contacts that were already there, so it created a new record for each.
The next morning, there are 900 new contacts, most of them duplicates with data in the wrong fields. This post covers how to clean up after a bad import.

### What a wrong mapping does

| Mistake | What the CRM does |
| --- | --- |
| Email mapped to a field the CRM doesn't match on | Creates a new contact for every row, even existing people |
| First and last name swapped | Creates records that don't match on name |
| Company mapped to the wrong field | Leaves contacts without a company, or creates new companies |
| A column mapped to a field with existing data | Overwrites good values on existing records |
The first one is the most common, and the most damaging: the field the CRM uses to find existing contacts came through empty.

### Step 1: Find the import's records

Every import leaves a trail you can filter on:
- **Created date and time:** the records arrived together.
- **Import name or list:** many CRMs tag records with the import they came from.
- **Created by:** the user who ran the import.
Count them, and check a sample to see which mapping went wrong.

### Step 2: Delete the batch or merge it?

| If the import... | Then |
| --- | --- |
| Only created duplicates of people already in the CRM, and nothing else touched them | Deleting the batch and re-importing correctly is usually simplest |
| Also created real new contacts | Merge the duplicates, keep the new ones |
| Has had activity since: emails sent, calls logged, workflows run | Merge, so that activity isn't lost |
| Overwrote values on existing records | Restore those values from a backup or export, then merge |
Deleting is only clean if nothing else depends on the new records.
Example
Say an event import maps the email column to "Other email". The CRM creates 900 new contacts, and 700 of them are people already in the CRM. A welcome workflow has already enrolled them all. Deleting would lose the enrollment history, so the team fixes the email field on the imported records, merges the 700 duplicates into the existing contacts and keeps the 200 new people.

### Step 3: Fix the values, then merge

- **Move values to the right fields** on the imported records, where you can, with a bulk update.
- **Match the import's records against the rest of the CRM,** on email if it's now in the right field, or on name plus company.
- **Keep the existing record as the survivor,** so its ID, owner and history stay.
- **Make sure blanks don't win,** so empty imported fields don't overwrite real values.
Pro tip
Before your next import, import ten rows first and check them in the CRM. A wrong mapping shows up on row one.

### How Dedupely helps after a bad import

In Dedupely, filters on any synced field, like created date or an import or source field, let you focus a search on one import's records. Cross-field matching catches values swapped between the fields of a match, like first and last names entered the wrong way round. The Primary Record setting, for example Oldest Record, keeps the existing contact as the survivor, and blank values never win, so empty imported fields can't overwrite real data. Merge History records each merge with the original values.
[Clean up a bad import](https://v2.app.dedupe.ly/signup)

### Find it, decide, then merge

A bad mapping turns an import into a batch of duplicates. Find the batch by date or import name, delete it only if nothing depends on it, otherwise fix the values and merge into the existing records, keeping their history and owners.

### Frequently asked questions

#### How do I fix duplicates from an import with the wrong column mapping?

Find the import's records by date or import name, fix values in the wrong fields, then merge the duplicates into the existing records.

#### Should I delete the imported records?

Only if they're all duplicates and nothing has happened to them since. If they include new contacts or activity, merge instead.

#### Why did the import create new records instead of updating?

The field the CRM uses to find existing records, usually email, was mapped to the wrong column or came through empty.

#### What if the import overwrote good data?

Restore those values from a backup or recent export before merging.

#### How do I avoid this next time?

Import a few rows first, check them in the CRM, then import the rest.
Behind the article

### Gaby Salinas

Marketing Assistant at Dedupely
Gaby Salinas came to CRM data from marketing and advertising, so she looks at duplicates from two sides: the match and merge logic behind them, and what they do to the people using the CRM, like the rep who calls a customer twice, the admin who gets blamed and the cleanup nobody wants to start.
As Marketing Assistant at Dedupely, she follows how RevOps teams, end users, consultants and technical teams actually work with their data: the records they stop trusting, the workarounds they build and the moment they finally decide to clean up. What she finds shapes most of what Dedupely publishes.
[Connect with Gaby on LinkedIn](https://www.linkedin.com/in/gbyslns)

### Contact us

We’d be happy to help you get this set up.

#### Write us a message

We probably know the answer to your question already
help@dedupe.ly
Email copied to your clipboard!
[Book a Zoom Whether you’re getting started or getting intense. Get in touch! Book a zoom](https://meetings.dedupe.ly/meetings/gaby-salinas/dedupely-zoom-scheduler)

### Discover Related Blog Posts

Stay updated with our latest articles and insights.
- [CRM Organization Should You Clean Spreadsheets Before Uploading or Clean Your CRM After? Cleaning the file first stops duplicate rows and triggered workflows. Cleaning the CRM after links new records to the accounts you already have. Gaby Salinas September 10, 2026](https://dedupe.ly/blog/crm-organization/clean-spreadsheets-before-uploading-or-clean-your-crm-after)
- [Duplicates Should you merge duplicates or delete them? Merge duplicates that carry history, associations or attribution. Delete only junk, test and spam records. A simple rule for each case. Gaby Salinas October 19, 2026](https://dedupe.ly/blog/duplicates/merge-or-delete-duplicates)
- [Duplicates Placeholder values that make records look like duplicates Values like test@test.com, John Doe or 1234567890 group unrelated records as duplicates. How to spot them, leave them out and keep them from winning. Gaby Salinas October 19, 2026](https://dedupe.ly/blog/duplicates/placeholder-values-false-duplicates)

### Get started for free

20 free trial merges and as much free support as you need to get your duplicates under control.
[Try for free](https://v2.app.dedupe.ly/signup) [Talk to sales](https://meetings.dedupe.ly/meetings/gaby-salinas/talk-to-sales)
[Or sign up with Google](https://v2.app.dedupe.ly/signup/google)
Running CRM cleanup for clients? [See the Partner Program](https://dedupe.ly/become-a-partner)
