Scholarship Tracker Spreadsheet, College Scholarship Organizer with Deadlines, Essays, Letters and Awards, Google Sheets Excel

A scholarship tracker for high school seniors, college students and parents. Every scholarship, deadline, essay and letter is in one file, with the money you won.

🔗 TRY THE LIVE DEMO before you buy (view only, nothing to install): https://docs.google.com/spreadsheets/d/13jx0mv7nBAnQ74uZBCeE7cmqhJ03HpMisxWo00U0YC4/edit?gid=1320511494

📊 WHAT IT DOES

✓ Scholarships: each one with the amount, the deadline, the kind, the lowest GPA they take, the essay, the letters it needs and the status.
✓ The check counts the days left and says what is still missing, like an essay not done or a letter you do not have yet.
✓ A scholarship that asks for a higher GPA than yours, or for a fee, gets a warning before you spend time on it.
✓ Essays: write each essay once and use it for many scholarships. The file counts where it is used and what it has won.
✓ Letters: who writes your recommendation letters, when to ask, when to nudge and who is owed a thank-you.
✓ Summary: what you won against your goal, your win rate, deadlines by month and by kind, and what is due next. Three charts.

📂 WHAT'S INSIDE: 5 TABS AND 3 CHARTS

✓ Start here: five cells and the statuses in order
✓ Scholarships: four cards and every scholarship
✓ Essays: four cards and every essay
✓ Letters: four cards and every letter
✓ Summary: four cards, month by month, by kind, coming up, and three charts

📝 HOW IT WORKS

1. Open the PDF and click the link to make your own copy in Google Sheets. Or open the Excel file.
2. On Start here, type the student's name, a goal to win and the GPA.
3. On Scholarships, add each one you find with the amount and the deadline.
4. Add your essays and letters, and change the status as you go. Summary shows what you won.

📥 WHAT YOU GET

✓ Google Sheets version (the link is in the PDF)
✓ Excel version (.xlsx) for desktop Excel 2016 or newer and Microsoft 365, on Windows or Mac
✓ A filled example to look around, and a blank copy for your own use
✓ A PDF guide with screenshots, the links and the first steps
✓ A video guide for this spreadsheet (the link is in the PDF)

💻 GOOD TO KNOW

✓ Works with a free Google account. No app, no ads, no subscription.
✓ Local scholarships often have fewer applicants. Summary shows your win rate by kind, so you know where your time pays.
✓ Room for 100 scholarships, 30 essays and 20 letters.
✓ A parent can keep it for a student: share the file in Google Drive.
✓ Formulas are protected, so you can't break anything by accident.
✓ Set it up on a computer in a few minutes. After that, the Google Sheets app works for a quick update on your phone.
✓ The photos show Google Sheets. The Excel file has the same tabs and formulas (the jump links between tabs are a Google Sheets feature).
✓ On a Mac? Use free Google Sheets or Excel for Mac.
✓ Free updates for life.

This is a digital download, so nothing is shipped. If anything is unclear after you buy, message me and I'll help you set it up.