Nearly every sales list starts as a sheet, and it should. A sheet costs nothing, everyone knows how to use it, and on the first day it does the job. The trouble comes slowly. A column is added for remarks, then another for the second remark, and one morning a buyer rings about a quote that nobody can find.
What a sheet does well
- Holds a list of names, numbers and amounts that one person maintains.
- Sorts and filters quickly, and totals a column with no setup.
- Needs no training and no new subscription.
- Bends to any layout you like, today, without asking anyone.
For a new business, or an owner who sells alone, those are real strengths. Excel and Google Sheets are not the problem. Using them as a team's shared memory is.
Where it breaks
No reminders
A sheet waits to be opened. It will not tell a salesperson that three follow-ups fell due this morning. The date sits in a cell, and somebody has to go looking for it.
No history
A cell holds one value. When the status changes from "quoted" to "negotiating", the old value is gone, along with when it changed and who changed it. Notes pile up in one long remarks cell that nobody reads to the end.
No ownership
Anyone with the file can edit any row. Two people call the same lead, or nobody does, each assuming it belonged to the other. And once the file has been forwarded on WhatsApp there are several versions, each a little different.
CRM vs Excel, side by side
| Job | Excel or Google Sheets | CRM |
|---|---|---|
| Storing contacts | Good, until duplicates creep in | One record per customer |
| Follow-up dates | A column someone must check | A daily list and a reminder for each person |
| Conversation history | A remarks cell, overwritten or endless | Dated notes, calls and quotes in order |
| Who is responsible | Whoever last opened the file | A named owner on every lead |
| Quotations | Made separately and saved in folders | Built from the price list and kept on the lead |
| Reports | Built by hand each time | Leads by source and by stage, ready to open |
| Access | All of the file or none of it | Each person sees their own leads; managers see all |
| Setup | None | Stages to agree, data to import, people to train |
Five questions that settle it
- Do more than two people add or update leads?
- Has a follow-up been missed lately because nobody was reminded?
- When a customer calls, do you struggle to find what was last quoted?
- Would part of your pipeline disappear if one salesperson left tomorrow?
- Do you have to count by hand to learn where this month's enquiries came from?
Three or more answers of yes, and the sheet is costing you sales you cannot see. One or two, and tidying the sheet is the cheaper fix.
When to stay on the sheet
Stay if one person owns the list, the leads are few, and repeat customers simply phone you. Stay if your sales happen over the counter and there is nothing to follow up. A CRM that nobody updates is worse than a sheet one person keeps well, because it looks complete and is not.
A half-step that helps: one shared online sheet instead of copies, a fixed list of statuses, and a column for the next follow-up date that someone sorts every morning. If that discipline holds, you may not need more for a while.
How to move from a sheet to a CRM
Freeze the columns
Decide which columns matter and stop adding new ones.
Clean the list
Merge duplicates, put phone numbers in one format, and mark each row as live, won, lost or dead.
Agree stages and owners
A short set of stages, and one named person for every live lead.
Import what is current
Bring in live leads and existing customers. Leave dead rows in the old file as an archive.
Close the sheet
Make it read-only on the day the CRM starts, so there is one place to look.
Operix builds CRM software with a pipeline, follow-up reminders and quotations from your price list. For Siratim we built a CRM and ERP that hold a bottled water company's customers, orders and deliveries. If your team sells mostly through chats, read CRM for sales teams who sell on WhatsApp. If the sheets in question hold stock and invoices rather than leads, ERP versus Excel is the guide you want. To see your own list inside a pipeline, book a demo.
Questions people ask
Can I use Excel as a CRM?
Yes, for one person and a short list. It stores contacts well. It cannot remind you, keep a dated history or assign leads to people.
Is Google Sheets better than Excel for tracking leads?
A shared online sheet solves the problem of many copies, because everyone edits the same file. It still has no reminders, no history per lead and no real ownership.
When should I switch from Excel to a CRM?
When several people share the leads and follow-ups start slipping. If you answer yes to three of the five questions above, it is time.
Will I lose my data when I move?
Not if the sheet is cleaned first. Contacts and live leads are imported, and the old file is kept read-only as an archive.
Can a CRM connect to our ERP?
Yes. A won deal can become a sales order in the ERP without retyping, and customer balances can be shown inside the CRM.
