Applying to pharmacy residencies can quickly become overwhelming. Between ASHP Match deadlines, residency showcases, networking, interviews, Letters of Intent, and comparing programs across specialties, most students end up managing scattered spreadsheets and notes that become difficult to maintain throughout application season.
Designed around the real residency application cycle — not a generic task manager — this six-tab Excel spreadsheet helps you organize residency programs, application progress, networking contacts, interview timelines, rank list decisions, and program research all in one place.
Programs can be scored using customizable weighted criteria so your rankings reflect your personal priorities — not just program prestige. Deadlines automatically flag when dates are approaching, networking, and follow-up tracking helps ensure no contact, resident, or program director outreach slips through the cracks.
Ideal for students pursuing PGY1, PGY2, PGY1/PGY2 Combined, Community-Based, Managed Care, and other ASHP-accredited pharmacy residency training pathways.
Instant digital download following purchase. Open the START HERE tab and begin organizing your residency season in minutes.
Perfect for:
PGY1 applicants
PGY2 applicants
P3 pharmacy students
P4 pharmacy students
Recent PharmD graduates
START HERE Tab — Orientation 6-step quick start guide, ASHP Match calendar timeline, workflow recommendations, and pro tips
Programs Tab — Track up to 75 residency programs with
PGY1 and PGY2 categorization
18 specialty options
ASHP Match ID tracking
Rank list order tracking
Priority tiers
Accreditation tracking
Teaching certificate indicators
13-stage application pipeline
Scoring Tab — Custom weighted scoring system to rank programs based on 10 criteria relevant to your own priorities, including:
Specialty Fit (Area of Practice, PGY2 early commit options, etc)
Preceptor Quality
Program Reputation
Research/Project Opportunities
Geographic Preference
Work-Life Balance
Alumni Outcomes
Application Competitiveness
Auto-calculated composite program score
Tracker Tab — central dashboard for monitoring your residency application pipeline:
Application deadlines
Interview stages
Materials checklist (CV, cover letter, rec letters, transcript)
Match Result (Matched, Unmatched, Scramble)
Days remaining alerts (red at ≤14 days, yellow at ≤30 days)
Contacts Tab — Networking CRM for up to 100 contacts: program directors, preceptors, current residents, faculty mentors, and ASHP Midyear connections; Includes follow-up reminders and outreach tracking
Research Notes Tab — Dedicated program research section for:
Rotation structures
Longitudinal projects
Teaching certificate details
Culture notes
Board pass rates
Letter of Intent preparation
“Why This Program?” essay planning
Delivered as a professionally formatted Excel (.xlsx) spreadsheet compatible with Microsoft Excel and Google Sheets. A Pharmacy Pathways resource — tools and education for pharmacists building careers in pharmacy. All sales are final.
© 2026 Pharmacy Pathways. All rights reserved. This file is licensed for single-user personal use only. Redistribution, resale, sharing, or reproduction in any form is strictly prohibited. One purchase = one user.
Applying to pharmacy residencies can quickly become overwhelming. Between ASHP Match deadlines, residency showcases, networking, interviews, Letters of Intent, and comparing programs across specialties, most students end up managing scattered spreadsheets and notes that become difficult to maintain throughout application season.
Designed around the real residency application cycle — not a generic task manager — this six-tab Excel spreadsheet helps you organize residency programs, application progress, networking contacts, interview timelines, rank list decisions, and program research all in one place.
Programs can be scored using customizable weighted criteria so your rankings reflect your personal priorities — not just program prestige. Deadlines automatically flag when dates are approaching, networking, and follow-up tracking helps ensure no contact, resident, or program director outreach slips through the cracks.
Ideal for students pursuing PGY1, PGY2, PGY1/PGY2 Combined, Community-Based, Managed Care, and other ASHP-accredited pharmacy residency training pathways.
Instant digital download following purchase. Open the START HERE tab and begin organizing your residency season in minutes.
Perfect for:
PGY1 applicants
PGY2 applicants
P3 pharmacy students
P4 pharmacy students
Recent PharmD graduates
START HERE Tab — Orientation 6-step quick start guide, ASHP Match calendar timeline, workflow recommendations, and pro tips
Programs Tab — Track up to 75 residency programs with
PGY1 and PGY2 categorization
18 specialty options
ASHP Match ID tracking
Rank list order tracking
Priority tiers
Accreditation tracking
Teaching certificate indicators
13-stage application pipeline
Scoring Tab — Custom weighted scoring system to rank programs based on 10 criteria relevant to your own priorities, including:
Specialty Fit (Area of Practice, PGY2 early commit options, etc)
Preceptor Quality
Program Reputation
Research/Project Opportunities
Geographic Preference
Work-Life Balance
Alumni Outcomes
Application Competitiveness
Auto-calculated composite program score
Tracker Tab — central dashboard for monitoring your residency application pipeline:
Application deadlines
Interview stages
Materials checklist (CV, cover letter, rec letters, transcript)
Match Result (Matched, Unmatched, Scramble)
Days remaining alerts (red at ≤14 days, yellow at ≤30 days)
Contacts Tab — Networking CRM for up to 100 contacts: program directors, preceptors, current residents, faculty mentors, and ASHP Midyear connections; Includes follow-up reminders and outreach tracking
Research Notes Tab — Dedicated program research section for:
Rotation structures
Longitudinal projects
Teaching certificate details
Culture notes
Board pass rates
Letter of Intent preparation
“Why This Program?” essay planning
Delivered as a professionally formatted Excel (.xlsx) spreadsheet compatible with Microsoft Excel and Google Sheets. A Pharmacy Pathways resource — tools and education for pharmacists building careers in pharmacy. All sales are final.
© 2026 Pharmacy Pathways. All rights reserved. This file is licensed for single-user personal use only. Redistribution, resale, sharing, or reproduction in any form is strictly prohibited. One purchase = one user.
