If you talk to anyone who’s gone through a full med school application cycle, you’ll hear the same thing:
“I didn’t realize how fast everything piles up.”
One minute you’re just submitting your AMCAS.
The next minute you’re drowning in:
- 20+ school portals
- Primary and secondary dates
- Different logins
- Interview invites
- Waitlists and final decisions
Trying to manage that in your head (or with random notes on your phone) is how deadlines get missed and secondaries slip through the cracks.
So I put together a free Medical School Application Tracker spreadsheet (Google Sheets) you can copy and use for your entire cycle.
Get the Free Med School Application Tracker (Google Sheets):
https://docs.google.com/spreadsheets/d/1kWVx4GavFuo-kiFwIO5bfbAuu2-yjE29/edit?usp=sharing&ouid=105765943501255017123&rtpof=true&sd=true
(Open → File → Make a copy → Save to your own Google Drive.)
Check out my other free resources: Free Premed & MCAT Spreadsheets: Track Your Hours, Scores, and Applications
This post shows you exactly how the med school application tracker spreadsheet works and how to use it to keep your cycle organized from first primary to final decision.
Why you need a medical school application tracker
A typical applicant:
- Applies to 15–30 schools
- Manages multiple application services (AMCAS, AACOMAS, TMDSAS)
- Completes dozens of secondaries on tight deadlines
- Juggles interview dates, travel or virtual setups, and different status portals
Without a system, this turns into:
- “Wait… did I ever submit that secondary?”
- “What’s the portal login for [School X] again?”
- “When did I send that letter update?”
A med school application tracker spreadsheet gives you:
- One page where every school lives
- Clear tracking for primaries, secondaries, interviews, and decisions
- A way to prioritize your time and energy (and sanity) during the busiest months of the cycle
And because it’s a Google Sheets template, you can:
- Access it from anywhere
- Share it with a parent, partner, or advisor (if you want)
- Customize it for MD, DO, or both
What’s inside the Free Med School Application Tracker (Google Sheets)
Each row of the spreadsheet is one school.
Each column is one piece of your application progress.
You can customize everything, but here’s how I set it up.
Core school info
For each program:
- School Name
- State / Region
- MD/DO (or Dually accredited if relevant)
- Mission Fit / Tags – quick labels like:
- “Research-heavy”
- “Primary care”
- “Rural medicine”
- “Jesuit/Service-focused”
These fields help you remember why you picked the school in the first place and whether it’s actually a good use of your time/fees.
Portal + contact columns
- Application Service (AMCAS, AACOMAS, TMDSAS)
- Portal Link (direct URL to that school’s status portal)
- Username / Email you used for the portal
This way you’re not digging through your inbox every time you need to check your status.
(Tip: never put passwords in any shared spreadsheet. Just keep portal URLs + usernames here.)
Primary application tracking
Columns for your primary:
- Primary Submitted (Date) – when you hit submit
- Primary Verified (Date) – when AMCAS/AACOMAS/TMDSAS actually verified it
- Primary Fee (optional) – if you want to track cost per school
You can quickly scan down this section to see:
- Which schools are still waiting on verification
- Which primaries went out later (helpful context for later in the cycle)
Secondary application tracking (with deadlines)
Secondary apps are where things usually get chaotic, so the tracker has several specific columns for them:
- Secondary Received (Date)
- Secondary Fee (optional but useful)
- Secondary Deadline
- Secondary Started? (checkbox or Y/N)
- Secondary Submitted (Date)
If you want to get fancy, you can:
- Add conditional formatting to highlight:
- Secondaries due within 7 days
- Overdue secondaries (due date passed, no submitted date)
- Add a “Priority” column:
- High (top-choice schools / strong mission fit)
- Medium
- Low (you’re okay skipping if pressed for time or money)
This turns the sheet into a live to-do list instead of a static log.
Interview invitations and status tracking
For each school, you’ll track:
- II Received (Date) – when you got the interview invite
- Interview Format – In-person / Video / MMI / Traditional
- Interview Date
- Thank-You Sent? – quick checkbox or date
- Post-Interview Status – e.g. “On Hold,” “Waitlisted,” “Accepted,” “Rejected”
If you’re doing in-person interviews, you can add:
- Travel Notes – flight/hotel info or “driving, no hotel”
- Estimated Cost – if you want to keep an eye on interview expenses
You can filter the sheet to show only schools with interviews and see all your upcoming dates in one view.
Acceptance, waitlist, and deposit tracking
Once decisions start rolling in, you’ll use:
- Decision – Accepted / Waitlisted / Rejected
- Decision Date
- Deposit Due Date / CTE Date (Choose Your Enrollment)
- Deposit Paid? – Y/N + amount
- Scholarship / Aid Notes – any $ details you want to remember
This section is especially helpful in the spring when you’re:
- Choosing between multiple acceptances
- Monitoring waitlists
- Making sure you don’t miss CTE or deposit deadlines
Notes column (mission fit, vibes, gut feeling)
Finally, each row has a Notes column.
Use it for things like:
- “Strong GI research; PI I emailed responded”
- “Close to family; low cost of living”
- “Curriculum is heavy PBL, not sure if I like that”
- “Interview day felt cold; students seemed burnt out”
Those are the details you forget 3 months later when you’re trying to decide which acceptance to keep.
How to use the med school application tracker (step-by-step)
Step 1 – Make your own copy
- Open the Sheet:
https://docs.google.com/spreadsheets/d/1kWVx4GavFuo-kiFwIO5bfbAuu2-yjE29/edit?usp=sharing&ouid=105765943501255017123&rtpof=true&sd=true - Click File → Make a copy.
- Save it to your Google Drive with a name like:
- “2026 Med School Application Tracker – MD/DO”
Now you can edit and customize; the original stays clean in case you ever want to start over.
Step 2 – Add your target school list
Before you submit primaries, fill in:
- School name, state, MD/DO
- Application service (AMCAS/AACOMAS/TMDSAS)
- Optional: Mission fit tags + a quick note on why the school is on your list
Build this list using:
- MSAR and school websites
- Your own Medical School Database (mission, special programs, etc.)
- Tools like a WARS-style calculator and GPA/MCAT data to reality-check your range
This gives you a clean master school list to work from when primary season opens.
Step 3 – Update the tracker when you submit primaries
On the day you submit:
- Enter the Primary Submitted date for each school.
- Later, when AMCAS/AACOMAS verifies your primary, fill in Primary Verified dates.
You can also:
- Tag schools you applied late to (so you temper expectations a bit).
- Keep track of application fees if you want a running total of costs.
Step 4 – Use it as your secondary application command center
Once secondaries start arriving, this becomes your daily dashboard.
Set up a quick routine:
- When you receive a secondary:
- Fill in Secondary Received and Secondary Deadline.
- Update your Priority and Fee if you’re tracking costs.
- During your writing sessions:
- Filter the sheet to show secondaries not yet submitted.
- Sort by deadline or by Priority + Deadline.
- When you submit:
- Enter the Secondary Submitted date.
- Optionally shade that cell green or add a checkmark so it visually stands out.
This keeps you from waking up at 3 a.m. thinking, “Didn’t I have something due yesterday?”
Step 5 – Track interview invites and decisions in one glance
As interview season ramps up:
- Filter or color-code schools with II Received so they stand out.
- Add your Interview Date and Format to avoid double-booking yourself.
- Use the Thank-You Sent? column as a polite follow-up checklist.
When decisions start rolling in, update:
- Decision (A/WL/R)
- Scholarship notes
- Deposit dates
If you have multiple A’s, you can even add a column for:
- “Would Attend (1–5)” or
- “Gut Rank”
to help with your final choice.
Customize the tracker for MD-only, DO-only, or reapplicants
The base template works for everyone, but you can absolutely tweak it:
- MD-only applicants: hide the MD/DO column and add a “Research emphasis?” column.
- DO-only applicants: add specific columns for things like COMLEX or OMM interest, if you care.
- Reapplicants: mark which schools you applied to previously and maybe add a column “Reapplicant? Y/N” plus notes on what’s changed.
You can also duplicate the Sheet for:
- Different cycles (2026, 2027, etc.)
- A friend or sibling (just make a fresh copy)
Pair it with other AspiringMD tools for a smoother cycle
This med school application tracker spreadsheet is meant to plug into the rest of your system, not exist in isolation.
Use it alongside:
- Medical School Database – to build a smart school list instead of a random one.
- AMCAS Application Timeline – to know when each part of the cycle happens.
- Free Premed & MCAT Spreadsheets – especially your:
- MCAT Content Review Tracker
- FL Review & Error Log
- Hours / Activities trackers
Plus, for keeping your budget in check:
- Your upcoming posts on MCAT & application costs and True Cost Roadmap.
Final thoughts: save your brain for the hard stuff, not the logistics
The med school application process is already mentally exhausting.
You don’t need the added stress of trying to remember:
- Which portal link goes with which school
- Which secondary you meant to start today
- Which programs haven’t responded since August
Offload that chaos into a simple, free med school application tracker and let the spreadsheet be the bad guy that nags you about deadlines.
Make your copy of the Free Medical School Application Tracker (Google Sheets) here:
https://docs.google.com/spreadsheets/d/1kWVx4GavFuo-kiFwIO5bfbAuu2-yjE29/edit?usp=sharing&ouid=105765943501255017123&rtpof=true&sd=true

