# Starting a new CRM from several tools and spreadsheets | Dedupely

> Your first CRM often starts as three or four sources poured into one. The same customer is in all of them. How to dedupe across sources before the first import.

- URL: https://dedupe.ly/blog/crm-organization/new-crm-from-several-tools-spreadsheets
- Section: blog
- Published: 2026-11-17
- 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)
[CRM Organization](https://dedupe.ly/blog/crm-organization)

## Starting a new CRM from several tools and spreadsheets

By
[Gaby Salinas](https://www.linkedin.com/in/gbyslns)
Updated November 17, 2026
#
min read
TL;DR
- A first CRM usually starts from several sources: spreadsheets, an email tool, billing, phone contacts.
- The same customer appears in more than one, written differently each time.
- Import them one by one and the new CRM starts with duplicates on day one.
- Combine and dedupe the sources first, decide which source wins for each field, then import once.
- Dedupely dedupes your source spreadsheets before import, without counting toward your record limit.
Many teams don't migrate to their first CRM; they assemble it. There's a sales spreadsheet, the email marketing list, customers in the billing tool and a few hundred contacts on someone's phone. Setting up the CRM means pouring all of that into one place.
The same customer is usually in several of those sources. Import them one after another and the new CRM starts with duplicates before anyone has logged a call. This post covers how to combine the sources cleanly.

### Why several sources create duplicates

Each source was kept for a different job, so each one writes the same customer differently:
| Source | How it usually looks |
| --- | --- |
| Sales spreadsheet | Full names, company names, mobile numbers, notes |
| Email marketing list | Emails only, sometimes first names |
| Billing or invoicing tool | Legal company names, billing contacts, accounting emails |
| Phone or email contacts | Nicknames, personal emails, no company |
| Event or form lists | Whatever people typed, often in different formats |
The CRM's import will usually skip a row only when the email is identical, if it checks at all. The same person with a work email in one file and a personal email in another becomes two contacts.
Example
Say a team imports a 3,000-row sales sheet, a 9,000-person email list and 1,200 billing contacts. 2,000 people appear in two or three of the files. Imported one by one, the CRM starts with about 13,200 contacts instead of about 11,000, and every rep's first week includes finding the right record.

### Combine and dedupe before the first import

- **Pick the columns you'll keep** and map each source to them: first name, last name, email, phone, company, website, owner.
- **Put the sources side by side,** with a column that says where each row came from.
- **Find duplicates across the sources,** by email first, then by name plus company or phone.
- **Decide which source wins for each field.** Billing for legal company name, the sales sheet for phone and owner, the email tool for subscription status.
- **Import once,** from the combined, deduplicated file.
[How to find duplicates across multiple spreadsheets](https://dedupe.ly/blog/productivity/find-duplicates-across-spreadsheets)
covers step 3 in detail.

### Companies first

If the CRM has companies and contacts, build the company list first. Deduplicate it by website domain and name, import it, then import contacts linked to the right companies. Contacts imported before their companies are cleaned end up spread across duplicate company records.
Pro tip
Keep the "source" column in the CRM as a field. Months later, when a new duplicate shows up, it tells you which tool keeps creating them.

### After the import

The first import isn't the last. Forms, the email tool and the billing tool will keep creating records once they're connected. Search for duplicates a week after go-live, then on a regular schedule.

### How Dedupely helps with a first CRM

Dedupely can dedupe spreadsheets directly. Upload the source files together, up to 10 files in one upload, or combine them into one file first if you prefer. Then find duplicates by email, name, phone, domain or any column, and merge them with Merge Rules that decide which value wins in each field. Spreadsheets don't count toward your record limit, and an upload can be up to 100 MB, 1 million rows and 50 columns. Once the CRM is live, connect it to Dedupely to catch the duplicates new tools create.
[Combine your sources cleanly](https://v2.app.dedupe.ly/signup)

### One import, one record per customer

A new CRM built from several sources inherits every duplicate between them unless you combine the sources first. Map the columns, dedupe across files, decide which source wins for each field and import once.

### Frequently asked questions

#### How do I combine several spreadsheets into a new CRM without duplicates?

Map them to the same columns, dedupe across all files by email and then name plus company or phone, decide which source wins for each field, and import the combined file once.

#### Won't the CRM remove duplicates on import?

Usually only rows with an identical email, if it checks at all. The same person with two emails becomes two records.

#### Should I import companies or contacts first?

Companies. Clean and import them first, then link contacts to them.

#### Which source should win when values disagree?

Decide per field: billing for legal names, the sales sheet for phone and owner, the email tool for subscription status.

#### What should I do after the first import?

Check for duplicates a week after go-live and then regularly, since connected tools keep creating 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 How to find duplicates across multiple spreadsheets To find duplicates across several spreadsheets, line up the headers, combine the files into one list, then match and merge before you import. Gaby Salinas October 19, 2026](https://dedupe.ly/blog/productivity/find-duplicates-across-spreadsheets)
- [Productivity Why every CRM implementation should start with deduplication and keep it running Start every CRM setup with deduplication and keep it active to avoid rework, failed logic, and fragmented data. Gaby Salinas December 8, 2025](https://dedupe.ly/blog/productivity/crm-implementation-should-start-with-deduplication)
- [Productivity How to deduplicate before, during and after a CRM migration A CRM migration moves duplicates from both systems into one. Clean each source first, agree on the field that identifies records, then merge the rest. Gaby Salinas October 15, 2026](https://dedupe.ly/blog/productivity/why-every-crm-migration-needs-deduplication-first)

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