Residency Application Tracker, ERAS Spreadsheet for Match 2027, Program Signals, Interview & Rank List Builder, Excel and Google Sheets

Applying to residency this cycle? This spreadsheet gives you one place for your program list, signals, interview invites, thank-you notes, costs, and your rank list.

Made by a current med student.

WHAT'S INSIDE (7 tabs)
- Start Here: a quick setup guide (about 15 minutes).
- Program List: room for 150 programs. Dropdowns for specialty, state, track, signal sent (and gold / silver tier), status, and "will rank?". Signaled programs light up yellow. Days from applying to invite are worked out for you.
- Interviews: pick a program and its date pulls in automatically. Log format, travel and lodging, people you met, what stood out, and a gut rating. Thank-you notes you still owe turn orange.
- Cost Forecast: ERAS fees per specialty (the cheaper first-30 tier restarts for each specialty), USMLE / COMLEX transcripts, NRMP registration and extra-rank fees, and interview travel. Forecast vs. spent so far.
- Rank List Builder: set how much each factor matters to you (training, location, culture, career outcomes, pay vs. cost of living, schedule, gut feeling), score each program 1-5, and a ranked list sorts itself. Mark deal-breakers to drop them off.
- Dashboard: applications, signals used per specialty, invite rate (signaled vs. not signaled), upcoming interviews, thank-yous owed, days until the rank list deadline, and total cost.
- Settings: every fee with its source link and the season it applies to, key 2027 dates, and the 2027 signal numbers for participating specialties. Everything is editable, so you can update it if something changes.

GOOD TO KNOW
- Works in Microsoft Excel (2010 or later) and Google Sheets. No macros, no add-ons.
- For US MD and DO applicants. DO students can switch on the COMLEX transcript fee.
- Fees and dates are for the 2027 ERAS season and 2027 Main Residency Match, with links to where each number came from. Please double-check them in MyERAS, on aamc.org and nrmp.org before relying on totals.
- No program data is included: you add your own programs. The preview images use real program names with sample statuses and numbers.
- The fit score is a personal decision aid, not advice on how to rank.

HOW YOU GET IT
This is a digital download. You'll get one .xlsx file right after purchase. Nothing physical ships. To use it in Google Sheets, upload it to Google Drive and open it with Google Sheets.

Not affiliated with or endorsed by the AAMC, ERAS, or the NRMP. These names are used only to describe what the template tracks.

Created with the help of AI tools; designed, tested and reviewed by the seller.

For personal use. Please don't resell or share the file.