Skip to content
College Application Tracker cover: a sample sheet with schools on the list, still drafting and submitted and a column chart, beside the Dashboard tab

College Application Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The College Application Tracker suits students and parents managing several applications at once. The Schools tab records each college with its type (Reach, Target or Safety), application plan, deadline, decision date, fee and status. The Steps tab lists the tasks for each school, such as essays, letters, test scores and fees, each dated and marked To do or Done. The Dashboard shows how many schools are on the list, how many are still being drafted, how many are submitted and the total application fees.

Add every school as soon as you start researching it, even before you decide to apply, so the list stays complete. Check each school's portal for its own deadlines, since they can differ from the dates here. Early decision is binding, so mark that plan only for a school you would attend if admitted, and keep the rest of your list on regular or early action.

Useful for

  • Tracking five applications with different deadlines
  • Keeping early action and regular deadlines apart
  • Totaling application fees before a fee waiver request

What's included

  • 4 tabs: Dashboard, Schools, Steps, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Schools: a table
  • Steps: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Schools tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How many colleges should I apply to?

Most advisers suggest a mix of reach, target and safety schools, and how many you can manage rests on budget, time and grades. Use the type column to check that your list has schools in each group, and track fees against your budget as you add them.

What is the difference between early decision and early action?

Early decision is binding: if you are admitted, you must attend and withdraw other applications. Early action is not binding, so you can compare offers. Both usually have earlier deadlines than regular decision, so check each school's rules.

What should I track for each application?

Note the deadline, decision date, fee, essays, letters, test score reporting and any financial aid forms. Check the school's website for requirements, and confirm each submission in the portal before you mark it Submitted.

  • #grade-tracker
  • #college-application-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More grade tracker templates

See all 8

Also in Careers

All careers templates
Get this template

Preparing your template…