Almost every Indian business we speak to has the same sheet. It started as a simple list of names and numbers, then grew columns for project, status, remarks, follow-up date and executive name. Today it has thousands of rows, three colours of highlighting that mean different things to different people, and at least two copies on someone's laptop.
Moving to a CRM does not need a consultant or a long project. It needs a clean sheet, a clear column plan and a decision about what to leave behind. Here is the routine.
Step 1: decide what to move
You do not have to move every row. The leads that matter on day one are the open ones: customers who are still deciding, have a visit planned, or are waiting on a quote. Won and lost leads from two years ago can stay in the old file for reference. Moving them adds clutter and makes reports misleading in the first month.
Filter the sheet to open leads from the last six to twelve months. For most small businesses, that is a few hundred rows, not thousands.
Step 2: clean the sheet
- Delete blank rows and test entries.
- Put one phone number per cell, digits only, without spaces.
- Fix the obvious duplicates, such as the same customer entered by two executives.
- Agree one spelling per status, so Followup, Follow up and F/U become one value.
- Agree one spelling per source, such as Website, Walk-in, Referral or IndiaMART.
- Fill in the executive name on every row that has an owner.
This is the step most people skip, and it is the one that decides whether the team trusts the CRM. Bad data in a new system still looks like bad data.
Step 3: match your columns to the import template
A CRM import expects specific columns in a specific order. Download the import template first and copy your data into it, rather than trying to make the CRM understand your sheet. Columns that do not fit, such as long remarks, can go into one notes field after import or stay in the old file.
Step 4: save as CSV and import in batches
In Excel or Google Sheets, choose Save As or Download, then CSV. Check the file in a text editor if Hindi or Marathi names look strange, and save as CSV UTF-8 if your version offers it. If the list is long, split it into batches so a mistake in one file is easy to find and fix.
Step 5: give every lead an owner
An imported lead with no owner is the same problem as a row with no executive name: nobody calls. Either fill the owner column before import, or assign the imported leads straight after, before anyone starts work. Then ask each executive to check their list and set a next follow-up date on every open lead.
Step 6: stop new leads going into Excel
The import moves the old leads. What stops the sheet coming back is capturing new enquiries directly in the CRM. Put a CRM form on your website, enter phone and walk-in enquiries straight into the CRM, and make the old sheet read-only. Keep it for a month as a safety net, then archive it.
Common problems and fixes
- Phone numbers turned into 9.87E+09: format the column as text before saving as CSV.
- Dates read the wrong way round: use one format for the whole column.
- The header row does not match: copy the data into the downloaded template instead of renaming columns.
- The same customer appears twice: decide which row is current and delete the other before import.
What to tell the team on day one
The move fails when people quietly keep using the sheet. Tell the team three things on the first morning. From today, every new enquiry goes into the CRM, not the sheet. Every open lead must have a next follow-up date by the end of the week. And the sheet is now read-only, so any change made there will be lost. Then sit with each executive for ten minutes and check their list together.
A realistic first week
- Day 1: import the open leads, assign owners and make the sheet read-only.
- Day 2: connect the website form so new enquiries arrive in the CRM directly.
- Day 3: every executive sets a next follow-up on each of their open leads.
- Day 4: the manager checks the overdue list in the morning meeting.
- Day 5: fix whatever confused people, such as a status name or a missing source.
By the second week, the question is no longer where the latest sheet is. It is which leads are overdue today, which is the question that actually wins customers.
Moving to AliveCRM
AliveCRM imports leads from a CSV file using a fixed template, which you download from the import screen. The template columns are Name, Email, Phone, Project Name, Location, Lead Value, Assigned To, Status, Source and Last Contact. Each row needs a name and either a phone number or an email. Sources and assigned users must match ones already set up in AliveCRM, so add your sources and invite your team first; an unknown status falls back to your default status. Each file can hold up to 2,000 rows. Save your Excel sheet as CSV first: AliveCRM imports CSV files, not Excel files directly.
Imported leads sit in the same list as website leads, with the same statuses, owners and follow-ups. If a phone number or email already exists, the new lead is flagged as a possible duplicate rather than refused, so you can review it. Auto-assignment rules apply to website form leads, so assign imported leads by hand or through the Assigned To column. When you need a copy back, export the lead list to Excel, CSV or PDF.