Excel is not a CRM. That's obvious, yet in one survey 43% of small businesses still kept their customer base in spreadsheets. A sales rep quits and takes the contact file with them. Two reps call the same client because they can't see each other's rows. The boss asks for a report, and an analyst spends three days pulling data from 12 files. Sound familiar?
Moving from Excel to a CRM is not “just uploading a file”. It's a change to your sales process. Done carelessly, the reps push back, data gets lost and the money spent on the CRM is wasted. Done to a plan, in 3-4 weeks you get a transparent pipeline, automatic reports and control over every deal.
This article gives you a step-by-step migration plan with concrete numbers, a checklist and a breakdown of typical mistakes.
their base in Excel or Google Sheets
switching to a CRM
including team training
When Excel stops working: 7 signs
Excel is a powerful tool. It works great for small volumes: 50-100 contacts, 1-2 sales reps, a simple pipeline. But at some point spreadsheets start holding the business back.
If you recognized yourself in at least three of these points, it's time to migrate. If in five, you're already losing money every day.
Stage 1: Audit your current data
Before moving data anywhere, you need to understand what you actually have. The typical picture: a main spreadsheet with 3,000 rows, another 5-8 files named “copy (2)”, duplicates, empty fields, contacts without names, phone numbers in different formats.
What to do
Inventory the files. Collect every Excel or Sheets file that holds client data. Not just the main one: reps often keep their own private “notebooks”. Ask each rep to show you every file they work with.
Assess data quality. For each file, check how many unique contacts there are, which fields are filled in, what share are duplicates, and whether there's an interaction history (call dates, comments). Typically 20-40% of rows are duplicates or junk.
Map the fields. Write down every column from every file. Most likely each rep uses a different structure: one keeps the city in a separate column, another puts it in the address, a third doesn't record it at all. You need one structure.
The cost of an audit: 2-5 days of work if you do it yourself. If you hire an integrator, $500-1,500. Either way, you get a clear picture and a migration plan.
Stage 2: Choose a CRM
Choosing a CRM is a big topic of its own. We covered it in detail in our guide to choosing a CRM. Here's a short cheat sheet for teams coming from Excel.
For small businesses (up to 10 sales reps)
Pipedrive: simple, quick to set up, good pipeline automation. Paid plans start at roughly $15 per user a month. A great fit for B2B sales with a short deal cycle.
HubSpot: more features (marketing, service, tasks), takes longer to learn. There's a free CRM plan. A fit if you want sales, marketing and service in one place.
For mid-sized businesses (10-50 sales reps)
Salesforce, an enterprise plan of an off-the-shelf CRM, or a custom CRM. At 20+ users, the per-seat fees of off-the-shelf CRMs start to bite. A custom CRM on Next.js + PostgreSQL costs from $9,900 for an MVP, with no per-user subscription fees.
Don't pick a CRM by the number of features. Pick it by how well it fits your sales process. A good CRM is the one your reps will actually use.
Stage 3: Prepare the data for migration
The most labor-intensive stage. This is exactly where people cut corners, and then end up with a CRM full of junk.
Deduplication
Find and merge duplicates. Ways to do it: sort by phone or email (the most reliable identifiers), conditional formatting to spot them visually, VLOOKUP/INDEX-MATCH formulas to cross-check files. With 1,000+ rows, use a script or a dedicated service (Dedupe.io, or OpenRefine, which is free). Deduplicating 3,000 contacts by hand takes 1-2 days.
Normalization
Bring the data to one format: phone numbers in international format, like +1XXXXXXXXXX (no parentheses, dashes or spaces), company names without quotes or duplicated legal suffixes (LLC, Inc.), cities spelled out in full (no abbreviations), dates in one format (for example, YYYY-MM-DD), deal stages mapped to the stages of the CRM pipeline.
Enrichment
If you can, fill in missing data before the migration. Company website, industry, company size: this is easier to do in Excel (with bulk lookups) than to type into the CRM one record at a time later.
The cost of data preparation: $700-3,500 (depending on the volume and quality of the source data). 1,000 contacts: $700-1,000. 10,000 contacts with history: $2,000-3,500. Cutting corners here guarantees headaches later.
Stage 4: Set up the CRM for your process
A CRM doesn't work out of the box. It has to be set up for your business process. Here's the minimum:
Sales pipeline. Move the stages out of people's heads (or out of Excel columns) into the CRM. A typical pipeline: New lead → Qualification → Proposal sent → Negotiation → Contract → Payment → Delivery. Don't create more than 7-8 stages, or reps will get confused.
Contact and deal fields. Set up the same fields you had in Excel, plus the ones you were missing. Required: name, phone, email, company, lead source, owner (the responsible rep). Optional but useful: industry, company size, previous experience.
Roles and permissions. A rep sees only their own deals. The manager sees all of them. The marketer sees contacts only, without deal amounts. Excel simply can't do this, and it's one of the main reasons to migrate.
Automations (the basics). Automatic lead assignment, task reminders, alerts when a deal sits in a stage too long. Don't overload the CRM with automations at the start: add them as the team gets comfortable.
(pipeline + fields + roles)
(phone system, ERP, email)
an off-the-shelf CRM
Stage 5: Import the data
The technical part of the migration. It sounds simple: upload a CSV and you're done. In practice, there are some catches.
Preparing the import file
Create one CSV/XLSX file with columns that match the CRM fields. Check the encoding (UTF-8 is the standard). Make sure there are no formulas, only values. The first row holds the headers (the CRM field names).
Test import
Never import everything at once. Upload 50-100 records. Check that every field is in place, phone numbers are formatted correctly, dates were recognized, and the contact-company-deal links work. If something is off, fix the mapping and try again.
Full import
Once the test succeeds, upload everything. The order: companies first, then contacts (linked to companies), then deals (linked to contacts). If you have history (calls, emails), it's imported as notes on the contacts.
Import time: 1,000 contacts take 1-2 hours (including checks). 10,000 contacts take 1-2 days. At 50,000+ you may need a script that uses the API instead of the standard import.
Back up your Excel files before the import and keep them for at least 3 months. If something goes wrong or data “disappears” during the import, you'll have something to restore from.
Stage 6: Train the team
80% of failed migrations are not technical. They fail because the team pushes back. Reps are used to Excel. A CRM means a new interface, new rules and a temporary drop in speed. If you don't prepare people, they'll just keep their own spreadsheets on the side.
How to train
Group training (2-4 hours). Show the basic operations: creating a contact, moving a deal through the pipeline, adding tasks, working with the phone system. Use real data, not a demo database.
One-on-one help (the first 2 weeks). Appoint a “CRM champion”: the most tech-savvy rep, who will help colleagues. Or set aside 1-2 hours a day for the team's questions.
Ground rules. Clear rules: every contact goes into the CRM. Every call is logged. Every deal has its required fields filled in. Without written rules, a CRM turns into an optional notebook that nobody uses.
The most important point: the manager must look at reports ONLY from the CRM. Not from Excel, not “send me the spreadsheet”. Only the CRM. It's the only way to get everyone to fill it in.
The cost of training
On your own (videos + documentation): $0, and 1-2 weeks to get up to speed. With an integrator: $1,000-2,500 (group training + written rules). With hands-on support (2-4 weeks): $1,500-4,500, with the integrator helping the team in real working conditions.
Stage 7: Transition period and control
The first 2-4 weeks after launch are critical. This is when the migration either takes root or slides back to Excel.
Running in parallel (1-2 weeks)
For the first week, reps can enter data both in the CRM and in Excel. It lowers the stress. From the second week on, the CRM only. Excel stays as an archive of historical data (no longer updated).
Checking that the CRM is filled in
Check weekly: are all deals in the CRM (compare with the number of incoming leads), are the required fields filled in, are the stages up to date (no deals stuck in limbo). In the first month, the manager checks daily. It's tedious, but necessary.
Feedback and adjustments
Collect feedback from the reps: what's inconvenient, what's missing, what slows them down. The first 2-4 weeks are a tuning period. Usually you need to add 2-3 fields, remove unnecessary stages and set up a couple more automations. That's normal: nobody gets the setup perfect on the first try.
team pushback
to adapt to the CRM
fully takes root
The total cost of migration
Here's the budget by stage for a company with 10-15 sales reps and a base of 3,000-5,000 contacts:
Data audit: $500-1,500 (or 2-5 days in-house).
Data preparation: $1,000-2,000 (deduplication, normalization, enrichment).
CRM license: from $0 (HubSpot's free plan) to a few hundred dollars a month (a paid plan for 10 users).
CRM setup: $2,000-6,500 (pipeline, fields, roles, basic integrations).
Data import: $500-1,500 (mapping, test import, full import).
Training: $1,000-2,500 (group sessions + written rules).
Hands-on support (1 month): $500-1,500.
Total: $5,500-15,500, one-off. Plus the CRM subscription.
Can it be cheaper? Yes, if you do the data preparation and training yourself. The minimum budget with an integrator is $2,500-4,500 (setup + import). But saving on data preparation usually backfires: junk in a CRM is worse than junk in Excel.
5 mistakes when migrating from Excel to a CRM
We've seen these dozens of times, at clients and at competitors.
1. Importing “as is”, without cleanup. You uploaded 5,000 rows with duplicates, empty fields and junk. The CRM is cluttered, the reps don't trust the data and keep a spreadsheet on the side. The fix: spend 2-3 days on cleanup BEFORE the import.
2. Choosing a CRM because a friend recommended it. “It works for Pete, so it'll work for us.” But Pete has 3 sales reps and B2C sales, while you have 15 reps and B2B deals with a long cycle. The fix: write down your CRM requirements BEFORE you choose.
3. No ground rules. The CRM is installed, the data is loaded: “okay, get to work”. A month later, half the reps don't use it and the other half fill it in however they like. The fix: written rules + the manager's oversight.
4. Reconfiguring on the fly. Every week brings new fields, new stages, new rules. The reps never get used to it, get annoyed and push back. The fix: freeze the structure for 2-3 months and make big changes once a quarter.
5. No “champion”. If nobody on the team owns the CRM (not on paper, but actually helping colleagues, checking data entry and collecting feedback), the system will die. Appoint an owner and give them 2-4 hours a week for the job.
Excel to CRM migration checklist
Print it out and tick items off as you go:
Our approach: migration from $3,900
At March Code we help companies move from Excel to a CRM, whether it's an off-the-shelf system or a custom CRM. The process:
If off-the-shelf CRMs don't fit you, we help you choose or build a custom CRM from $9,900 with no subscription fees.
FAQ
Can I migrate from Google Sheets the same way as from Excel?
Yes, the process is identical. Google Sheets exports to CSV/XLSX, and from there you follow the same plan. The only difference: if you use Google Workspace, some CRMs integrate with Sheets directly, which makes the import easier.
What if the sales reps refuse to switch to the CRM?
It happens a lot. The solution: 1) explain what's in it for the reps (not just for management): automatic reminders, client history, mobile access; 2) strip the interface down to the minimum by removing unnecessary fields and stages; 3) make the CRM mandatory: reports only from the CRM, bonuses only based on CRM data; 4) give it time: lower the sales targets by 10-15% for the first 2 weeks.
Can I move my email and call history?
Partly. If the correspondence went through corporate email, yes: most CRMs import email history. If it went through a rep's personal WhatsApp, no: WhatsApp doesn't allow bulk export. Call recordings from a cloud phone system, yes, via the API. Manual notes from Excel, yes: they're imported as notes on contacts.
How long does it take for a CRM to pay for itself?
With a proper rollout, 2-4 months. The main sources of payback: 15-25% higher lead conversion (thanks to automatic reminders and stage control), time the reps save on reporting (1-2 hours a day each), and fewer lost clients (nobody “forgets” to call back anymore). For a team of 10 reps bringing in $100K a month, a 15% rise in conversion means +$15K a month. With a migration cost of $6,500, it pays for itself in the very first month.
Should I connect all integrations right away?
No. At the start, connect only the critical ones: the phone system (if your reps make a lot of calls) and email. The accounting system, messengers and the website can come 1-2 months later, once the team is comfortable with the basic CRM. Every new integration is stressful for the team, so add them one at a time.
What if data “disappeared” after the migration?
Don't panic. First, you should have a backup of the original Excel files. Second, check the filters in the CRM: often the data isn't lost, it's just hidden by a filter on the owner or the stage. Third, check the field mapping from the import: data may have landed in the wrong fields. If it's really gone, restore it from the backup and repeat the import.
Should I hire an integrator or migrate on my own?
It depends on the scale. Up to 500 contacts and 3-5 sales reps, you can do it yourself in 1-2 weeks (HubSpot, Pipedrive and similar CRMs have good built-in import tools). With 500-5,000 contacts, we recommend an integrator at least for data preparation and setup. With 5,000+ contacts, an integrator is a must, or you risk losing data or ending up with a CRM full of junk.
