Skip to content
Filari
Services Pricing Portfolio About
Chat on WhatsApp
Filari Blog · How-To

How to Manage Coaching Institute Enquiries Without Excel and WhatsApp Chaos

Most coaching institutes manage enquiries across an Excel sheet, a few personal WhatsApp numbers, a reception register and someone's memory. It works until admission season, when enquiries arrive faster than anyone can log them. This guide shows how to manage coaching institute enquiries in one place: one list, one owner per enquiry, clear stages and follow-ups that do not depend on memory.

Take the 2-Minute Audit See the 6-Step System
By Filari Team 10 min read
In this article
  1. 01The Problem
  2. 02Why It Breaks
  3. 03One Day, Two Ways
  4. 04The Six Steps
  5. 05Lead Stages
  6. 06WhatsApp
  7. 07Moving Off Excel
  8. 08Enquiry Audit
  9. 09What to Track
  10. FAQ

01 — The Problem

Six Signs Your Coaching Enquiry Management Has Broken Down

None of these feel serious on a quiet day. In admission season they add up to families who enquired, waited, and joined another institute.

  • Leads live on personal phones

    Chats sit with whichever counsellor the parent messaged.

  • Same family, three rows

    Duplicates mean two calls and two different answers.

  • No next follow-up date

    Calls happen when someone remembers.

  • No clear owner

    Everyone assumes someone else called back.

  • Night enquiries wait till morning

    By then the parent has asked elsewhere.

  • No idea which ads work

    The source column is blank or guessed.

02 — Why It Breaks

Excel and WhatsApp Were Never Built for Follow-Ups

  • No reminders

    A spreadsheet will not tell a counsellor who to call today.

  • Data sits with people, not the institute

    When a counsellor leaves, their WhatsApp chats leave too.

  • Several editors, no rules

    Shared sheets get overwritten, sorted wrongly and duplicated.

  • Every channel is separate

    Forms, calls, DMs and walk-ins each need copying by hand.

03 — Simulation

One Admission-Season Day, Two Ways

Eight enquiries reach one institute in a single day. Switch between the two setups to see what usually happens to each. The day and the outcomes are illustrative.

Day complete

  1. 9:10 amWebsite form: Class 11 JEE

    Goes to an email inbox that is checked in the afternoon.

    Late

  2. 10:05 amWhatsApp to the owner's personal number

    Owner forwards a screenshot to a counsellor. It never reaches the sheet.

    Lost

  3. 11:30 amPhone call about NEET batches

    Noted on paper, typed into Excel at night.

    Late

  4. 1:15 pmInstagram DM after a reel

    Seen by whoever runs the page. No one replies.

    Lost

  5. 3:40 pmSame parent messages again on another number

    A second counsellor calls. The parent hears two different fee figures.

    Duplicate

  6. 5:20 pmWalk-in at reception

    Written in the visitor register.

    Late

  7. 8:45 pmWhatsApp after office hours

    Seen next morning. The parent has already visited another institute.

    Lost

  8. Next dayMorning follow-ups

    The sheet has many rows and no dates. Calls go to whoever is remembered.

    Late
Handled on time
0
Late or duplicated
5
Lost
3

Where else enquiries leak Why Coaching Institute Websites Lose Enquiries Without Realising It

04 — The System

How to Manage Coaching Institute Enquiries in Six Steps

These six steps work whether you use a coaching CRM, a custom system or, for a small institute, a well-run shared sheet. The software makes them automatic; the steps are what matter.

Step 01

Capture every channel

Route website forms, WhatsApp, calls, social DMs and walk-ins into one list. No enquiry should live only in a phone, an inbox or a register.

Done when

A new enquiry from any channel appears in the list without anyone copying it.

Cycling through the steps. Tap one to stop and read it.

05 — Lead Stages

Lead Follow-Up for Coaching Institutes: Stages and Time Limits

Every enquiry should sit in exactly one stage, with a next action and a deadline. The stages and time limits below are an example to start from. Set your own to match your counselling process.

Example enquiry stages for a coaching institute: what each stage means, the next action and an example time limit
Stage Means Next action Example limit
New Enquiry received, not contacted First call or WhatsApp reply Same day
Contacted Spoke once, interested Send course details, offer a demo 2 days
Demo booked Demo date confirmed Reminder the day before Demo date
Demo attended Attended the demo Counselling call, share fees 1 day
Fee discussion Considering fees or instalments Answer questions, follow up 3 days
Admitted Fee paid Hand over to the admissions office —
Lost Not joining this season Record the reason —

Always record a reason when a lead is marked lost: fees, distance, batch timing, joined elsewhere or no response. After one season, those reasons tell you more than any survey.

06 — WhatsApp

WhatsApp Enquiry Management for Coaching: Keep It, Connect It

Parents will keep messaging on WhatsApp, so moving them off it is not the goal. The goal is that every chat lands on the institute's number and in the institute's enquiry record.

