Let us start by defending the spreadsheet, because most articles on this topic are written by people who need you to be embarrassed about it. A shared sheet is free, instantly flexible, requires no training, and has no vendor. For a two-person business doing forty jobs a month, it is genuinely the right tool. Switching too early costs you money and time and buys you nothing.
The question is not whether a spreadsheet is a real CRM. It is whether yours has crossed the line where it stops being an asset and starts being a liability. Four signs tell you.
Sign 1: the sheet has stopped being the truth
The test is simple. Pick a customer who called last week and ask two people what was promised. If the answers differ — or if either answer requires checking a text thread — the sheet is no longer the record. It is a summary of the record, and the actual record is distributed across phones.
This is the most important sign and the easiest to rationalise away, because everything still works. It just works because specific people remember things.
Sign 2: nothing in it can act
A spreadsheet is a place where information sits. It cannot text a customer who has gone quiet for four days, remind you that a maintenance client is due, or stop a follow-up because someone replied. Everything the sheet knows is only useful when a human opens it, reads it, and decides to do something.
That is fine at low volume. It becomes the binding constraint the moment the number of things needing follow-through exceeds what one person can hold in their head — which is a much smaller number than most owners think, and it arrives in the busy season.
Sign 3: the history is gone when the person is
When a technician leaves, do their relationships stay? When the owner takes two weeks off, does the business still know what it promised? In a spreadsheet business the honest answer is usually no, and the cost only becomes visible at the worst possible moment.
This is also the sign with the sharpest asymmetry: a CRM that keeps history is a modest monthly cost, and losing five years of context on your best accounts is not recoverable at any price.
Sign 4: you cannot answer basic questions
How many quotes are open right now, and what are they worth? Which customers have not been contacted in a year? What is your close rate by job type? A sheet can be made to answer these, but only by someone who maintains it carefully — and the maintenance is the part that quietly stops during the season when the answers matter.
What actually changes
| Spreadsheet | Unified CRM | |
|---|---|---|
| Cost | Free | A monthly line item |
| Setup | None | Days, not months, if scoped properly |
| Holds the whole relationship | Only what someone types | Calls, texts, quotes, jobs, payments |
| Acts on its own | Never | Follow-ups, reminders, rebooking |
| Survives a departure | Partially | Fully |
| Answers "what is open?" | If maintained | By default |
How to switch without a project
The failure mode of CRM adoption is trying to move everything at once. The version that works is narrow:
- Move active customers and open quotes only. Archive the rest — you can import history later, and you probably will not need to.
- Turn on exactly one automation, the one covering your biggest leak. Usually follow-ups or missed-call text-back.
- Run both systems for two weeks with the sheet as read-only backup. Nobody edits it. If something is missing, that is the bug list.
- Delete the sheet. This step is not optional. Two systems is worse than either one, and the sheet will win by default if you leave it editable.
Common questions
Can you use Excel or Google Sheets as a CRM?
Yes, and for a very small team it is often the right choice — free, flexible, no training. It stops working when the sheet is no longer the single source of truth, when follow-through exceeds what one person can remember, or when losing an employee would mean losing their customer history.
When should a service business switch from a spreadsheet to a CRM?
When two people would give different answers about what was promised to a recent customer, when quotes are going unfollowed, or when you cannot answer "what is open and what is it worth?" without an afternoon of work. Any one of those is enough.
How long does it take to move off a spreadsheet?
Days, if you scope it narrowly: move active customers and open quotes only, turn on one automation, run the sheet as read-only backup for two weeks, then delete it. Attempting to migrate all history at once is the most common reason rollouts stall.
What do you lose by switching?
The main thing is unconstrained flexibility — a CRM has opinions about what a customer, quote, and job are. That constraint is most of the value, but it does mean an odd workflow that lived in a spare column needs a real home.