If your leads live in an Excel file on one person’s laptop, a Google Sheet that three people edit at the same time, and a handful of WhatsApp chats nobody has exported, you already know how this goes. Follow-ups get missed, two salespeople call the same customer on the same day, and when the owner asks how many enquiries came in last month, someone spends half a day building the answer.
Moving to a CRM fixes this, but only if the move itself is done properly. A rushed import simply copies the mess from the spreadsheet into new software. This guide walks through the exact steps an Indian small or mid-sized business can follow to shift its leads from Excel or Google Sheets into a CRM without losing data or confusing the team.
The short answer
To move leads from Excel to a CRM, follow these eight steps:
- Collect every sheet and lead source into one master file.
- Clean the data: remove duplicates and fix phone number formats.
- Map each Excel column to a CRM field.
- Agree on your pipeline stages before you import anything.
- Check consent and keep only the personal data you actually need.
- Import a small test batch and check it.
- Import the rest, assign owners and set first follow-ups.
- Retire the spreadsheet so the team works only in the CRM.
For a small team with a few thousand rows, one to two weeks is a realistic target for planning, cleaning and going live.
Signs your business has outgrown Excel
Excel is a good tool. It is just not built to run a sales process with several people, several lead sources and daily follow-ups. You have probably outgrown it if:
- The same lead appears in two or three sheets, each with a different status.
- Follow-up dates sit in a column that nobody filters every morning.
- You cannot tell which leads came from a Facebook ad, a Google campaign, a website form or a walk-in.
- When a salesperson leaves, the context of their leads leaves with them.
- Monthly numbers are built by hand from several files.
Step 1: Gather every lead source into one master file
Before cleaning anything, bring all your leads into one place. In most Indian SMBs, leads are spread across:
- Excel files on individual laptops
- Shared Google Sheets
- Lead downloads from Facebook and Instagram lead forms
- Website enquiry emails
- The walk-in register at the front desk or showroom
- Visiting cards and notes from exhibitions and site visits
Copy everything into one workbook and add a Source column to every row before you merge (for example “Facebook ad”, “Walk-in”, “Website”, “Referral”). Once the rows are combined, you will not be able to work out where each lead came from, and lead source is one of the most useful things a CRM can report on.
Step 2: Clean the data before you import it
This is the step most businesses skip, and it is the one that decides whether the team trusts the new CRM. Here are common problems in lead sheets and how to fix them.
| Problem | Example | Fix |
|---|---|---|
| Mixed phone formats | 098421 XXXXX, +91 98421XXXXX, 9842 1XXXXX | Remove spaces and leading zeros, then store every mobile number as +91 followed by the 10-digit number |
| Numbers turned into scientific notation | 9.84E+09 | Format the phone column as Text before pasting or typing numbers |
| Duplicate leads | Same mobile number in three rows | Sort by phone number, keep the most recent row and merge the notes |
| Free-text statuses | “Intrested”, “hot”, “call later”, “RNR” | Replace with a fixed list that matches your pipeline stages (Step 4) |
| Ambiguous dates | 5/6 | Use one format, such as DD-MM-YYYY, for every date column |
| Everything in one notes cell | “Budget 40L, wants 2BHK, call after Pongal” | Move key details (budget, requirement, next call date) into their own columns |
A few Excel features make this quicker: Remove Duplicates on the Data tab, the TRIM function to strip extra spaces, Find and Replace to remove spaces and dashes from phone numbers, and Text to Columns to split a combined field. Use the phone number as your main duplicate check. Names are spelt too many ways (“Senthil Kumar”, “Senthilkumar”, “S. Kumar”) to be reliable.
Step 3: Map your Excel columns to CRM fields
Every column you keep needs a home in the CRM. Write the mapping down before you import, so everyone agrees on it.
| Excel column | CRM field | Note |
|---|---|---|
| Name | Contact name | Keep the name the customer uses |
| Mobile | Phone | +91 format, stored as text |
| Leave blank if unknown; do not type “NA” | ||
| City / Area | City | Useful for territory-wise assignment |
| Source | Lead source | Added in Step 1 |
| Interested in | Product / service | Use a fixed list |
| Status | Pipeline stage | See Step 4 |
| Handled by | Lead owner | Must match the user names in the CRM |
| Next call date | Follow-up task | Becomes a reminder instead of a cell |
| Remarks | Notes | Keep history; move key facts to fields |
Do not import every column just because it exists. If a column has not been filled in for six months, nobody needs it. On the other hand, add a few custom fields for your industry: budget and preferred location for real estate, course and batch for education, department or doctor for a clinic, policy type for insurance.
Step 4: Agree on pipeline stages before you import
Your spreadsheet probably has dozens of different status words. A CRM works best with a short, fixed set of stages that everyone understands. A simple starting pipeline is:
New → Contacted → Interested → Meeting / Visit / Demo → Negotiation → Won or Lost
Then adjust the middle stages to how your industry actually sells:
| Industry | Typical middle stages |
|---|---|
| Real estate | Site visit scheduled → Site visit done → Booking discussion |
| Education | Counselling done → Application submitted → Fee paid |
| Healthcare | Appointment booked → Consultation done → Follow-up visit |
| Finance and insurance | Needs discussed → Documents collected → Policy or loan issued |
Map every old status to one of these stages in your master file. Also add a Lost reason field (“price”, “bought elsewhere”, “not reachable”, “not interested”) so lost leads teach you something.
Step 5: Check consent and keep only what you need
Your leads’ names, phone numbers and email addresses are personal data. In India, the Digital Personal Data Protection Act, 2023 applies to personal data held in digital form, which includes your lead sheets and your CRM. A migration is a good moment to clean up:
- Drop columns you do not need for sales, such as old ID proof numbers someone once typed in.
- Note how and when each lead shared their details, where you know it.
- Decide who in the team can see, edit and export lead data. Role-based access in a CRM is far safer than a sheet anyone with the link can download.
We cover this in more detail in our guide to the DPDP Act and your CRM. This is general information, not legal advice; check specific questions with your advisor.
Step 6: Import a small test batch first
Save 50 to 100 rows as a separate file and import only those. In Excel, use Save As → CSV UTF-8 (Comma delimited). The UTF-8 option keeps names written in Tamil, Hindi or other Indian scripts readable; a plain CSV can turn them into question marks.
After the test import, check:
- Phone numbers appear in full, with +91 and no missing digits.
- Every lead landed in the right pipeline stage.
- Owners are assigned to the right salesperson.
- Dates are not swapped (5 June showing as 6 May is a common error).
- Names in regional scripts display correctly.
Fix the master file, delete the test records, and repeat until the test batch comes in clean.
Step 7: Import everything, assign owners and set first follow-ups
Now import the full file. Then give every open lead a next step, because a lead without a next action is a lead that will be forgotten again.
Treat old leads carefully. Someone who enquired two years ago may not remember you, so do not send everyone the same WhatsApp message on day one. Split them instead:
- Active leads (last 90 days): assign to an owner with a follow-up task this week.
- Older open leads: send a short, polite re-introduction and let replies decide who gets a call.
- Closed or lost leads: import for history, but keep them out of daily follow-up lists.
Step 8: Retire the spreadsheet
The most common reason CRM projects fail is that the old sheet stays alive. Half the team updates the CRM, the other half updates the sheet, and within a month nobody trusts either.
- Rename the old file “ARCHIVE – do not edit” and make it read-only.
- Connect your lead sources directly to the CRM so new enquiries from website forms, Facebook and Instagram ads, WhatsApp and Google campaigns arrive there, not in a sheet.
- Give walk-in and phone leads a simple rule: enter them in the CRM before the end of the day.
- Hold a 15-minute check-in at the end of the first week to fix anything confusing.
Common mistakes to avoid
- Importing before cleaning. Duplicates and broken phone numbers make the CRM look unreliable from day one.
- Creating too many stages. If a stage is not used every week, merge it with another.
- Skipping the lead source. Without it, you cannot tell which marketing spend actually brings business.
- Not explaining the change. Tell the team why you are moving and what they gain: fewer missed follow-ups and no more chasing files.
How ZeaCRM helps after the move
Getting the data in is the first step. The benefit comes from what the CRM does with it every day. ZeaCRM is built for Indian small and mid-sized businesses and brings leads from website forms, Facebook and Instagram ads, WhatsApp, Google campaigns and walk-ins into one inbox. Follow-ups can go out automatically on WhatsApp, SMS and email, the pipeline updates live, and AI next-best-action suggestions point your team to the leads worth calling today.
Onboarding is available in Tamil, English and Hindi, with a dedicated onboarding specialist to help your team settle in. You can see the full list of features, compare pricing, or browse CRM setups by industry.
Frequently asked questions
Can I import a Google Sheet into a CRM?
Yes. Download the sheet as an Excel file or a CSV (File → Download), clean it using the steps above, and import that file. Most CRMs accept CSV files.
How long does it take to move from Excel to a CRM?
For a small team with a few thousand leads, one to two weeks is realistic. Most of that time goes into cleaning data and agreeing on pipeline stages, not the import itself.
Should I import old or dead leads?
Import them for history, but keep them out of daily follow-up lists. Re-contact older open leads with a short re-introduction instead of a sales push.
What is the right format for Indian phone numbers in a CRM?
Store mobile numbers as text in the format +91 followed by the 10-digit number, with no spaces or leading zero. This avoids duplicates and keeps WhatsApp and SMS follow-ups working.
Will my sales team need training?
A little. Most people pick up the daily routine of checking tasks and updating stages within a few days. Training in the team’s own language makes adoption faster.
Is Excel ever enough?
For a one-person business handling a few leads a week, a well-kept sheet can work. Once more than one person follows up, or leads come from several channels, a CRM saves time and prevents missed follow-ups.
Ready to leave the spreadsheet behind?
If you would like to see how your current lead sheet would look as a live pipeline, our team can walk you through it in Tamil, English or Hindi. Book a Demo