2 July 20265 min read

Why spreadsheets break when a student applies to five universities

One student, many applications, many offers, each with its own conditions. Here is why spreadsheets fall apart and what to track instead.

By the Edudex team — we ran a study-abroad agency for six years before building this.

A single student rarely applies to one university. They apply to four or five, each of which may return more than one offer, and each offer carries its own conditions — English scores, deposits, transcripts, interviews. This is where the spreadsheet quietly gives up.

The one-row-per-student trap

Put one student on one row and you immediately run out of columns. Five applications, each with two offers, each with a five-item checklist, does not fit a grid. Agencies end up with colour codes, extra tabs and notes that only one person understands.

The one-deal-per-application trap

Generic CRMs make the opposite mistake. They treat every application as a separate deal, so the same student appears five times with no shared view. You lose the person inside a list of deals.

What you actually need to see

The right model mirrors reality: one student, holding many applications, each holding one or more offers, each offer holding its own condition checklist. On one screen a counsellor should be able to answer:

  • Which universities has this student applied to, and what stage is each at?
  • Which offers are in hand, and which are conditional?
  • What conditions are still outstanding, and who is chasing them?
  • What is the single next action for this student today?

Why it matters commercially

Every outstanding condition that slips is an enrolment at risk. When the whole case is visible in one place, nothing is forgotten, handovers between counsellors are painless, and managers can see where each student really stands.

Edudex is built around this exact shape — one lead, many applications, many offers, clear conditions — so your team can stop maintaining spreadsheets and start moving students forward.

Catch every lead with Edudex

Capture leads from Meta ads and WhatsApp, and track every application in one place. Free during early access.

Start your agency

Frequently asked questions

Why can't a normal CRM handle study-abroad applications?

Most CRMs model a contact as a single deal. A study-abroad student holds many applications, each with its own offers and conditions. Generic tools either flatten this into one row or split the student across many unrelated deals, and both lose the full picture.

Can I customise the stages and checklists?

Yes. Stages and condition checklists are meant to be configured by your agency, since every destination and university has its own requirements. On paid plans you can also add unlimited custom fields for anything specific to your workflow.

Does each counsellor see only their own students?

By default a counsellor sees the leads and students they own, while admins can see the whole agency. Data is separated per agency at the database level.