1. Create the sheet
Open a new Google Sheet or Excel workbook. Paste the column headers below into row 1, then freeze that row so it stays visible while you scroll.
The college application spreadsheet template
A spreadsheet is the cheapest way to stop losing track of deadlines, supplements, and recommendation letters. Copy the columns below, fill one row per school, and sort by deadline — that alone prevents most late submissions.
Build it in five minutes
2. Add one row per school
Start with every school you are considering, even the maybes. Cutting rows later is easier than remembering a school you forgot to write down.
3. Sort by deadline
Sort the whole range by the deadline column, ascending. Your work order is now literally top to bottom.
4. Add conditional formatting
Highlight rows red when the deadline is within 14 days and Submitted is still No. This turns the sheet into a warning system instead of a list.
5. Review it weekly
Pick one day a week to update statuses. A tracker that is three weeks stale is more dangerous than no tracker at all.
Copy these column headers
Paste this line into cell A1 of a new sheet — the tabs split it into columns automatically.
College Tier Application plan Deadline Financial aid deadline Application fee Supplements Supplement status Recommenders Test policy Scores sent Portal created Submitted DecisionWhat each column is for
| Column | Example | Why it matters |
|---|---|---|
| College | Boston University | One row per school. Keep the official name so portal searches match. |
| Tier | Target | Likely, target, or reach — based on your GPA and test scores versus the school's middle 50%. |
| Application plan | RD | ED, ED II, EA, REA, or RD. This single column drives most of your deadline math. |
| Deadline | 2027-01-04 | Use YYYY-MM-DD so the column sorts correctly in every spreadsheet app. |
| Financial aid deadline | 2026-11-01 | Aid deadlines are often earlier than admission deadlines and are the most commonly missed date. |
| Application fee | $80 | Total it at the bottom so fee-waiver decisions happen early, not the night before. |
| Supplements | 2 (250w, 100w) | Count and word limits tell you where the real writing workload sits. |
| Supplement status | Draft 2 | Not started / drafting / revised / final. Never mark final until someone else has read it. |
| Recommenders | Mr. Silva, Ms. Ortiz | Track who you assigned in the Common App, per school, since limits vary. |
| Test policy | Test optional | Required, optional, or blind — decides whether you send scores at all. |
| Scores sent | Yes — 10/12 | Score sends are separate from submitting, and they lag by days. |
| Portal created | Yes | Most schools email a portal invite after submission; confirm you can log in. |
| Submitted | No | The only column that matters on deadline day. |
| Decision | — | Fill in through spring, then compare aid offers before the May 1 deposit. |
Where spreadsheets break down
- Deadlines are typed by hand, so one wrong date silently becomes your plan.
- Essays live somewhere else — the sheet tracks status but never the actual draft.
- Nothing reminds you. A spreadsheet only warns you when you happen to open it.
- Reach/target/safety labels are guesses instead of being calculated from your stats.
Or skip the spreadsheet entirely
College Clarity does every column above automatically — real admissions data, calculated reach/target/likely tiers, your supplemental drafts stored per school, and deadlines sorted for you. Free to start.
Build your tracker freeNext: read the month-by-month application timeline or the Common App essay prompts.