Everyone keeps records of their students. The disagreement is only about where, and the answer changes as the roster grows — usually about two months after it should have.
What "keeping records" actually means
It is four separate jobs that get discussed as one: who your students are and what they pay, when the lessons are, what was covered, and what money has moved. A tool can be excellent at one and useless at the others.
Most frustration with a chosen tool comes from this: the spreadsheet is fine at rates and hopeless at reminders, and the calendar is the reverse, so people end up maintaining both and reconciling them by hand.
- Who: contact details, the rate, the parent, the level.
- When: the schedule, reschedules, and what actually happened.
- What: covered and set, per lesson.
- Money: paid, owed, and packages outstanding.
Option 1. Spreadsheets
Excel and Google Sheets are the default and are genuinely good: free, flexible, and shaped exactly how you want. For under about seven students they are hard to beat.
They fail in one specific way, and it is not capability — it is that a spreadsheet never tells you anything. It cannot remind a student, flag an overdue balance or notice that a package ran out. Every insight has to be gone and looked for, and during a busy term nobody goes and looks.
- Good: free, flexible, exportable, familiar.
- Bad: no reminders, no alerts, painful on a phone, easy to corrupt with one mis-drag.
Option 2. Notes and messengers
Notes apps and chat threads are where tutoring records actually live for a surprising number of people, because that is where the conversation already is.
The cost is retrieval. Information in a chat is perfectly recorded and effectively unfindable six months later, which is exactly the horizon over which student records become valuable.
- Good: zero setup, and the record is next to the conversation.
- Bad: unsearchable in practice, no structure, no totals, nothing you can act on in aggregate.
Option 3. General organisers and CRMs
Notion, Trello and general CRMs can be shaped into something good, and for a certain kind of person that is a pleasure rather than a chore.
Two things go wrong at scale. The structure you built is maintained by you, so it decays exactly when you are busiest; and the domain concepts — a package balance, a late-cancellation rule, a parent paying for two children — have to be re-implemented by hand, usually incompletely.
- Good: flexible, and satisfying if you enjoy building systems.
- Bad: the maintenance is yours, and it decays during a busy term.
Option 4. A tutor-specific CRM
A specialised tool already knows what a lesson, a package and a rate are, so nothing has to be modelled. The trade is the opposite of an organiser’s: less freedom, much less maintenance.
The part that changes the day-to-day is not the record-keeping at all — it is that the system can act. Reminders go out, overdue balances surface, packages announce that they are running out. That is the whole difference between a record and a system.
- Good: nothing to build, it notices things, works on a phone.
- Bad: someone else’s structure, and a monthly cost once you are past the free tier.
Side by side
The same four jobs, across the four approaches.
| Spreadsheet | Notes/chat | Organiser | Tutor CRM | |
|---|---|---|---|---|
| Students and rates | Good | Poor | Good | Good |
| Schedule and reminders | None | None | Manual | Automatic |
| Lesson record | Adequate | Scattered | Good | Good |
| Payments and debts | Manual | None | Manual | Automatic |
| Effort to maintain | Medium | Low then hopeless | High | Low |
- Spreadsheet
- Good
- Notes/chat
- Poor
- Organiser
- Good
- Tutor CRM
- Good
- Spreadsheet
- None
- Notes/chat
- None
- Organiser
- Manual
- Tutor CRM
- Automatic
- Spreadsheet
- Adequate
- Notes/chat
- Scattered
- Organiser
- Good
- Tutor CRM
- Good
- Spreadsheet
- Manual
- Notes/chat
- None
- Organiser
- Manual
- Tutor CRM
- Automatic
- Spreadsheet
- Medium
- Notes/chat
- Low then hopeless
- Organiser
- High
- Tutor CRM
- Low
Why a CRM wins past five students
Not because it holds more. Because the work of keeping a spreadsheet true grows with every student while the work of keeping a system true does not — the system derives most of it from things you were doing anyway.
The crossover is around five to seven for most tutors, and it is visible from the outside: it is the point at which you start double-checking your own records before answering a parent.
When a spreadsheet is still fine
Three students, stable times, everyone pays after each lesson. Nothing here is worth changing, and a tutor in that position who buys software is buying a project rather than a solution.
It stops being fine at the first mistake in front of a client — not at a number.
Moving off a spreadsheet without pain
Do not migrate history. Add your current students with their rates and their regular slots — twenty minutes for a full roster — and keep the old sheet read-only for anything you need to look up.
Run both for two weeks, then stop opening the sheet. Tutors who try to import three years of lessons first mostly abandon the migration halfway through and keep the spreadsheet, which is the worst of the available outcomes.
Frequently asked
How should a tutor keep records when they only have a few students?
A spreadsheet, or even a notebook. At three students the overhead of anything more structured exceeds the benefit, and that is fine.
Excel or a CRM — which is better for a tutor?
Excel until about five to seven students, then a CRM. The difference is not storage, it is that a spreadsheet cannot remind, flag or notice anything.
Can I keep a student database for free?
Yes. A spreadsheet costs nothing, and most specialised tools have a free tier — Tutorio’s covers up to three active students without a card.
What data should I keep about a student?
The rate, the regular slot, how to reach whoever pays, and one line per lesson about what was covered. Everything else is optional and most of it you will not use.
How do I move students from a spreadsheet?
By hand, current students only, in one sitting. Importing years of history is the reason most migrations stall.
Is it safe to keep student data online?
It is generally safer than a laptop that is not backed up. What matters is that you can export your data, and that you are not keeping more personal information than the teaching actually requires.