Skip to content
Scholarship Tracker cover: a sample sheet with total on the list, awarded so far and open applications and a bar chart, beside the Dashboard tab

Scholarship Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

The Scholarship Tracker suits students applying for several awards at once. The Scholarships tab records each award with its amount, deadline, who can apply, the number of letters needed, whether an essay is required and its status. The Essays tab keeps a bank of essay topics with word limits and a progress bar that fills as you draft. The Dashboard totals the value of the list and the amount awarded so far, and counts how many open applications are due within thirty days.

Read each award's eligibility rules before you spend time on an essay, and mark those you do not qualify for as Not eligible. Give recommenders three weeks or more ahead of the deadline, and log the date you asked. Keep your essays in one folder, and reuse parts of a personal statement where the prompts allow, rewriting each one for its award.

Useful for

  • Tracking a dozen awards with different deadlines
  • Reusing one personal statement across three applications
  • Counting letters of recommendation still owed

What's included

  • 4 tabs: Dashboard, Scholarships, Essays, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Scholarships: a table
  • Essays: a table
  • 1 chart 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 Scholarships 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

Where do I see which applications close soonest?

List each award with its deadline on the Scholarships tab. Days left counts down until you submit, while the Dashboard displays how many open applications are due within thirty days. Mark an award Submitted once you have confirmation, so it drops off the countdown.

How can I spot a scholarship scam?

Be wary of any award that asks for a fee, a bank account number or a payment to release money. Legitimate awards are usually run by schools, foundations or employers, so check the sponsor's website and ask your school's counseling office before you apply.

Should I apply for small scholarships?

Yes, if the time cost is reasonable. Several small awards can add up, and they often have fewer applicants. Compare the amount with the essays and letters required, and focus on the ones you are most likely to win.

  • #grade-tracker
  • #scholarship-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…