# How to clean a spreadsheet before importing into Pipedrive

> Pipedrive merges imported people that share a name plus email, phone or organization, and never merges deals. How to clean a spreadsheet before you import it.

- URL: https://dedupe.ly/blog/guides/clean-spreadsheet-before-pipedrive-import
- 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)
[Guides](https://dedupe.ly/blog/guides)

## How to clean a spreadsheet before importing into Pipedrive

By
[Gaby Salinas](https://www.linkedin.com/in/gbyslns)
Updated November 18, 2026
#
min read
TL;DR
- Pipedrive starts with the person's name, then checks email, phone or organization.
- Organizations are matched on their address.
- Deals are never merged on import, so every deal row is new.
- Write names the way Pipedrive has them and remove deals that already exist.
- Dedupely finds nicknames and name variants in the list before you import.
Pipedrive's import looks at people, organizations and deals differently, so a spreadsheet needs a different fix for each. Write people's names the way Pipedrive already has them, give organizations a consistent address, and take out deal rows for deals that already exist. Pipedrive merges duplicate people and organizations on its own once those columns line up, and deals need your check. Dedupely can find the name variants in your list, like nicknames, before Pipedrive sees them.
Here's how Pipedrive treats each one, and what to clean in the file for each.

### People: the name comes first

Pipedrive treats an imported person as a duplicate when the name matches, and then at least one of these also matches:
- the organization,
- the phone number,
- the email.
It checks against people already in Pipedrive and against other rows in the same file. When it finds a match, it adds the new information to the existing person.
So the name has to match before anything else counts. "Jon Snow" in Pipedrive and "Jonathan Snow" in the file, with the same email, come in as two people.
What to clean:
- **Nicknames and full names:** use the version Pipedrive already has.
- **Middle names and initials:** remove them, or match Pipedrive.
- **Name order and capitals:** first name and last name in the right columns, written normally.
Example
Say a sales rep exports 600 contacts from an old phone and email app. 140 of them are already in Pipedrive, but 35 are saved with a nickname, like "Liz" instead of "Elizabeth". Pipedrive merges the 105 whose names match and creates 35 new people, each with the same email as an existing one.

### Organizations: the address is the match

Pipedrive matches organizations on their address. Two organizations can share a name if they have different addresses, like branches of the same company.
- **Same company, same office:** write the address the same way every time, including the street format and postal code.
- **No address in the file:** there's nothing to match on, so check those organizations against Pipedrive by name before you import.
- **Branches:** keep different addresses if you track each office as its own organization.

### Deals: every row is new

Pipedrive doesn't look for existing deals when you import, so every deal row creates a deal. Before you import:
- **Export your open and recent deals** from Pipedrive.
- **Compare them with the file** on deal title and organization.
- **Remove the rows** for deals that already exist, and update those deals by hand.
Pro tip
If several reps want the same contact, don't turn off merging to give each one their own record. Each person in Pipedrive has one owner, so add the other reps as followers instead.

### Merging on or off

Merging duplicates is the default when you import. You can turn it off to create every row as a new record, but Pipedrive's own guidance warns that this clutters the database. Leave it on, and fix the names and addresses in the file so the merges are right.

### How Dedupely finds name variants before a Pipedrive import

In Dedupely, you can upload the list together with an export of your Pipedrive people and organizations into the same spreadsheet, and match the rows across both files. The "Match nicknames" setting on first-name fields pairs names like Elizabeth and Liz, so you see which rows Pipedrive would create as new people. Organizations can be matched on name with Similar Words, which compares the words in any order, and on website with Domain Root. Merge Rules decide which version of the name and address wins, and you export a clean CSV for the Pipedrive import. Spreadsheets you upload don't count toward the records on your plan.
[Get your list ready for Pipedrive](https://v2.app.dedupe.ly/signup)

### Fix the names, addresses and deals

Pipedrive's import does most of the merging if the file speaks its language: names written the way Pipedrive has them, organizations with a consistent address, and no deal rows for deals you already have. Clean those three things and the import adds new records only where they're new.

### Frequently asked questions

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

Write people's names the way Pipedrive has them, use one address format for organizations, and remove deal rows for deals that already exist.

#### How does Pipedrive find duplicates during an import?

People match on name plus organization, phone or email. Organizations match on address. Deals aren't checked.

#### Why did my Pipedrive import create a second person with the same email?

The names didn't match, for example a nickname in the file and a full name in Pipedrive, so the email was never compared.

#### Does Pipedrive merge duplicate deals on import?

No. Every deal row is imported, so compare the file with your existing deals first.

#### Should I turn off merging when I import?

Usually not. It creates every row as a new record. Fix the names and addresses in the file instead.
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)
- [CRM Organization How event and purchased lists create CRM duplicates Event and purchased lists bring people already in your CRM, messy formats and overlapping sources. Clean each list first, then check your CRM after. Gaby Salinas October 28, 2026](https://dedupe.ly/blog/crm-organization/event-and-purchased-list-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)
