A course enquiry rarely arrives in a neat, single-channel way. Someone fills in a web form at 11 pm while someone else calls the office when your only admin person is mid-induction with a new cohort. A third person messages a trainer directly on LinkedIn because that's who ran the taster session they attended last year. A fourth picks up a leaflet at an open evening and emails a question three days later, after they've had time to think about it.
Each one needs the same thing: a reply, an answer to their actual question, and a next step, before they lose interest or book with someone else.
For most training and education providers, the tool that ends up holding all of this together is a spreadsheet. Not because anyone sat down and chose it as the right system, but because it was already there, everyone already knew how to use it, and it was good enough to get started with.
Why the spreadsheet is the obvious first choice
It's worth saying plainly: starting with a spreadsheet isn't a mistake. For a training provider running a handful of courses a year, it's a completely reasonable way to keep a list of who's asked about what. You can add a row, note a phone number, put a date next to it. No setup, no cost, no one to convince.
It also fits how a lot of training providers are staffed. There's rarely a dedicated enquiries team. It's an office manager, a course coordinator, sometimes the trainer who happens to be between sessions, all dipping in and out of the same list as time allows. A spreadsheet asks nothing of anyone. Open it, add a row, close it again.
The trouble isn't the spreadsheet itself. It's what happens to enquiry tracking specifically as a training or education business runs more courses, more often, from more places, with more people touching the same list.
Where it starts to break down
A spreadsheet can hold a list. It can't hold a process, and enquiry-to-enrolment is a process with a clock running on it.
Enquiries come in from everywhere
But they don't arrive in the spreadsheet on their own. A phone enquiry has to be typed in by whoever took the call, if they remember to, and if they get five minutes before the next thing. A web form enquiry might land in an inbox that three different people check, so it either gets actioned three times or, more often, everyone assumes someone else has it. A conversation at an open evening gets written on the back of a leaflet, and the leaflet doesn't always make it back to the office. The spreadsheet only ever reflects the enquiries someone had time to write down, which is a smaller number than the enquiries that actually came in.
Course start dates create a deadline that spreadsheets don't track
A retail CRM doesn't have a September intake to fill. A training provider does. An enquiry about a course starting in three weeks needs a faster, more assertive follow-up than one about a rolling-enrolment programme that runs year-round, but a flat list of rows treats them identically. Nothing flags the enquiry sitting quietly in row 340 for a cohort that closes for applications on Friday. If a course is funded, accredited, or tied to a specific intake window, that urgency is invisible to a spreadsheet unless someone happens to be scanning dates manually, which, on a busy week, nobody is.
Waitlists don't suit a row-based list
A popular course fills, and the next five enquiries get logged as "waitlisted" in a status column, then largely forgotten until a space opens up. When it does, whoever's checking the spreadsheet has to remember to look, remember who was first, and remember to reach out before that person books somewhere else. In practice, waitlist management is one of the most common places training providers quietly lose enrolments they'd already half-won.
Running more than one site multiplies the problem
If each site or venue keeps its own version of the tracker, someone eventually has to merge them by hand to get a true picture, and that merge is usually a monthly scramble rather than a daily habit. In the meantime, two sites might be independently chasing the same enquiry, both promising a call this week, both a little embarrassed when the learner mentions the other one already rang. Or, just as often, neither site follows up at all, because each assumes it's the other's enquiry.
Keeping the spreadsheet updated isn't anyone's full-time job
At least not consistently. In a lot of training providers, the same people who log enquiries are also delivering the courses. A spreadsheet that only updates when someone's at a desk means every enquiry that comes in during a delivery day, a site visit, an assessment day, or a half-term just waits. Trainers come back from three days on-site to a backlog of enquiries that are now three days colder than they should be.
Handoffs lose the details that mattered
When a colleague who was managing a batch of enquiries goes on leave, or leaves the role entirely, whatever wasn't written in the notes column goes with them. "Interested, will call back" tells the next person almost nothing. It doesn't say the learner asked specifically about funding options, or that they mentioned a start date that's no longer realistic, or that they'd already spoken to someone else on the team once before.
Nothing surfaces on its own
A spreadsheet doesn't tap you on the shoulder when a follow-up date passes. It doesn't know that an enquiry has gone quiet, or that a waitlisted contact needs contacting now that a seat's free. Someone has to remember to scroll through and check, and in a genuinely busy week, that review is the first thing to slip.
What it actually costs
The cost isn't usually one dramatic lost enrolment. It's smaller and steadier than that: a handful of enquiries every month that get a slower reply than they should, a waitlist that isn't really being managed, a cohort that fills three seats short of capacity because two interested people never heard back and one waitlisted contact was never told a space opened up. None of it shows up as a single visible failure. It just shows up as revenue that never quite arrives, and nobody can point to exactly why.
It also creates a specific kind of frustration for the people doing the chasing. Staff know, roughly, that enquiries are slipping through. They just can't see where, because the spreadsheet doesn't distinguish between "nobody's looked at this yet" and "we're three follow-ups deep and waiting to hear back." Everything looks like a row until someone opens it.
And it has a longer tail than most training providers account for. If enquiry records live in a spreadsheet that gets archived and forgotten after a course runs, there's no easy way to go back and see who enquired about a course six months ago that's now running again. That's a real opportunity, quietly lost, and one we cover in more depth in turn past learners into repeat business.
How a CRM changes things
This is where a CRM earns its keep, specifically for the enquiry stage rather than in general terms. It's also a different question from whether you need a full training management platform on top of that. If you're weighing that too, read more about why you might not need a training management platform, and Capsule vs a training management system walks through the two head-to-head.
A sales pipeline built around your enquiry stages, rather than a generic template, gives every enquiry a visible status: new, following up, waitlisted, enrolled, or gone quiet. Tag each contact with the course or programme they're asking about, and "everyone interested in the January cohort" becomes a filter, not a manual search through hundreds of rows. The same applies to a waitlist: instead of a status column nobody checks, waitlisted contacts sit in their own view, ready to be worked through the moment a space opens up.
Tasks and calendar reminders mean a follow-up date doesn't depend on someone remembering to check a column. If an enquiry hasn't moved in five days, it doesn't quietly age out of view; it surfaces, with a task assigned to whoever owns it.
The Capsule mobile app means an enquiry logged during a site visit or between sessions is visible to the whole team immediately, not typed up later from memory if it's typed up at all. A trainer coming back from three days on-site isn't the only person who can see what came in while they were out.
Notes stay with the contact rather than fading into a single, terse cell. "Interested, will call back" becomes a real record: what they asked about, what was promised, what's still outstanding, visible to whoever picks up the enquiry next, whether that's the original point of contact or someone covering while they're away.
And because it's one shared system rather than a document that has to be merged, a training provider running courses from more than one site sees every enquiry in the same place, whoever picked it up and wherever it came from. No duplicate chasing, no enquiries that fall between two sites because each assumed the other had it. That specific problem, multi-site enquiry and enrolment tracking, is worth its own read: see keeping track of enquiries and enrolments across multiple sites.
None of this means the spreadsheet was the wrong place to start. It means it's reached the point where the manual version has done its job, and something built for a process with a deadline attached, and a waitlist, and more than one person touching it, is the more practical next step.
Not ready to move off spreadsheets yet?
If a full CRM is a bigger step than you want to take right now, start smaller. The No-Missed-Enquiry Checklist is a free, practical way to bring some structure to what you're already doing manually: what to log the moment an enquiry lands, what to do within 24 hours, and a simple tracker template you can print or turn into a shared spreadsheet. It's honest about where that approach runs out, too.
For the broader case for making the switch, beyond enquiry tracking specifically, our guide to spreadsheets vs CRM covers the wider ground: relationship management, security and compliance, and what changes across sales and reporting generally.
When you're ready to see what a CRM built around your enquiry-to-enrolment process actually looks like, try Capsule free for 14 days. No credit card required.
