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.
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 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.
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.
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.



