Almost every business starts tracking customers in Excel or Google Sheets, and for a while that is the right choice: it is free, everyone knows how to use it, and it bends to whatever you need. The problem is that a spreadsheet fails quietly. Nobody gets an alert when a follow-up date passes, when two salespeople call the same customer, or when someone leaves with a copy of your customer list. This guide gives you an honest way to decide. If a spreadsheet is still enough, it shows you how to set one up so it works properly, with formulas we tested. If it is not, it lists the signs, explains what a CRM genuinely changes, and lays out a two-week plan to move without losing data.
The Honest Answer: a Spreadsheet Is a Fine CRM, Up to a Point
A CRM (customer relationship management system) is, at its core, a shared list of customers and deals with a history attached and reminders built in. A well-kept spreadsheet can do the first part. It struggles with the rest. There is no magic number of customers where you must switch; what matters is how many people touch the list, and how much it costs you when a follow-up is missed.
| Your situation | Spreadsheet | CRM |
|---|---|---|
| One person sells, a few new enquiries a week | Usually enough, if set up as below | Optional |
| Two or three people share the same leads | Workable with strict rules, but collisions start | Worth considering |
| Leads arrive daily from several channels (WhatsApp, website, calls, walk-ins) | Leads get typed in late or not at all | Recommended |
| Long sales cycles with many touches per deal | History ends up in someone's phone | Recommended |
| You need to know who changed what, or to limit who sees which customers | Not realistically possible | Needed |
If You Stay on a Spreadsheet, Set It Up Like This
Most spreadsheet CRMs fail because they were never designed: columns get added as needed, dates are typed as text, and "status" contains twenty different spellings. Fifteen minutes of setup fixes most of that. Use one row per deal, and these columns:
| Column | Contents | Rule |
|---|---|---|
| A: Name | Customer or company | One spelling, no nicknames |
| B: Phone as given | Whatever the customer gave you | Format the column as Plain text before typing, or 03001234567 loses its leading zero |
| C and D: Phone, cleaned | Formulas, see below | Never type here |
| E: Deal value | Expected amount, e.g. in PKR | Numbers only, no "Rs" typed in |
| F: Stage | New, Qualified, Proposal, Negotiation, Won, Lost | Dropdown only (Data validation) |
| G: Next follow-up | A real date | Required for every open deal |
| H: Next action | "Send revised quote", "Call after Eid" | A verb, not a status |
| I: Owner | Who is responsible | Exactly one person |
| J: Source | WhatsApp, website, referral, walk-in | Dropdown only |
Then add these formulas. We ran each one in LibreOffice Calc on a sample sheet and checked the results; they use only functions that also exist in Excel and Google Sheets. If your regional settings use a semicolon as the separator, replace the commas with semicolons.
Clean up Pakistani mobile numbers
In C2, strip spaces, dashes and the plus sign:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2," ",""),"-",""),"+","")In D2, turn the result into one international format:
=IF(LEFT(C2,2)="92","+"&C2,IF(LEFT(C2,1)="0","+92"&MID(C2,2,20),C2))On our test sheet, "0300-1234567" and "0300 1234567" both became +923001234567, "+92 321 7654321" became +923217654321 and "92 333 1112223" became +923331112223. The formula assumes Pakistani numbers. For another country, change 92 to that country's code and make the LEFT check match its length, for example LEFT(C2,3)="971" for the UAE, then test it on a few of your own rows, because local formats differ. One number in one format is what makes the duplicate check below work, and it is also the format a WhatsApp click-to-chat link expects, minus the plus sign.
Flag duplicates
=AND(D2<>"",COUNTIF(D:D,D2)>1)Shows TRUE when the same cleaned number appears on more than one row, which is how you catch two salespeople chasing one customer.
Count overdue follow-ups
=COUNTIFS(G:G,"<"&TODAY(),F:F,"<>Won",F:F,"<>Lost")The number of open deals whose follow-up date has passed. Put it at the top of the sheet. If it is not zero, someone has work to do today.
Highlight the overdue rows
Select the data rows, add a conditional formatting rule using a custom formula, and colour the row red:
=AND($G2<>"",$G2<TODAY(),$F2<>"Won",$F2<>"Lost")See the value at each stage
=SUMIFS(E:E,F:F,"Proposal")Total value of deals waiting on a proposal. Repeat with each stage name for a simple pipeline summary.
Finally, add a weekly habit: every Monday, sort by column G and deal with every overdue row. A spreadsheet has no reminders, so this ten-minute review is the reminder.
Keep WhatsApp Conversations Tied to the Sheet
For many businesses in Pakistan, India and the Gulf, the sales conversation happens on WhatsApp while the list lives in a spreadsheet, and the two drift apart within a week. Three habits keep them connected without any new software.
- Use the same stages as WhatsApp labels. The WhatsApp Business app lets you put labels on chats. Create one label per stage (New, Qualified, Proposal) so the phone and the sheet use one vocabulary, and a glance at either tells you where a customer stands.
- Open chats from the sheet, not from memory. WhatsApp click-to-chat links take the full international number without the plus sign, so one more formula turns column D into a link that opens the right chat:
On our test sheet,="https://wa.me/"&SUBSTITUTE(D2,"+","")+923001234567becamehttps://wa.me/923001234567. Opening the conversation from the row reminds you to update the row afterwards. - Write one line after every conversation. Not the whole chat: just the new Next action and Next follow-up date. If the customer said "call me after the 10th", the sheet should say so before you put the phone down.
This works while one or two people handle WhatsApp. Once several staff answer from different phones, the history splits across handsets again, and that is one of the clearest signs below.
Seven Signs You Have Outgrown the Spreadsheet
- The overdue count is never zero. Follow-ups are being missed faster than anyone can catch up, and the formula above proves it every morning.
- The real history lives in phones. The last ten messages with a customer are in one salesperson's WhatsApp, so when that person is on leave, nobody knows what was promised.
- People overwrite each other. Two people edit the same row, or someone sorts one column and scrambles the others.
- There are several copies. "Leads final", "Leads final v2" and one on a laptop, each slightly different.
- You cannot answer basic questions quickly. Which source brought the deals we won last quarter? How long does a deal usually sit at proposal? If answering takes an afternoon, you will stop asking.
- Everyone can see and download everything. Your full customer list, with phone numbers and deal values, is one "Download" click away for anyone with access, including someone about to leave.
- Leads arrive where the sheet is not. Website forms and WhatsApp enquiries depend on someone remembering to copy them across.
One or two of these can be managed with discipline. Three or more, and the spreadsheet is costing you customers you will never hear about.
A spreadsheet stores your customer list. A CRM makes sure somebody actually does something with it, on time.
What a CRM Actually Changes
A CRM is not magic, and it will not fix a sales process nobody follows. What it changes is who has to remember.
| Task | Spreadsheet | CRM |
|---|---|---|
| Follow-up reminders | Someone has to sort and look | Tasks and notifications come to the owner |
| Customer history | A notes cell that grows until nobody reads it | A timeline of calls, emails, meetings and changes |
| Working as a team | Shared file, easy to overwrite | Each deal has an owner; changes are recorded |
| Access control | All or nothing | Roles decide who sees and exports what |
| Reports | Built by hand with formulas | Pipeline, sources and team performance on a dashboard |
| New leads | Typed in from forms and messages | Can be captured directly from forms and email, depending on the system |
Define Your Pipeline Before You Choose Software
The most useful work in any CRM project happens on paper. Write down your stages and, for each one, the event that moves a deal forward. If you cannot say what moves a deal from one stage to the next, the stage names are just decoration.
| Stage | Moves forward when |
|---|---|
| New | You have spoken to the customer, not just received a message |
| Qualified | You know what they need, roughly when, and that they can pay for it |
| Proposal | A written quotation has been sent |
| Negotiation | The customer has responded to the quotation with changes or questions |
| Won / Lost | Payment or a signed order arrives, or the customer says no. Record the reason for every loss. |
Use these same stages in your spreadsheet today. It makes the sheet better now and the move to a CRM easier later.
Moving From Spreadsheet to CRM in Two Weeks
- Days 1 to 3: clean the data. Run the phone clean-up and duplicate formulas above, merge duplicates, fix stage spellings, and delete rows nobody can explain. Importing a messy sheet only moves the mess.
- Day 4: map the fields. List each spreadsheet column next to the CRM field it will fill. Decide what happens to the old notes column; usually it becomes one imported note per customer.
- Day 5: test import 20 rows. Check that phone numbers, dates, amounts and Urdu or Arabic names came through intact before importing everything.
- Days 6 and 7: import everything and set owners. Every open deal needs an owner and a next follow-up date on day one, or the CRM starts with the same problem the sheet had.
- Days 8 to 14: CRM only, sheet read-only. For one week, new leads go only into the CRM and the old sheet is read-only. At the end of the week, archive it.
Questions to Ask Before You Choose a CRM
- Can I export all my data, at any time, in a standard format? Your customer list should never be hostage to a vendor.
- How does it handle WhatsApp? If your customers live on WhatsApp, ask exactly how messages get into the CRM and whether the connection uses WhatsApp's official Business Platform.
- How is it priced as the team grows? Per user, per contact or flat, and what is included at each step.
- Who can see what? Can a salesperson be limited to their own deals, and can exports be restricted?
- Where is the data stored, and how is it backed up?
- What happens after "Won"? The deal becomes an invoice. Check how the CRM connects to your invoicing and accounts.
Where IO Snack Fits
If your team has outgrown the spreadsheet, our CRM solutions are built around your own sales process: contact management with the full interaction history, a visual sales pipeline, AI-powered lead scoring, email integration with open and click tracking, task automation for follow-ups, and reports on sales performance. When a deal is won, IO Snack Accounts handles invoicing and the books, and for a quick one-off invoice, the free invoice generator works in your browser. Not sure which side of the line you are on? Send us a description of how you track customers today and we will tell you honestly whether a spreadsheet will do.
