It’s the start of a new term. The clubs coordinator opens a spreadsheet that hasn’t been touched since July, tries to remember which version is current, and starts typing names into rows. By Thursday, three parents have emailed asking when football starts. By Friday, one of the columns has been accidentally deleted.
Sound familiar?
Spreadsheets have been the default tool for managing after-school clubs in UK schools for as long as most PE staff can remember. And for a long time, they were fine. But the way clubs are managed has changed — more clubs, more sessions, more parents expecting to book online, more reporting requirements — and the spreadsheet hasn’t changed with it.
When spreadsheets still work
It’s worth being honest about this. Spreadsheets are not universally bad for clubs management. In some situations they’re perfectly adequate:
- A small school running three or four clubs with straightforward sign-up lists
- Clubs with no waiting lists, no booking windows and no online communication
- A single administrator who owns the whole process and doesn’t need to share it
If that describes your school, a spreadsheet probably works well enough. The friction is low enough that the tool doesn’t get in the way.
The problems start when any of those conditions change.
Where it starts to break down
Waiting lists
Managing a waiting list in a spreadsheet means manually tracking who’s on it, in what order, when a place becomes available, whether you’ve contacted the next person, and whether they responded. Every one of those steps is manual, and any one of them can go wrong. A parent who was third on the list gets missed. Someone moves up without being told. The list gets out of sync with the actual club membership.
Booking windows
When booking opens for a new term, the question is: how do parents actually book? If the answer is “they email us,” someone has to process every email individually. If the answer is “they fill in a form,” someone has to pull responses out of a form tool and paste them into the spreadsheet. Either way, the spreadsheet is a destination that requires human effort to update.
Communication
When a club session is cancelled, or the venue changes, or booking is about to close — how does that information get to parents? If it comes from a spreadsheet, the answer is: it doesn’t. Someone has to copy email addresses into a message, write the message, and send it. Every time. And that someone is usually whoever happens to be available.
Attendance
Tracking who actually attended which session — as opposed to who was signed up — is where spreadsheets start to feel genuinely inadequate. The data exists in theory, but pulling it into a usable report for a head teacher, a governor, or an Ofsted inspection takes significant time. Filtering by year group, by SEND status, by how many sessions a student attended — these are all possible in a spreadsheet, but they require someone who knows how to do them.
Multiple people, multiple versions
The moment more than one person needs to update the spreadsheet, version control becomes a problem. Which file is current? Who has edit access? What happens when two people update it at the same time? Google Sheets helps with this, but doesn’t solve the underlying issue that the data still needs to be manually maintained.
What “good enough” actually costs
The honest reason most schools stick with spreadsheets isn’t that they’re the best tool — it’s that switching feels like a lot of effort for something that’s just about managing clubs. But it’s worth thinking about what “good enough” actually costs in staff time.
A busy secondary with fifteen clubs running across five days might spend three to four hours a week on clubs admin during peak periods — processing bookings, updating lists, sending communications, chasing responses, pulling reports. Over a thirty-eight week year, that’s potentially a hundred and fifty hours of staff time. At a teaching assistant rate, that’s a meaningful number. At a teacher rate, it’s significant.
The argument for staying with spreadsheets is usually “we know how it works.” The argument against is that what you know how to do isn’t necessarily the most efficient way to do it.
What a purpose-built system actually changes
The difference isn’t just that the software is faster at the same tasks. It’s that some tasks stop existing entirely.
Parents book directly through the system — no emails to process, no forms to transfer. Waiting lists manage themselves — when a place opens, the next person is notified automatically. When a session is cancelled, parents find out without anyone having to manually send a message. Attendance is recorded per session and available as a report whenever it’s needed.
The administrator’s job shifts from managing data to managing exceptions. Instead of processing fifty booking emails, they’re handling the three cases where something unusual happened.
“I used to spend most of Monday morning on clubs admin. Now I check in once, deal with anything that needs a decision, and that’s it.” — School administrator, independent preparatory school
The transition question
The most common objection to moving away from spreadsheets is the transition itself. Migrating data, getting parents to use a new system, training staff — it all sounds like a project nobody has time for.
In practice, the transition is usually shorter than expected. Most schools that switch describe the first term as the difficult one — old habits, occasional confusion, a few parents who take longer to adapt. By the second term, the new system is normal and the spreadsheet is forgotten.
The question worth asking isn’t “is the transition worth it?” — it’s “what does staying with the current system cost us every term?”
A practical starting point
If you’re considering moving away from spreadsheets, the lowest-risk approach is to start with one area rather than switching everything at once. Online booking is usually the highest-impact change — it removes the most manual work immediately and gives parents something tangible to interact with. Everything else (waiting lists, attendance, communications) can follow once the booking workflow is established.
Most schools find that once one part of clubs management is running on a proper system, the case for migrating the rest makes itself.