Moving your sales from Excel to a CRM, step by step
How to move leads and clients from Excel sheets into a CRM without losing data or your team's trust.
By the CRM Bingo team ยท 20 November 2026 ยท 6 min read
Moving sales from Excel to a CRM sounds like a big IT project, but for most small and mid-size businesses it is a two to three week job if you do it in the right order. The hard part is not the software. It is cleaning your data and changing the team's daily habit. Here is a step-by-step plan that works.
Step 1: Gather every sheet in one place
Start by collecting every file that holds customer or lead data. In a typical business this means the master lead sheet, each salesperson's personal sheet, the IndiaMART export, a list of past customers from accounts, and perhaps a few visiting-card photos. Ask each salesperson to share their file. Make it clear this is not an audit; you simply want nothing left behind.
Copy all of them into one folder. Do not edit the originals. Keep them as a backup until the move is finished.
Step 2: Decide your columns
Different people will have used different columns for the same thing: "Mob", "Phone", "Contact No", "WhatsApp". Before importing, agree on one standard set. Keep it short. You can always add fields later.
| Column | Why it matters |
|---|---|
| Name | Contact person's name |
| Company | For B2B sales; leave blank for retail buyers |
| Mobile | The main key for finding duplicates |
| Optional, but useful for quotations | |
| City / State | Needed for territory and for GST type on quotations |
| Source | IndiaMART, website, referral, exhibition and so on |
| Requirement | Product or service and quantity, in a few words |
| Owner | Which salesperson is handling it |
| Stage | Where the lead stands today |
| Next follow-up date | The single most useful column |
| Notes | Last conversation summary |
Step 3: Clean the data
This is the step most people rush, and it is the one that decides whether the CRM feels trustworthy on day one. Work through these points.
- Fix phone numbers. Remove spaces, dashes and "+91" inconsistencies so every mobile number is in the same 10-digit format. Numbers with fewer digits are usually typing errors; check them or mark them.
- Fix names. Use proper case ("Rakesh Patel", not "RAKESH PATEL" or "rakesh bhai").
- Standardise cities and sources. "Ahmd", "Ahmedabad" and "Amdavad" should all become one spelling. Same for sources.
- Remove junk rows. Test entries, blank rows, job seekers and vendors who enquired by mistake do not belong in a sales list.
- Mark very old leads. A lead from three years ago with no response is not a lead. Either import it with a "Cold" or "Archive" stage, or leave it out.
Step 4: Remove duplicates
When you merge sheets from five salespeople, you will find the same customer more than once. Sort by mobile number and look for repeats. When you find one, keep the row with the most recent activity and copy any useful notes from the other row into it.
Decide in advance who "owns" a customer when two salespeople have both worked on them. A simple rule is: the person with the latest real conversation keeps it. Agree on this openly, or it becomes a quarrel later.
Step 5: Set up stages before importing
Create your sales stages in the CRM before you import, so each lead lands in the right place. Keep them few and clear. A trader might use: New, Contacted, Quotation sent, Negotiation, Won, Lost. A real estate firm might use: New, Site visit planned, Site visit done, Booking discussion, Booked, Lost. Map whatever your sheets used ("hot", "pending", "call later") to these stages. Our guide on sales pipeline stages goes deeper.
Step 6: Import a small test first
Import twenty or thirty rows first. Open a few records and check that names, phones, stages, owners and dates came in correctly. Date formats are a common problem: 03/04 can mean 3 April or 4 March depending on the setting. Fix the mapping, delete the test, then import the full file.
A good CRM will check for duplicates during import and skip rows that already exist. If yours does not, the cleaning in Step 4 becomes even more important.
Step 7: Assign owners and follow-up dates
After import, check that every open lead has an owner and a next follow-up date. A lead with no owner is nobody's job. A lead with no date will never come up in anyone's daily list. Spend an hour with the sales head going through unassigned leads and sharing them out.
Step 8: Train the team in one short session
Keep training practical and under an hour. Show only what a salesperson does every day:
- Open today's follow-up list.
- Call the lead, then add a note and set the next date.
- Move the lead to the next stage.
- Add a new lead that came by phone or walk-in.
- Send a quotation.
Install the mobile app on every salesperson's phone during the session itself, not "later". Later rarely comes.
Step 9: Run both for one week
For one week, let the team keep the old sheet if they want, but every new lead and every follow-up must also go into the CRM. At the end of each day, the sales head checks that the CRM has today's work. This overlap gives nervous team members confidence and catches any missing data.
Step 10: Retire the sheet
After the week, announce a clear date: from this day, the CRM is the only record. Move the old sheets to an archive folder that is read-only. Then make one change that matters more than any other: run your weekly sales meeting from the CRM screen. When the owner stops asking for Excel files, the team stops making them.
Common mistakes to avoid
- Importing dirty data and planning to "clean it later".
- Creating twenty custom fields on day one.
- Letting one senior salesperson stay on Excel as an exception.
- Training once and never checking whether the CRM is actually being updated.
Key takeaways
- Collect every sheet, agree on a short set of columns, then clean before importing.
- Mobile number is your best key for finding duplicates.
- Set up stages first and test the import with a small batch.
- Every open lead needs an owner and a next follow-up date.
- Run both systems for one week, then retire the sheet and run meetings from the CRM.
Still deciding which CRM to move to? See how to choose a CRM.
How CRM Bingo helps
CRM Bingo imports your Excel or CSV files and skips duplicates automatically, and our team can do the set-up and import for you, including stages for your industry. Once you are live, follow-ups come with reminders and a 9 am daily list, and the deals board replaces your status columns. New enquiries are answered by the AI Agent from the first day. Talk to us about moving your data.
Put this into practice
See how CRM Bingo and its AI Agent do it for you.