Your CRM is a spreadsheet. When does that become a problem?
· 4 min read · Dario Gutiesco
The short version
- A spreadsheet is a fine CRM until the same data gets typed twice, enquiries go without follow-up, or only one person can keep it.
- The real cost is not the file. It is the enquiries nobody answered and the decisions made without knowing what sells.
- The fix is small: one place per enquiry, a reminder for every next step, and nothing more than you will actually use.
Contents
Most businesses I work with started tracking clients in a spreadsheet. That is not a mistake. A spreadsheet is free, everyone knows how to use it, and on day one it does the job. I would tell anyone starting out to do the same.
The question is not whether a spreadsheet is good enough. The question is when it stopped being good enough, and whether anyone noticed. In my experience there are four clear signs. If you see one, it is worth a look. If you see two or more, the file is already costing you money.
Sign 1: the same data is typed twice
A new enquiry comes in by email. Someone copies the name and phone number into the spreadsheet. Later the same details go into the quote, then into the invoice, then maybe into a second sheet for a different team.
Every copy is a chance for a typo. Every copy takes time. And when a client changes their email address, you have to remember every place it lives. Usually someone forgets one.
If you find yourself copying the same client details from one place to another, the spreadsheet is no longer your system. It is one of several, and none of them agree.
Sign 2: enquiries with no follow-up
This is the most expensive sign, and the hardest to see. A spreadsheet does not remind anyone of anything. It only holds what someone typed in.
So an enquiry arrives, someone answers it, and then it sits. The person meant to call back on Thursday. Thursday was busy. Nobody sees the row again until weeks later, if at all.
The enquiry was not lost because the team was lazy. It was lost because nothing told them it was waiting. Look at your last month of enquiries. If you cannot say for each one what happened next, some of them went cold without anyone deciding to let them go.
Sign 3: nobody can say what sells
Ask a simple question: which service brought in the most work last quarter? Or: where do your best clients come from?
If the answer takes an afternoon of sorting and filtering, or ends in a guess, the spreadsheet is holding your data without giving you any answers. Decisions about where to spend time and money then get made on gut feeling.
Gut feeling is not always wrong. But it is hard to improve something you cannot see.
Sign 4: the file only works while one person keeps it
Every business has one. The person who built the spreadsheet, knows which column means what, and fixes it when a formula breaks. As long as they are there, it works.
When that person is ill, on holiday or leaves, the file starts to drift. Rows go in half filled. Colours stop meaning anything. Within a few weeks nobody trusts it.
If your client list depends on one person’s memory of how the file works, it is not a system. It is a habit, and habits leave with people.
What to do instead
You do not need a big, expensive system. Most small teams I see need three things, and only three.
First, one place per enquiry. Every enquiry gets one record, from the first message to the signed deal. Client details live there once. The quote and the invoice read from it instead of copying it.
Second, follow-ups that remind you. Every open enquiry has a next step and a date. When the date comes, someone gets a reminder. Nothing depends on remembering.
Third, a simple view of what sells. Where enquiries come from, which ones turn into clients, and which services they buy. Not a dashboard full of charts. Just the few numbers you would actually look at.
Keep it small. The biggest mistake I see is buying a system with every feature and then using only a small part of it. Start with what you need today. Add more only when you miss it.
Move in a calm order. Open enquiries first, then active clients, then history if you need it. Keep the old spreadsheet as a read-only archive until the team trusts the new setup.
To sum up
Your spreadsheet becomes a problem the moment it holds data without telling you what to do with it. If you type things twice, lose track of follow-ups, cannot see what sells, or depend on one person to keep it alive, it is time to move on. The step after a spreadsheet does not have to be big. It just has to remind you, and give you answers.
What to do next
- 1 Open your spreadsheet and count how many places hold the same client details. If it is more than one, write them down.
- 2 Filter for every enquiry from the last month and check which ones got an answer and a next step.
- 3 Write down the one question about your sales you cannot answer from the file today.
- 4 Ask who would keep the file going if its owner were away for two weeks.
Questions
Is a spreadsheet really a bad CRM?
No. For a small number of clients it is often the right start. It becomes a problem when the business grows and the file does not keep up. The signs in this guide tell you when.
Do I need an expensive CRM system to fix this?
Usually not. Most small teams need one place per enquiry, reminders for follow-up and a simple view of what sells. Start with that and add only what you miss.
Can I keep my spreadsheet while I switch?
Yes. Move the open enquiries first, then the active clients. Keep the old file as a read-only archive until you trust the new setup.
I've worked in operations, project management, sales and marketing. That's how I see where a business breaks.
Rather have this built than build it yourself? Get my free audit.
Tell me where your week goes. You get a written Time & Money Map of what can come back.
Get my free audit