School CRM vs Excel: When a Spreadsheet Stops Being Enough

Most institutes start with a spreadsheet, and there is nothing wrong with that. Excel is free, universally understood and infinitely flexible. For a small centre it is genuinely the correct tool.

This is about where that stops being true, and how to tell.

What Excel does well

Credit where it is due:

• Everyone already knows how to use it
• You can restructure it in seconds when your process changes
• No subscription, no vendor, no migration
• Filtering and sorting are perfectly adequate for a few hundred rows

If you handle twenty enquiries a month, one person manages all of them, and that person can tell you from memory who has not been called back — stop reading. The spreadsheet is fine. Buying software would be solving a problem you do not have.

The four things it cannot do

These are structural limits rather than skill gaps. No amount of spreadsheet expertise resolves them.

1. It cannot act

A spreadsheet records what you did. It cannot send a follow-up message on day three, alert a parent when a student is marked absent, or call an enquiry that arrived at 9 PM. Every action still requires a person to remember — and the busiest fortnight of your admission season is exactly when remembering fails.

This is the fundamental one. Everything else follows from it.

2. It cannot be shared properly

Two counsellors editing the same file produces conflicting versions. A shared cloud sheet helps, but there is still no record of who changed what, no per-person permissions, and no way to stop someone accidentally overwriting a column. A counsellor who leaves takes their WhatsApp history with them regardless, because that was never in the sheet.

3. It has no memory of the conversation

The sheet says "called, interested". It does not contain what the parent actually asked, what was promised, or which fee concern came up twice. That context sits in one person's head and one person's phone, which makes handover impossible and staff turnover expensive.

4. It degrades

Duplicates accumulate because there is no detection at entry. Stage values drift as different people type "Visited", "visited" and "campus visit done". Formulas break when someone inserts a row. By month four, reporting requires cleaning the data first — and the cleaning is what stops people reporting at all.

The specific failures, in order

In roughly the order institutes hit them:

Symptom	Underlying cause
Same parent called by two counsellors	No duplicate detection at entry
Enquiries never contacted a second time	Nothing acts without a human trigger
"Which source worked?" cannot be answered	Attribution lost between enquiry and admission
Counsellor leaves, relationships leave	Conversation history on a personal phone
Fee reminders take a week per month	No automated reminder with a payment link
Student drops out with no warning	Attendance, exams and fees in separate sheets

The honest threshold

Not a formula, but a reasonable rule of thumb. Move when two or more of these are true:

• More than roughly 50 enquiries a month
• More than one person handling enquiries
• Enquiries arriving on three or more channels
• You have lost an enquiry you know you should have won, because of a missed follow-up
• You cannot answer a source-attribution question without reconstructing it

One of these alone is survivable. Two compound.

What you give up

Worth stating, because vendors rarely do:

• Flexibility. A CRM has opinions about how a pipeline works. A spreadsheet has none. If your process is genuinely unusual, that constraint will chafe.
• Cost. Excel is free; a CRM is not. At ₹999 a month the comparison is one recovered admission per year, but it is still a real line item.
• A migration. Importing and cleaning your existing list takes an afternoon, and someone has to do it.

Against that, the thing you gain is not really "features" — it is that follow-up stops depending on anyone remembering. For most institutes that single change is the entire return.

If you do move

Keep the spreadsheet for a month in parallel. Import rather than retype. Insist on unrestricted export from whatever you buy, so the decision stays reversible — if you cannot get your data out without a support ticket, you do not own it.

SCRMAI imports directly from CSV and Excel with duplicate detection on the way in, and exports to CSV and PDF on every entity at any time. The lead management page covers the import path, and there is a 14-day free trial if you want to run it alongside your sheet before committing.