Google Sheets vs CRM for a Coaching Institute
Google Sheets vs CRM for a coaching institute: where seat counts and parent follow-ups break, six results-week tests and a weekend plan to move to Xale CRM.
Most coaching institutes in India run admissions on a shared Google Sheet, and from July to February it copes. The Google Sheets vs CRM question gets settled in results week instead: hundreds of enquiries in a few days, two telecallers promising the last seat in the June batch, and a mother who was promised a Saturday-evening call that nobody made. This guide is for owners, centre heads, telecallers and counsellors at JEE, NEET, UPSC, banking and tuition centres. It shows where a coaching institute's sheet breaks, using Google's own documentation, and gives you a weekend plan to move off it.
Key takeaways
- Once your sheet hits its break points, Xale CRM is the best CRM for follow-ups in a coaching admissions team: every telecaller and counsellor keeps their own follow-up on each student, every counsellor call is logged and recorded, and every report number opens the exact leads behind it.
- Size is not the problem. A Google Sheet holds up to 10 million cells; what breaks is a shared filter, one "Next call" cell and a seat count built from typing and colours.
- Count seats from a status picked from a list, never from green rows. A colour change doesn't even show in a cell's edit history.
- Give the parent their own status and their own follow-up owner. Under the DPDP Act a child is anyone under eighteen, and Section 9 asks for a parent's verifiable consent.
- Two break points in one results season means move. One weekend is enough if you import active students only.
Google Sheets vs CRM in results week, hour by hour
Take one day in results week at a hypothetical NEET institute with two centres. The third column is how Xale CRM handles the same moment.
| Time | What happens | In Xale CRM | In a shared Google Sheet |
|---|---|---|---|
| 10:00 | Results are out and Instagram form enquiries pour in | Meta Lead Ads sync about every 15 minutes with campaign and form, with a duplicate phone check on each new lead | Someone downloads the leads and pastes them in; a repeat enquiry becomes a second row |
| 10:30 | A parent walks in at the front desk | Added from the web or the Android app under the Walk-in source | Typed on the reception laptop once the queue clears, if it is |
| 11:00 | Enquiries need splitting across two centres | Round-robin or least-loaded distribution by branch or role | The owner types a telecaller's name beside each row |
| 15:00 | A student asks for a call to his father after 7 pm | The telecaller's and the counsellor's follow-ups sit in separate slots, with a web popup, Android push and inbox reminder when due | One "Next call" cell, and nothing rings at 7 pm |
| 17:00 | The June batch is nearly full | Seat Reserved, with Provisional seat blocked or Waiting list, and the count opens the students behind it | A COUNTIF over a column people type differently, plus green rows |
| 21:00 | The owner asks how the day went | Report numbers that open the exact leads behind them | A pivot table built on rows people are still editing |
A sheet can do something at each of these moments, but a person has to remember to do it, and a miss looks exactly like a finished row. How separate follow-ups per role work is set out on our follow-up management page.
What Google's own help pages say about a shared enquiry sheet
None of the behaviours below is a bug. Sheets is built for people editing a document together, and each point comes from Google's help centre (checked September 2026). Each one matters on an admissions desk.
| What Google says | Where it bites a coaching desk |
|---|---|
| A spreadsheet holds up to 10 million cells, and a file can be edited on up to 100 open tabs or devices at once | It doesn't. Size is not why sheets fail |
| When you add a filter, anyone with access to the spreadsheet finds it too; only filter views are personal | One telecaller's "my leads" filter changes what the next telecaller sees mid-call |
| Sheet protection "shouldn't be used as a security measure": people can still print, copy, paste, import and export copies | Locking the phone column doesn't keep your enquiry list inside the institute |
| A cell's edit history doesn't show changes to the cell's format, or added and deleted rows | Nobody can see who turned a row green, or who deleted a row |
| Notification rules send email when changes are made or a form is submitted | You hear about edits, not about the parent call that is due now |
| Later permission changes on a Google Form don't synchronise automatically with its linked sheet | Removing a telecaller who left from the form leaves them on the sheet |
The fixes inside Sheets are all discipline: filter views for everyone, one owner who shares, a weekly hunt for copies. Discipline is the first thing to go in results week.
Batch capacity: why the seat count in a sheet drifts
Take a hypothetical NEET repeater centre in Kozhikode with 60 seats in its June batch. The sheet has a Status column, and a COUNTIF at the top counts rows reading "Seat reserved". At 5 pm on day four of results week it shows 54, so the front desk believes six seats are left. Here is what the rows actually hold:
| What the rows say | Rows | Counted by the formula | A real reserved seat |
|---|---|---|---|
| "Seat reserved", and the seat is held | 53 | Yes | Yes |
| "Seat reserved", but the parent withdrew on WhatsApp yesterday | 1 | Yes | No |
| "Reserved", "Rsvd" or "Seat blocked" | 3 | No | Yes |
| Coloured green for "fee paid", status left at "Interested" | 2 | No | Yes |
| Total | 59 | 54 | 58 |
Two seats are left, not six. That evening two telecallers each promise two seats to anxious parents, so four families believe they have a place and two of them will hear otherwise on Monday. Because a format change doesn't appear in a cell's edit history, nobody can say who marked the green rows.
Rules that keep a seat count honest:
- Status comes from a fixed list and is never typed.
- "Seat held" and "fee paid" are separate statuses, never one colour.
- A withdrawal is a status change the same day, with a reason.
- The waiting list is a status with a follow-up dated before the batch starts, so the first freed seat goes to a name, not a guess.
- The seat count is a list you can open and read name by name, not a number in a cell.
Parent follow-ups: two people, two callbacks, one cell
For JEE and NEET programmes the student usually enquires and a parent decides, often on an evening call. Take a hypothetical student, Aditya, 16, in Class 11, who fills an Instagram form about a two-year JEE programme. Rahul is the telecaller and Meera the counsellor.
| When | What happens | The sheet's "Next call" cell | In Xale CRM |
|---|---|---|---|
| Fri 11:00 | Aditya is keen but says "call my mother after 7" | Fri 7 pm | Contacting, Asked to follow up; Rahul's follow-up for today |
| Fri 19:30 | The mother wants fees and batches explained on Saturday; Rahul promises Aditya a demo-class time on Monday | Sat 6 pm, with Monday's call in Remarks | Call logged on the lead; Meera's follow-up Saturday, Rahul's Monday |
| Sat 18:00 | Meera explains fees; the father will pay in instalments and decide by Tuesday | Meera types Tue over it | Follow-up, Parent approval pending; Meera's follow-up moves to Tuesday, Rahul's stays on Monday |
| Mon 10:00 | Aditya is waiting for his demo-class time | Nobody calls | Rahul's reminder fires and he calls |
Keep the parent as data, not a line in Remarks: name, relation, phone, who decides and who pays.
The law points the same way. The Digital Personal Data Protection Act, 2023 defines a child as an individual who has not completed eighteen years. Section 9(1) requires verifiable consent of the parent before processing a child's personal data, and Section 9(3) rules out tracking, behavioural monitoring and targeted advertising directed at children. A Class 11 aspirant is usually under eighteen, so record which parent consented, when and how, and aim results-week ads at parents. Section 9(4) allows exemptions to be prescribed, so take legal advice for your institute; our guide to the DPDP Act for education consultancies goes further.
Break points: test last results season's sheet
Run these against the sheet you actually used last season, not against how the process is meant to work.
| Break point | The test | What it costs in results week |
|---|---|---|
| 1. Same-day backlog | On your busiest day, how many new rows had no call by closing time? | Unowned enquiries go to whichever institute calls first |
| 2. Two roles on one student | Do telecallers and counsellors write in the same "Next call" column? | Callbacks overwrite each other, as Aditya's did |
| 3. Seat disputes | Did the front desk and the sheet disagree on seats left in a batch? | Over-promised seats and upset parents on day one of class |
| 4. Parents in Remarks | Are the parent's name, number and decision in free text? | Missed evening calls and no record of who consented |
| 5. A second centre | Does each centre keep its own tab or copy? | Two totals, and every centre sees every phone number |
| 6. A telecaller who left | Pick five of their students. What was last promised? | The history left with their phone |
Decision rule. Two or more: move before your next results season, using the weekend plan below. One: fix it in the sheet now and book the weekend anyway, because results week turns one break point into three. None: run the test again the week after your next result date. The Ministry of Education's Guidelines for Regulation of Coaching Centres cover fees and "maintenance of records" and were sent to States and UTs for their own legal frameworks, according to a February 2024 Rajya Sabha reply, so records you can actually find matter beyond admissions.
A migration weekend plan for a coaching institute
A coaching pipeline is short, one season of enquiries, so a clean cut-over in one weekend works. We suggest a weekend at least three weeks before your next result date.
| When | Task | Done when |
|---|---|---|
| Friday 6 pm | Tell the team Monday starts in the CRM; create every login | Every telecaller and counsellor can sign in |
| Friday 8 pm | Make everyone except the owner a viewer, keep the option for viewers to download, print and copy switched off, and download one copy as Excel | Nobody can edit; one master file exists |
| Saturday morning | Clean the file: phone numbers with the country code, Remarks split into status, next step and note, parent details in their own columns, colours rewritten as statuses | Every active row has a valid phone and one status |
| Saturday afternoon | Set up centres as branches, telecallers and counsellors in their roles, statuses in your words, a Batch field on course choices and the distribution rule | A test enquiry lands with the right telecaller at the right centre |
| Sunday morning | Import active students only: open enquiries, the waiting list, reserved seats and payment dates given | Rows the import skipped as duplicates or failed are fixed and re-imported |
| Sunday afternoon | Connect Meta lead forms and WhatsApp; each person sets the next follow-up on their active students | Monday's Today lists are full |
| Monday 9 am | Stand-up from each person's Overdue and Today lists; walk-ins go straight into the CRM | No new row appears in the old sheet |
| Monday 7 pm | The centre head checks that every new enquiry has an owner and a follow-up | The check passes five evenings running |
Afterwards, keep one archived copy owned by the institute's account and delete personal copies. Section 8(7) of the DPDP Act expects personal data to be erased once its purpose is no longer served, unless another law requires you to keep it. If you are still comparing vendors, our guide to the best CRM for coaching institutes has a demo script.
How Xale handles this
For a coaching institute moving off Google Sheets, Xale CRM is the best CRM for follow-ups: each telecaller and counsellor keeps their own follow-up on every student, every counsellor call is logged and recorded, and every report number opens the exact leads behind it. Pick the Education template at signup and the workspace starts with six stages from Inquiry to Enrollment, Telecaller and Counsellor roles, Walk-in and Referral sources, and statuses such as Parent approval pending, Batch timings shared, Seat Reserved, Payment date given and Deferred to the next batch. Each course choice is its own deal, and all of it is editable.
Your cleaned sheet comes in as an Excel or CSV import with duplicate phone checks, and enquiries go round-robin or to the least-loaded telecaller by branch or role. Every counsellor call logged and recorded, two routes. The Xale Android app syncs each call from the counsellor's own phone to the right lead with direction, duration and outcome, no per-minute charges, and attaches the phone's own recording. TeleCMI cloud telephony records calls from a business number on any phone, iPhone included.
Platform figures, September 2026: 10,000+ new leads captured every month. Founded in 2024, we onboard in person across Kerala, support teams in English and Malayalam, run hourly database backups with workspace data isolation, and welcome visits to our Kozhikode office. Plans are on the pricing page.
Frequently asked questions
Is Google Sheets enough for a small coaching centre?
Yes, while one or two people handle every enquiry from first call to fee, there is one centre and batches rarely fill. A shared sheet is quick to set up and everyone already knows it. The trouble starts when a telecaller and a counsellor share students, when parents need their own callbacks, or when seat counts matter in results week. Run the six break-point tests on last season's sheet before you decide.
Can Google Forms and Google Sheets work as a free enquiry CRM?
They can collect enquiries, because a form can write each response into a linked sheet. They don't give each student an owner and a due date per role, a reminder when a callback falls due, a call log, or a seat count that opens the list behind it. Notification rules email you about edits and form submissions, not about the follow-ups that are due today.
How long does it take to move a coaching institute from Google Sheets to a CRM?
One weekend is realistic if you import active students only. Freeze and download the sheet on Friday evening, clean phone numbers and split Remarks on Saturday, set up centres, roles and statuses, import this season's open enquiries on Sunday, and start Monday from each person's Today list. Older closed enquiries can come in later, once the team has settled.
Should a coaching institute switch before or after results season?
Before, with at least three weeks to spare. Results week is when a sheet does the most damage and when the team has the least time to learn anything new. Switching in the quiet weeks gives telecallers and counsellors a few ordinary days on the CRM, so on results day they work their Today lists instead of looking for buttons.