Almost every small school starts admissions in a spreadsheet. It makes sense — a spreadsheet is free, familiar, and flexible. But somewhere between 20 and 50 applications, the spreadsheet stops being a tool and becomes a liability. Two people edit the same row. A family's status says "accepted" in one tab and "pending" in another. A deposit gets paid and nobody updates the sheet. The applicant who needed a follow-up call three weeks ago is still waiting.
This is not a discipline problem. It is a tooling problem. Spreadsheets were never designed to manage a process with deadlines, handoffs, and money attached. This guide lays out how to run admissions as an actual pipeline — what stages to define, what to automate, and how to make sure no applicant ever falls through the cracks.
Define your pipeline stages first
Before any tool, get clear on the stages an applicant moves through. Most schools have some version of this:
- Inquiry — a family expresses interest, often through a form or a tour request.
- Application started — they have begun but not submitted.
- Application submitted — the application and any fee are complete.
- Under review — your team is evaluating, possibly including an interview or assessment.
- Decision — accepted, waitlisted, or declined.
- Enrollment — accepted families confirm, pay a deposit, and complete enrollment paperwork.
Write these down and define exactly what moves an applicant from one stage to the next. "Application submitted" should mean something specific and unambiguous — the form is complete and the fee is paid, full stop. When your stages are crisp, anyone on your team can look at the pipeline and know precisely where every family stands. That clarity is the single biggest thing a spreadsheet cannot give you reliably.
The four jobs your admissions system has to do
A real admissions process does four things. A spreadsheet does the first one poorly and the other three not at all.
1. Capture every inquiry automatically
Inquiries arrive from your website, from events, from word of mouth. If capturing them depends on someone remembering to type a name into a sheet, you will lose some. The fix is an online inquiry or application form that writes directly into your system. The moment a family fills it out, they exist in your pipeline at the "inquiry" stage with a timestamp. No manual entry, no lost leads.
2. Move applicants through stages with a clear owner
Every applicant should have a current stage and, ideally, a current owner — the person responsible for the next action. The power of a pipeline view is that you can see at a glance how many families are stuck in each stage. Fifteen applications sitting in "under review" for three weeks is a bottleneck you can now see and fix. In a spreadsheet, that pile-up is invisible until a frustrated parent calls.
3. Automate the follow-up
This is where spreadsheets cost you enrollments. A family who starts an application and does not finish needs a nudge. An accepted family who has not paid the deposit needs a reminder before the deadline. Done by hand, these follow-ups happen inconsistently — and the ones you forget are the families who quietly enroll somewhere else.
Automate them. Set up rules like:
- If an application is started but not submitted after three days, send a reminder email.
- When a family is accepted, automatically send the enrollment packet and deposit instructions.
- If a deposit is unpaid five days before the deadline, send a reminder and flag it for a personal call.
The goal is not to remove the human touch — it is to make sure the routine nudges always happen so your team's time goes to the conversations that actually need a person.
4. Collect money and paperwork in one flow
Application fees, deposits, and enrollment contracts are part of admissions, not a separate task you handle later. When a family can pay the application fee as they submit, and pay the deposit and sign the enrollment agreement in the same flow as their acceptance, you eliminate an entire category of "did they pay yet?" chasing. The system records it, the family gets a receipt, and your pipeline updates itself.
What to look for in a tool
You do not need a sprawling enterprise CRM. You need software that handles the four jobs above without a consultant. When evaluating options, check that it can:
- Build a custom application form that matches what your school actually asks, including document uploads for transcripts or recommendations.
- Show a pipeline view where you can see and move applicants between stages.
- Send automated, triggered emails based on stage and time, with the ability to personalize.
- Collect application fees and deposits online with an automatic receipt and a clear record.
- Hand off cleanly to enrollment so an accepted applicant becomes an enrolled student without re-entering their data.
That last point matters more than it sounds. If admissions lives in one tool and your student records live in another, you will re-type every accepted family's information — and re-typing is where errors and dropped families happen. The cleanest setup is admissions and student records in the same platform, so an accepted applicant simply becomes a student record with one click.
A realistic rollout
You do not have to rebuild everything at once. A sensible sequence:
- Put your inquiry and application form online first. This alone stops lost leads and starts populating a real pipeline.
- Define your stages and start managing applicants in the pipeline view instead of the sheet.
- Turn on the two highest-value automations: the unfinished-application nudge and the deposit reminder.
- Move fee and deposit collection online.
- Connect admissions to enrollment so accepted families flow straight into your student records.
Each step removes a category of manual work and a category of risk. By the end, your team spends its admissions energy on relationships and judgment calls — the things that actually win families — instead of data entry and status reconciliation.
The families you lose to spreadsheet chaos are rarely the ones who decided you were not a fit. They are the ones who slipped through a missing follow-up or a status that never got updated. A real admissions pipeline does not just save your team time — it recovers the enrollments you were quietly losing.