# How to clean a spreadsheet before importing into Salesforce

> Salesforce's import matches records on name, email or record ID, and creates the rest as new. How to clean a spreadsheet so the import doesn't add duplicates.

- URL: https://dedupe.ly/blog/guides/clean-spreadsheet-before-salesforce-import
- Section: blog
- Published: 2026-11-21
- 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)
[Guides](https://dedupe.ly/blog/guides)

## How to clean a spreadsheet before importing into Salesforce

By
[Gaby Salinas](https://www.linkedin.com/in/gbyslns)
Updated November 21, 2026
#
min read
TL;DR
- Decide first whether the list goes in as leads or contacts.
- The import wizard matches on name, email or Salesforce ID, and you choose add, update or both.
- Find which rows already exist as a lead, contact or account.
- Split the file into rows to update and rows to add.
- Dedupely compares the list with your Salesforce exports and returns a clean CSV.
The cleanest Salesforce imports start with two decisions: which object the list goes into, and which rows already exist. Decide whether the people are leads or contacts, find the rows that match a lead, contact or account you already have, and split the file into one set to update and one set to add. Then the import wizard only creates records for people who are new. Dedupely can compare the list with your Salesforce exports and mark which rows already exist.
This guide follows that order, from choosing the object to the test import.

### Decide: leads or contacts?

The import wizard matches rows against the object you import into. A list imported as leads is checked against leads, not against your contacts.
| Import the list as | When |
| --- | --- |
| Leads | Most people are new and haven't been qualified, like an event or webinar list |
| Contacts and accounts | The people belong to companies you already sell to, like a customer's new team |
| Both, in two files | The list mixes new prospects and people at existing accounts |
If your team converts leads into contacts, someone on the list may already be a contact even though they're not a lead. That's why the next step checks every object.

### Find the rows that already exist

Export your leads, contacts and accounts, and compare each with the new file:
- **Leads and contacts by email:** the strongest match.
- **Leads and contacts by first name, last name and company:** catches people with another email.
- **Accounts by website or account name:** catches companies written differently, like "Acme" and "Acme Holdings".
Mark each row as new, existing lead, existing contact or existing account.
Example
Say a conference list of 1,200 people is headed into Salesforce as leads. The check finds 180 existing leads, 150 existing contacts and 70 people listed twice with two emails. Without it, the import would update the 180 leads and create new leads for the 150 contacts and for both versions of the 70.

### Check your duplicate rules

If your org has active duplicate rules, they also run during imports. Salesforce doesn't show an alert there: a row that a duplicate rule flags isn't saved, even when the rule is set to allow with an alert. Before you import, check which duplicate rules are active for leads, contacts and accounts, and after the import, review the rows that didn't load. They're often people you already have.

### Split the file in two

Once every row is marked, make two files:
- **An update file** with the rows that match an existing record, with each record's Salesforce ID from your export. Import it with "Update existing records", matched by Salesforce ID, which is the most precise match the wizard has.
- **An add file** with the new rows only. Import it with "Add new records".
Splitting keeps the wizard from guessing. Updates go to the record you chose, and new records are only created for new people.

### Clean the add file

The rows in the add file become new records, so they're worth a last pass:
- **One row per person:** merge the rows for people listed twice.
- **One spelling per account:** write each company the way it should appear in Salesforce.
- **Lowercase emails,** and one format for phone numbers and countries.
- **Required fields filled,** like last name and company for leads.
Pro tip
Add a campaign or lead source value to every row. If something goes wrong, a list view filtered on that value shows exactly what the import created.

### Run a test import

Import 25 rows from each file first. Check that the update rows changed the right records and that the add rows created leads or contacts on the right accounts. Then import the rest.

### How Dedupely sorts a Salesforce import into updates and new rows

In Dedupely, you can upload the new list together with your Salesforce exports of leads, contacts and accounts into the same spreadsheet, so the rows are matched across all of them. Match on email first, then on first and last name with company to catch a second address. When a new row is merged with a row from your export, Merge Rules decide which value wins in each column, so the merged row can keep the Salesforce ID from the export and the new details from the list. Export the result as a CSV and split it into your update and add files. A spreadsheet can have up to 1 million rows and 50 columns, so keep the exports to the columns you need.
[Prepare your Salesforce import](https://v2.app.dedupe.ly/signup)

### Know what exists before the wizard runs

Salesforce imports create duplicates when the wizard has to guess. Choosing the right object, finding the rows that already exist across leads, contacts and accounts, and splitting the file into updates and new records takes the guessing out. A small test import from each file confirms it before the full list goes in.

### Frequently asked questions

#### How do I clean a spreadsheet before importing it into Salesforce?

Decide between leads and contacts, compare the file with your leads, contacts and accounts, and split it into rows to update and rows to add. Then run a small test import.

#### Does the Salesforce import wizard check for duplicates?

It matches rows on name, email or Salesforce ID within the object you import into. If your org has active duplicate rules, they also run during the import, and rows they flag aren't saved.

#### Should I import a list as leads or contacts?

Leads for new, unqualified people. Contacts and accounts for people at companies you already work with.

#### Why did my lead import create duplicates of existing contacts?

The wizard checks the object you import into. People who are already contacts aren't matched when the list is imported as leads.

#### What's the most reliable way to update existing records?

Import them with their Salesforce ID and match by Salesforce ID, in a separate file from the new records.
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.
- [Productivity Best tools to clean a CSV before a CRM import Spreadsheet apps, scripts and data-prep apps can clean a CSV before a CRM import. See what each one finds, what it deletes and where it stops. Gaby Salinas October 28, 2026](https://dedupe.ly/blog/productivity/tools-to-clean-csv-before-crm-import)
- [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)
- [Salesforce Duplicate accounts in Salesforce and how to merge them Salesforce merges up to three accounts at a time. See how duplicate accounts form, what a merged account keeps and how to choose the principal account. Gaby Salinas October 19, 2026](https://dedupe.ly/blog/salesforce/salesforce-duplicate-accounts)

### 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)
