The spreadsheet holds until things go well
A spreadsheet is an excellent calculator and a poor shared place. The four ways it breaks between five clients and twenty, and how to tell it has already happened.
With five clients the spreadsheet works. Not "works up to a point": it works well. One tab per person, you know them by heart, and in thirty seconds you know where everyone is. Anyone telling you that five clients already call for software is selling you something.
The trouble is that it does not break all at once. There is no Monday when the file stops opening. It breaks at the edges, and by the time you notice you have spent months doing by hand a job the tool no longer holds.
Here are the four breaks, in the order they turn up.
1. The version your client opens is not yours
You sent the plan on 3 March. On the 12th you swapped the flat bench for the incline because their shoulder was playing up, and you told them in a message.
From that day there are two plans: yours, which is correct, and theirs, which is the March one plus a message somebody has to go and find. On Thursday they ask you about an exercise you removed three weeks ago and for a second you think they are not listening. They are. Their copy says something else.
A document stops being yours the moment you send it. What you call "keeping the plan up to date" is keeping as many copies up to date as you have clients, and that count only goes up.
2. There is no history: there is your memory
The weight is in a conversation from March. The photos are in your camera roll. The measurements are in a note that starts with a name. And the spreadsheet has the last column you got round to filling in.
That is how Thursday's check-in ends up being rebuilt on Wednesday at eleven. The cost is not the time it takes: it is that the conversation you were going to have about their progress becomes a conversation about whatever you manage to remember.
None of this is the spreadsheet's fault. A spreadsheet keeps what you type into it, and you do not type in the photos.
3. There is no way to look at everyone at once
One tab per client is a decision you pay for later. It is the perfect way to work with one person and the worst way to ask anything about all of them.
"Who has slowed down this month?" Answering that means opening fifteen tabs and comparing them by eye. Nobody does that on a real Monday with a seven o'clock session already booked.
And because the question cannot be answered, it stops being asked. It does not go away, though. You replace it with an impression, and the impression always arrives late.
4. What your client does never comes back
This is the serious one, and the last to show. The spreadsheet holds what you sent. What they did is not in there: not the sets they finished, not the weight they moved, not the days they never turned up.
You can ask them to write it down. Some do, for three weeks. You end up with half the information you need, and it is the half you already knew, because you wrote it.
Everything else on this list is friction. This one is running a follow-up business without any follow-up data.
How to tell it has already happened
- You have re-sent the same plan to the same client twice this month.
- Before a check-in, you go looking for data in three different places.
- You could not say, without checking, who has been slipping for two weeks.
- You have a payments tab that never quite matches what you have been paid.
- You have stopped updating someone's sheet because you "keep that one in your head".
One of those is normal. Three, and the spreadsheet has stopped being your tool and started being your debt.
What changing tools will not fix
Worth saying, because almost nobody says it. Changing tools will not bring you clients. It does not prevent people leaving: it stops you being the last to know. And migrating takes work (anyone telling you otherwise is, again, selling you something), so you start with two or three people, not the whole roster.
And if you have two or three clients, change nothing. The spreadsheet is more than enough. This starts to hurt somewhere past ten or twelve, and not before.
The problem is not Excel
A spreadsheet is not a bad tool. It is an excellent calculator. What you are doing is using it as a database shared with twenty people who cannot see it, which is what it was never built for.
Of the four breaks, the fourth is the expensive one, because it decides whether you hear about someone leaving in week two or in week six. That one has an article of its own: nobody quits on the day they quit.