Personal WhatsApp

  • Chats sit on each counsellor's own phone
  • No link to the enquiry record
  • Owner cannot see what was promised
  • History leaves when the counsellor does

Institute number, connected

  • One business number for all enquiries
  • Each chat creates or updates a lead
  • Several counsellors reply from one inbox
  • Approved templates for reminders and fee follow-ups

To see a connected setup working end to end, try the WhatsApp + CRM admissions demo.

07 — Moving Off Excel

A Four-Week Plan to Leave the Spreadsheet Behind

Switching in the middle of admission season is risky. If you can, start a few weeks before it. This is an example plan; a larger institute may need longer.

  1. Week 1

    Clean the sheet

    One row per family, one phone format, a stage and owner for every row. Delete true duplicates.

  2. Week 2

    Connect the channels

    Website form, institute WhatsApp number and call logging go straight into the new system. Import the cleaned sheet.

  3. Week 3

    Train and run in parallel

    Counsellors work from the new list daily. The sheet becomes read-only.

  4. Week 4

    Retire the sheet

    Stop adding rows to Excel. Review first-response time and overdue follow-ups together.

08 — Enquiry Audit

How Organised Are Your Enquiries Today?

Eight yes-or-no questions. Answer for how things work in a busy week, not a quiet one.

  1. Every enquiry, from every channel, ends up in one list.
  2. Enquiries come to an institute number, not staff personal phones.
  3. Each enquiry has one named owner.
  4. New enquiries get a first reply within an hour in working time.
  5. Every open enquiry has a next follow-up date.
  6. Repeat enquiries from the same family are merged.
  7. You can see last season's admissions by source.
  8. If a counsellor leaves, their leads and chats stay with the institute.

Your enquiry score

25

Chaotic

Fix first

  • Route every channel into one list; start with WhatsApp and website forms.
  • Move enquiry WhatsApp to an institute business number.
  • Set a first-response target and an after-hours auto-reply.

Score = number of "Yes" answers ÷ 8 × 100. 0–37 chaotic, 38–74 partly organised, 75–100 organised.

09 — What to Track

Three Numbers to Check Every Monday

  • First-response time

    How long new enquiries wait for the first reply, in working hours and after hours.

  • Overdue follow-ups

    Open enquiries past their follow-up date, by counsellor. This number should be close to zero.

  • Admissions by source

    Enquiries and admissions for each channel and campaign, so you spend where families come from.

Key takeaway

Enquiries are managed well when every one has a single record, a named owner and a next follow-up date. Get those three right and the tool becomes a detail.

Choosing a tool next? Read custom CRM vs SaaS CRM, see what drives coaching CRM cost, or check how a CRM differs from an LMS and ERP in CRM vs LMS vs ERP for coaching institutes.

FAQ

Frequently Asked Questions

Can a small coaching institute manage enquiries in Excel?

It can work at low volume if the sheet is shared, has one row per family, a named owner, a stage and a next follow-up date, and someone reviews it daily. It usually breaks when enquiries arrive on several channels at once or several counsellors edit it.

What is the best way to track coaching enquiries from WhatsApp?

Use an institute business number instead of personal phones, and connect it to your enquiry system so each chat creates or updates a lead record. That keeps the chat history with the institute and puts WhatsApp leads in the same list as every other channel.

How quickly should a coaching institute reply to an enquiry?

As quickly as you reliably can. Set a first-response target for working hours that your team can meet every day, and use an automatic reply for nights and holidays so no parent waits without hearing back.

What should a coaching CRM do for enquiries?

At minimum: capture leads from every channel, merge duplicates, assign an owner, track stages, remind counsellors of follow-ups, and report admissions by source. WhatsApp integration and after-hours replies are useful additions.

How do we move old enquiries out of Excel?

Clean the sheet first: one row per family, consistent phone number format, and a stage for each row. Import it into the new system, assign owners, and set a follow-up date for every open lead. Then stop adding new rows to Excel.

Do we need parents' consent to store enquiry data?

Yes, in most cases. Under the DPDP Act, you may process personal data only with consent or for certain legitimate uses, and you need verifiable consent from a parent or guardian before processing a child's (under-18) data. From May 2027 the DPDP Rules, 2025 also require a clear notice explaining what you collect and why. Keep the data secure and delete it when it is no longer needed.

Move Your Enquiries Out of Excel Before the Next Season

Filari sets up one enquiry system for your institute: website, WhatsApp, calls and walk-ins in one list, with stages, owners and follow-up reminders your counsellors will actually use.

See the WhatsApp + CRM Demo
All articles

Keep reading

More on this topic

All articles
Admissions & Enquiries

Your Coaching Institute May Be Losing Admissions Before a Student Even Calls You

Why the gap between an enquiry and a response costs coaching institutes admissions, and how a connected enquiry pipeline and follow-up close it.

15 min read Read