College Application Tracker Spreadsheet | Scholarship and Common App Deadline Planner for Excel and Google Sheets | Compare Award Letters

The essay gets all the attention. The calendar decides.

Families pour months into 650 words, and then lose a school to a portal task nobody checked. A recommender who said yes in the corridor and was never formally invited inside the system. A financial aid form that opened in October and closed while everyone was still editing an essay.

The work that determines the outcome is not the writing. It is the tracking. That is what this file is for, and it is why there are twenty tabs and not eight.

Everything you get

- A 20-tab connected workbook in four colour themes — Editorial, Light, Dark and Colorful. One engine, identical maths, pick the one you like looking at.
- Works in Microsoft Excel AND Google Sheets from the same download. Portable formulas only.
- A hosted Google Sheets copy link — open it, choose File → Make a copy, and you are working.
- A four-page Quick-Start PDF, including a printable one-page-per-school worksheet you can fill in at the kitchen table.
- A complete worked sample you can read before you type a single thing: nine schools, 41 dated items, 14 supplemental essays, 22 recommender invitations and six award letters.
- Free lifetime updates. No subscription, nothing extra to buy inside.

The tab tour

1. Start Here — three steps, the tab map, and the reason every college-specific cell ships blank.
2. Dashboard — days to the next dated item, applications by status, portal tasks still open, what the cycle has cost against what the waivers took back, scholarship dollars applied for against dollars won, and the aid gap on the best offer. Nothing on this page is typed in.
3. College List — the schools, with type, state, admission plan, deadline, portal, fee, waiver flag, reach / target / likely band, and why each one is on the list.
4. Deadline Calendar — every dated item across every school in one sorted view, with a live countdown and an overdue flag. In the sample that is 41 items, and only nine of them are application deadlines.
5. Application Tracker — per school: submitted date, days of margin against the deadline, fee paid, portal task list, supplements, interview offered and completed, decision date, decision.
6. Requirements Matrix — school by requirement, so nothing is assumed: transcript, counselor report, mid-year report, teacher letters, portfolio, interview, supplement count — and a deliberately blank test-policy column with its own "verified on" date cell.
7. Essay Tracker — the personal statement plus every supplement: prompt, word cap, live word count, margin under the cap, draft status, reader, final date, and a reuse map that turns 14 supplements into 7 drafts.
8. Recommenders — asked, formally invited inside the portal, materials sent, submitted per school, thank-you sent. Plus a school-by-school grid that makes a missing letter impossible to miss.
9. Activities & Honors — the activities list with live character counters against the real 50 / 100 / 150 limits, and the honors list. Draft it once here; paste it once into the portal.
10. Testing — sittings, scores by section, a superscore built from your own results, a score-send log with fees, and a note on which sitting still lands before an early deadline.
11. Transcript & Coursework — courses by year, the GPA on your transcript beside two honest unofficial cross-checks (all courses, and core only), rigor summary, senior schedule, mid-year report status.
12. Financial Aid Forms — FAFSA and CSS Profile status per school: required, submitted, corrections, IDOC, verification — with the fee-waiver logic worked out and the aid-calendar caveat printed on the tab.
13. Award Comparison — the centrepiece. Per school: cost-of-attendance components, grants and scholarships, net price computed as cost of attendance minus GIFT AID ONLY, then loans and work-study shown separately below the line, plus a four-year projection with an annual increase you enter yourself.
14. Scholarship Pipeline — sponsor, amount, deadline, essay required, status, result, dollars won, hit rate — with honest framing on how much money is actually out there.
15. Application Costs — fees, waivers, score sends, CSS Profile fees, travel to visits, with a running total that ties to the Dashboard, and the nine official fee-waiver indicators printed in full.
16. Campus Visits — dates, format, who you met, notes, and a scored impression grid so the April decision has evidence behind it and not just a memory of the weather.
17. Decisions & Deposits — offers in, waitlists, appeals, deposit amounts and dates, the single accept, and the withdraw-the-rest checklist almost nobody completes.
18. Portals & Logins — institution, portal name, username, MFA status and *where the credential lives*. No passwords. The rule is printed on the tab itself.
19. Parent Corner — what the parent owns against what the student owns, the money conversation checklist, the tax-year and asset questions the aid form will ask, and the "what we can actually afford" number that has to be said out loud in September rather than April.
20. Reference & Sources — every fact in the file with its source name, URL and check date, a glossary (SAI, cost of attendance, gift aid, net price, superscore, yield, demonstrated interest, displacement, verification, IDOC), and a plain list of the numbers this file refuses to print and why.

The one thing no other file in this lane gets right

Federal law defines net price as cost of attendance minus grant aid only — need-based and merit-based grants from federal, state and institutional sources (20 U.S.C. §1015a). Not loans. Not work-study. A loan moves the bill; it does not shrink it.

This workbook computes it that way on every row and puts the borrowing in two clearly-labelled columns below the line. In the worked sample, two offers with an identical published cost of attendance turn out to be $10,459 apart over four years, purely because one college put more gift aid on the table — and a private nonprofit with a $65,470 sticker nets out cheaper than every out-of-state public offer on the list.

What this file never does

- It never predicts anybody's odds of admission. There is no chance-me score, no probability column and no "your chances" number anywhere in it.
- It never states a named college's deadline, application fee, test policy, required forms or deposit as a fact. Every one of those is a cell you fill in, with a "verified on" date beside it. The test-policy column ships blank on purpose — the national trackers actively contradict each other, and one of them concedes that not all schools have finalised their policies.
- It never subtracts a loan or work-study from net price.
- It never quotes a statistic it cannot source. Every figure it does print is on the Reference & Sources tab with a name, a URL and the day it was checked.
- It never stores a password.
- It does not budget a semester. This file stops at the deposit.

How to open it

Excel, Numbers or LibreOffice: double-click any .xlsx. Google Sheets: Drive → File → Import → Upload, or just open the hosted copy link included with your purchase and choose File → Make a copy. Every formula in this file is portable, so nothing breaks in the move.

PAIRS WELL WITH

- College Budget Spreadsheet — https://www.etsy.com/listing/4545270368/college-budget-spreadsheet-semester-cash Picks up exactly where this one stops: semester cash flow once you have enrolled, the week you run short, the aid gap after the deposit.
- Student Loan Repayment Command Center — https://www.etsy.com/listing/4545247349/student-loan-repayment-planner-rap-idr For the years after that.

A note on the numbers you will see in the photos

The figures shown are a worked sample, not a customer. "Naomi Reyes" is a fictional persona and the nine colleges are invented names — no real college's deadline, fee, aid rule or test policy is stated as fact anywhere in this workbook. Every screen in the photos and the video is a render of the real file after it was recalculated, not a mock-up.

Instant download. Buy once, own it forever.