
To move your leads from Excel to a CRM: clean the sheet, save it as CSV or Excel, map the columns, import a small test first, and then import the rest. Most problems come from messy data, not from the import itself.
1. Back up the sheet
Make a copy of the file today. Keep it until you are sure everything is in the new system.
2. Clean the sheet
Spend 30 minutes here and the import will go smoothly.
- One row per lead. Not one row per call.
- One phone number per cell, in the same format, for example 10 digits without spaces.
- Remove duplicates. Sort by phone number and look for repeats.
- Fix the status column. Use a few clear values like New, Contacted, Won, Lost instead of long notes.
- Keep one source per lead, like Google, Meta, referral, walk-in.
- Put notes in one column.
If you are unsure which columns to keep, see what to track in a lead sheet.
3. Match your columns to the CRM fields
A typical mapping:
| Your column | CRM field |
|---|---|
| Name | Name |
| Mobile | Phone |
| Where from | Source |
| Status | Stage |
| Next call date | Follow-up date |
| Remarks | Notes |
4. Import a small test
Import 10 rows first. Open them in the CRM and check the name, phone, source and date. Fix the sheet if something is off, then import the rest.
5. Check after import
- Does the lead count match your sheet?
- Are phone numbers complete?
- Does each lead have an owner?
- Are follow-up dates in the future set as reminders?
6. Stop using the old sheet
This is the step most teams skip. Tell the team that from a set date, all new leads and updates go only into the CRM. If two systems run side by side, the old one wins by habit and the new one empties.
Hinglish me padhna ho to dekhein Excel se CRM par kaise jayein.
In Rivo Leads
Rivo Leads exports leads as CSV, and bulk upload from CSV or Excel is a Growth plan feature. Read the import and export page for the details. On the free trial (up to 50 leads) you can add your most active leads by hand.