College Application & Scholarship Tracker | Google Sheets & Excel Senior Year Planner
This college application and scholarship tracker keeps every deadline, requirement, essay, recommendation, scholarship and aid offer in one place, with a dashboard that always shows what's due next.
✦ WHAT'S INCLUDED
• Tracker spreadsheet (.xlsx), example student with 9 colleges, 10 scholarships, essays and recommenders
• Blank version (.xlsx): 40 colleges, 100 scholarships, 60 essays, 30 recommenders
• Step-by-step PDF guide for Google Sheets and Excel
✦ FEATURES
• Dashboard: colleges, submitted, accepted, app fees, scholarships, $ applied for, $ won and % of your goal
• Next 6 college deadlines and next 6 scholarship deadlines, with days left
• Colleges: type, plan (ED/EA/REA/RD/Rolling), deadline, platform, fee and waiver, essays, recs, transcript, test scores, FAFSA/CSS, status and decision date
• Checklist score per school and due-soon / overdue alerts on your own warning window
• Scholarships: amount, deadline, renewable, eligibility, essay, recs, link, status and amount won
• Essays tab with word limit check; Recommendations tab with thank-you tracking
• Aid & Cost: real net cost per year and for 4 years vs. your budget
• Compare: weighted decision matrix that ranks your schools
• Senior Year Checklist: 26 tasks from August to June
✦ WHY IT'S DIFFERENT
• Applications, scholarships, essays, recs, aid and decision in ONE file
• Auto deadline countdown and dashboard, not just a list
• Weighted decision matrix and net-cost comparison
• Both Google Sheets and Excel; share it with parents and counselors
✦ HOW IT WORKS
1. Buy and download your files instantly after checkout.
2. Upload the .xlsx to Google Drive and open it with Google Sheets, or open it in Excel.
3. Follow the Start Here tab. Everything else calculates.
✦ GOOD TO KNOW
• Instant download: nothing physical is shipped.
• Works in Google Sheets (free) and Microsoft Excel 2016+ / Microsoft 365 / Excel for the web. Not compatible with Apple Numbers.
• Works on desktop and in the Google Sheets and Excel phone apps (a computer is easiest for setup).
• No macros. Example and blank versions included. Licensed for one person or one business.
• Record-keeping and planning tool, not tax, legal or financial advice.
• Questions? Message me. I usually reply within a day.
© SageAndSheets. Please do not share or resell. Because this is a digital download, refunds aren't offered, but if anything isn't working, message me and I'll make it right.