UCAS Tracker

UCAS Application Planner

A complete UCAS planner and dashboard, built in Excel and Google Sheets.

Everything you need to manage your UCAS application, from first research to results day, in one linked spreadsheet system. No more scattered notes, forgotten deadlines or guessing where you stand. Add your universities once and the whole planner updates itself.

WHAT'S INSIDE

Home Dashboard

Your application at a glance: universities applied, offers received, interviews scheduled, references complete and your overall completion percentage. Four live countdowns (UCAS deadline, early entry deadline, next interview, results day), a completion ring chart, an application status chart, your tasks due this week, quick links to every tab and a daily focus recommendation that updates automatically.

University Application Tracker

Log every university and course: entry requirements, required subjects, predicted vs target vs current grades, UCAS tariff points, application status, decision status, firm/insurance choice, deadline and priority. Status is colour-coded automatically and a progress bar tracks each application.

University Research Database

Compare options before you commit: course duration, degree type, Russell Group status, league and subject rankings, student satisfaction, graduate employment and salary, tuition and accommodation costs, distance from home, open day dates, personal rating and likelihood of applying.

Entry Requirements Tracker

A readiness checklist per course: required grades, subjects, GCSEs, admissions test, interview, portfolio, work experience and volunteering requirements, each with a live completion percentage so you know exactly what's missing.

Personal Statement Dashboard

A live character, word and line counter checked against the UCAS 4,000-character limit, a 15-stage writing checklist from brainstorming to submission, a version history table and space for reflection notes.

Reference Tracker

Track who you've asked, what's been requested and received, predicted grades, deadlines and reminder status, with automatic colour-coded urgency.

Admissions Test Tracker

Built for UCAT, BMAT, TMUA, ESAT, LNAT, MAT, STEP, PAT or any custom test. Track registration, booking and exam dates, revision hours, resources used, weak and strong areas, and a mock-score trend chart that shows your progress over time.

Interview Management System

Interview type, date, time, location or video link, travel and accommodation plans, a preparation percentage, mock interviews completed, confidence rating, documents needed, questions to ask and outcome, with an automatic countdown to interview day.

Work Experience Tracker

Organisation, role, hours, dates, skills learned, reflection, reference and certificate status, linked competencies and the course each placement supports.

Supercurricular Tracker

Log books, online courses, lectures, podcasts, articles, research, competitions, projects and volunteering, with reflection notes and skills gained for each entry.

and many more!

HOW IT WORKS

Every status, priority and category field is a dropdown, so nothing gets mistyped. Progress bars, countdowns and colour-coding are all built from formulas, not hardcoded, so they update the moment you make a change. Add your universities once on the University Tracker and every other tab, including the Dashboard, pulls from that same data.

COMPATIBILITY

Works in both Excel (2016 or later, or Microsoft 365) and Google Sheets. Fully editable: rename tabs, add rows or adjust categories to fit your own application.

INSTANT DOWNLOAD

Delivered as a ready-to-use spreadsheet file. Just open it and start adding your universities.