Derm Residency Spreadsheet: Data, Signals & Tracker (2027)
Free, no sign-up to start.
Build your 2027 derm residency spreadsheet using Residency Explorer comparisons, AAMC ERAS Excel files, NRMP Match metrics, and our PGY-1 tracker layout.
Free, no sign-up to start.
The derm residency spreadsheet usually refers to either the anonymous crowdsourced Google Sheet shared in student forums or a personal program tracker built from verified national data. Instead of relying on anonymous posts alone, you can generate an automated side-by-side program comparison spreadsheet in the AAMC's Residency Explorer tool, backed by 9 national organizations, and pair it with monthly downloadable AAMC ERAS Statistics Excel files. Sources: AAMC: Residency Explorer Tool, AAMCNews: Applying to residency? The Residency Explorer tool can help, AAMC: ERAS Statistics and Downloadable Excel Reports. Last checked November 12, 2026.
On this page
- Crowdsourced derm spreadsheets vs. official comparison sheets
- How to export an official dermatology spreadsheet in Residency Explorer
- Downloadable AAMC ERAS Statistics Excel files for dermatology
- How to set up your personal derm and PGY-1 applicant tracker
- Tracking program signals, geographic preferences, and interview invites
- 2026-27 ERAS and NRMP Match dates for your spreadsheet
- How to read community spreadsheets without falling for false entries
- Turning your spreadsheet notes into residency interview prep
- Practice question
- Frequently asked questions
- Sources
Crowdsourced derm spreadsheets vs. official comparison sheets
Every application cycle, dermatology applicants pass around collaborative community Google Sheets in student forums and specialty interest groups to log program signaling policies, away rotation impressions, virtual or in-person interview formats, and live interview invitation dates. Those community sheets move fast during interview season, yet anyone with the link can edit or delete cells without verification.
When the Association of American Medical Colleges (AAMC) interviewed students while building Residency Explorer, William Mallon, EdD, reported in a June 29, 2020 AAMCNews article that students struggled to find one source with everything they needed because prior residency information was scattered and unreliable. In the same report, former AAMC Organization of Student Representatives chair David Bernstein, MD, MBA pointed to the volume of unverified data circulating among applicants.
A smart dermatology residency spreadsheet setup separates verified facts from anonymous chatter. Build your master workbook from official exports first, using Residency Explorer for program-level score ranges and interview rates, AAMC ERAS Excel files for application and signal counts, and National Resident Matching Program (NRMP) reports for matched applicant baselines. Keep community forum logs as a secondary check for when interview waves start going out, never as your sole source for cutoffs or signaling rules.
Once your target list turns into interview invitations, Confetto helps you practice live virtual and asynchronous recorded residency interview questions out loud with follow-up probing and rubric-based feedback. Start your free week.
- Use Residency Explorer to export a verified side-by-side program comparison spreadsheet with 10th and 90th percentile interviewee exam scores.
- Use AAMC ERAS Statistics Excel downloads to check specialty application totals, program signal volumes, and cross-specialty PGY-1 volume.
- Use NRMP Charting Outcomes and Program Director Survey reports to benchmark research, work, and volunteer counts alongside ranking factors.
- Confirm specialty signaling caps, supplemental rules, and coordinated interview release dates directly in the MyERAS portal and on each program's admissions website.
How to export an official dermatology spreadsheet in Residency Explorer
If you want a clean dermatology residency program comparison without copying rows off dozens of hospital websites, start inside the Residency Explorer tool. According to the AAMC, you can select multiple residency programs and let the tool generate a spreadsheet showing side-by-side comparisons across verified program metrics.
All 9 national transition-to-residency organizations support the database, including the AAMC, ACGME, AMA, NBME, NBOME, and NRMP. Every program characteristic, position count, and exam figure comes directly from those primary organizations.
Beginning in mid-August 2026, Residency Explorer also adds a personalized Interview Likelihood feature. It compares your profile against applicants who received interview invitations at individual residency programs during the previous application cycle so you can balance reach and target programs before certifying MyERAS.
- Licensing exam score ranges: 10th and 90th percentile USMLE Step 2 CK and COMLEX-USA Level 2 CE scores among applicants invited to interview at that program in the prior cycle.
- Interview invitation rates by applicant context: prior-cycle invite rates broken down by applicant type (MD, DO, US IMG, and Non-US IMG), program signaling, medical school state alignment, hometown state alignment, and geographic preference.
- Exam attempt history: program-level interview invitation data filtered by whether USMLE Step 1, USMLE Step 2 CK, COMLEX-USA Level 1, or COMLEX-USA Level 2 CE was ever failed.
- Applicant and invitee composition: how the overall pool of applicants compares with the subset invited to interview at each site.
- Training environment and logistics: positions offered and filled from the NRMP, visas accepted or sponsored, salary and benefits, resident demographics, and average weekly hours worked by a first-year resident.
Downloadable AAMC ERAS Statistics Excel files for dermatology
Alongside program-by-program comparisons, the AAMC publishes free downloadable Excel workbooks and PDF reports on its ERAS Statistics page. These dashboards cover 5 seasons, defined as the current season plus the 4 most recent prior seasons, with each ERAS season running from the beginning of June to May 31.
The AAMC refreshes its volume and signaling dashboards during the first week of every month, pauses updates on May 31, and resumes when the July cycle opens. Use Latest Day in Cycle on the Point-in-Time filter to compare your cycle against the same point in prior years, or select End of Cycle to compare against final prior-season outcomes. ERAS Statistics are pre-Match only and exclude Supplemental Offer and Acceptance Program (SOAP) activity, and starting with the 2026 release, the Historical Specialty-Specific Data Tables for the 2022 to 2026 seasons also include only pre-SOAP applicants.
In the ACGME Residency specialty dropdown, the AAMC tracks Dermatology, Internal Medicine - Dermatology, Internal Medicine, and Transitional Year as distinct entries by applicant and by program. Downloading both the volume Excel sheet and the cross-specialty Excel sheet lets you see how many dermatology applicants also apply to Transitional Year, Internal Medicine, or a backup specialty.
| Official tool or report | Format | Refresh schedule | Key dermatology metrics included |
|---|---|---|---|
| Residency Explorer Program Comparison | Side-by-side generated spreadsheet | Annual cycle update plus mid-August 2026 Interview Likelihood | 10th and 90th percentile Step 2 CK and Level 2 CE interviewee ranges, invite rates by signal and state ties, visas, positions filled |
| ERAS Residency Applicant and Application Volume | Downloadable Excel (November 5, 2026 release for 2023-2027) | First week of each month (paused May 31 to July) | Pre-Match number of applicants and applications submitted across Dermatology, Internal Medicine - Dermatology, and Transitional Year |
| ERAS Residency Cross-Specialty Application Volume | Downloadable Excel (2027 season) | First week of each month (paused May 31 to July) | Exact overlap counts of applicants applying to both specialty X and specialty Y, including SOAP counts in historical cross-specialty files |
| ERAS Program Signals and Thalamus Interview Reports | Downloadable Excel and PDF | Signals monthly, Signal-to-Interview monthly December to May | Number of programs participating in signaling, signals received per specialty, and signal-to-interview invitation trends via Thalamus data |
| NRMP Charting Outcomes and Program Director Survey | Interactive dashboards and downloadable reports | Annual release | 11 to 13 matched applicant measures including contiguous ranks, Step 2 CK, research, work, and volunteer counts, plus PD selection factors |
How to set up your personal derm and PGY-1 applicant tracker
NRMP's Main Residency Match covers over 6,000 PGY-1 and PGY-2 programs, and AAMC ERAS Statistics tracks Dermatology, Internal Medicine - Dermatology, Internal Medicine, and Transitional Year as separate specialty entries. Keeping your dermatology list and your PGY-1 Internal Medicine or Transitional Year list in disconnected files creates scheduling headaches once interviews arrive.
Build one workbook with 2 linked tabs: Tab 1 for Dermatology and Internal Medicine - Dermatology programs, and Tab 2 for Transitional Year and Internal Medicine PGY-1 programs in the same cities or hospital systems.
Before adding dozens of extra rows out of fear, weigh the AAMC research discussed with University of Southern California vice dean Donna Elliott, MD, EdD in AAMCNews. Students pursuing competitive subspecialties apply to as many as 120 residency programs. Yet AAMC research shows a point, depending on specialty and testing scores, where extra applications stop increasing your chances of matching, so limiting your list saves time, money, and administrative hassle.
| Column group | Tab 1: Dermatology and Internal Medicine - Dermatology columns | Tab 2: PGY-1 Transitional Year and Internal Medicine columns | Where to verify the entry |
|---|---|---|---|
| Program identity and position type | Program name, location, types of positions offered, Dermatology vs. Internal Medicine - Dermatology | Program name, location, linked city or hospital from Tab 1, Transitional Year vs. Internal Medicine | ERAS 2027 Participating Specialties and Programs, NRMP Main Residency Match Program Directory, and Residency Explorer |
| Alignment and signals | Geographic preference, medical school or hometown state alignment, program signal assigned, VSLO elective notes | Geographic preference, program signal assigned if participating, medical school or hometown state alignment | MyERAS portal, Residency Explorer, and VSLO Participating Host Institutions |
| Competitiveness check | Residency Explorer Interview Likelihood comparison, interviewee 10th to 90th percentile Step 2 CK or Level 2 CE | Prior-cycle interview invitation rate by applicant type, interviewee 10th to 90th percentile score range | Residency Explorer Program Comparison export |
| Application verification | Confirmed active in ERAS for 2027, program deadline, required LoR count, supplemental instructions | Confirmed active in ERAS for 2027, program deadline, required LoR count | Direct check with program website or coordinator before paying ERAS fees |
| Interview logistics | Invite status, notification date, live virtual vs. asynchronous vs. in-person format, platform, interview length | Invite status, notification date, virtual vs. in-person format, date conflicts with Derm interviews | Program invitation email and scheduling portal |
| Post-interview rank notes | First-year resident weekly hours, positions offered and filled, faculty mentorship notes, tentative rank | Average first-year weekly hours, salary and benefits, positions offered and filled, supplemental rank list pairing | Residency Explorer snapshot and your same-day interview debrief notes |
Tracking program signals, geographic preferences, and interview invites
Since the 2024 ERAS season, residency applicants have been able to send program signals to participating programs to express formal interest at submission. For the 2027 MyERAS season, all residency applicants applying to participating programs can use program signals, and the AAMC's 2027 Residency Program Signal Report tracks how many programs receive signals in each specialty.
Keep a dedicated column in your spreadsheet for signal status and geographic alignment, because programs weigh them heavily at different stages. On October 14, 2026, the NRMP released 3 multi-cycle research reports drawing on NRMP, AAMC, and NBME data. Its signaling study covering the 2023 to 2026 Match cycles found that for applicants, signaling was most consistently related to being ranked by a program, though that relationship varied meaningfully by specialty and signaling structure.
A companion NRMP and NBME study examining rank order lists across 21 specialties from 2022 to 2025 showed that program ranking patterns differed most by applicant type, sex, and licensure exam performance, with substantial variation from one program to another inside the same specialty. Rather than trusting anonymous forum rules of thumb about signal yield or score cutoffs, check each program's prior-cycle invite rate by program signal and geographic preference inside Residency Explorer, and confirm current dermatology signaling rules and interview release dates in the MyERAS portal and on specialty program websites.
2026-27 ERAS and NRMP Match dates for your spreadsheet
Lock official deadlines into the top rows of your tracker before you start sorting programs. Applicants may begin submitting MyERAS applications on September 2, 2026 at 9 a.m. ET, and residency programs may begin reviewing MyERAS applications and Medical Student Performance Evaluations (MSPEs) in the Program Director's WorkStation (PDWS) on September 23, 2026 at 9 a.m. ET. Use that 3-week window to finalize your signal assignments and verify every program's participation status rather than rushing an unvetted list on opening morning.
Watch out for 2 administrative rules stated in the AAMC's ERAS FAQs. First, ERAS does not issue refunds for any reason, including applications sent to nonparticipating programs that initially signed up for ERAS and later withdrew without notifying ERAS staff. Confirm participation directly with every program before paying by Visa, MasterCard, American Express, or Discover. Second, registering and submitting through MyERAS does not register you for the NRMP Match. ERAS is strictly a document delivery service, so add a separate checklist row for NRMP registration and signing the electronic 2027 Match Participation Agreement.
| Date | Official milestone | Action for your derm spreadsheet |
|---|---|---|
| June 4, 2026 at 9 a.m. ET | 2027 ERAS season opens, and US medical schools and CaRMS can begin issuing one-time ERAS tokens | Log your ERAS token, import prior-season MyERAS data and LoRs if reapplying within 7 years, and set up your workbook |
| June 25, 2026 | ECFMG begins issuing 2027 ERAS tokens for IMGs and Canadian graduates on or after July 1, 2026 | Confirm ECFMG token registration and check visa sponsorship filters in Residency Explorer |
| Mid-August 2026 | Residency Explorer launches its personalized Interview Likelihood feature | Export your side-by-side Dermatology and PGY-1 comparison spreadsheet and balance your reach and target mix |
| September 2, 2026 at 9 a.m. ET | Residency applicants may begin submitting MyERAS applications to programs | Verify every program on your list is actively participating for 2027 before paying nonrefundable ERAS fees |
| September 23, 2026 at 9 a.m. ET | Residency programs may begin reviewing MyERAS applications and MSPEs in the PDWS | Finalize all initial Dermatology, Internal Medicine - Dermatology, and PGY-1 submissions and program signals ahead of 9 a.m. ET |
| December to May | AAMC refreshes the ERAS Specialty Program Signaling to Interview Dashboard monthly using Thalamus data | Track macro specialty interview trends alongside your personal interview log |
| March 15 to 19, 2027 | NRMP Match Week for the 2027 Main Residency Match | Keep NRMP R3 verification status, primary Dermatology ranks, and supplemental PGY-1 rank lists certified before Match Week |
| May 31, 2027 at 5 p.m. ET | 2027 ERAS season ends | Download and save copies of your application records and spreadsheet notes before the portal closes |
How to read community spreadsheets without falling for false entries
Show details
Crowdsourced Reddit and Discord trackers attract heavy traffic on days when dermatology interview invitations go out, which also makes them targets for prank entries, inflated score claims, and anxious speculation. You do not have to boycott community sheets to stay level-headed, provided you filter what you read against primary data.
On July 28, 2026, the NRMP shifted its Charting Outcomes: Characteristics of Applicants Who Match to Their Preferred Specialty series from a biennial schedule to an annual release, publishing separate reports for US MD seniors, US DO seniors, US citizen IMGs, and non-US citizen IMGs. Depending on the applicant group, those reports examine 11 to 13 measures, including contiguous ranks in your preferred specialty, distinct specialties ranked, USMLE Step 2 CK or COMLEX-USA Level 2-CE scores, and counts of research, work, and volunteer experiences. When an anonymous row on a forum sheet claims a program only interviews applicants above a sky-high score, test that claim against Residency Explorer's verified 10th percentile interviewee score before panicking.
- Verify single-post invite rumors: wait until multiple independent timestamps or your own Thalamus or MyERAS inbox confirm an invitation wave, and remember programs review files on different schedules.
- Protect your anonymity if you contribute: posting your exact Step 2 CK score, medical school state, away elective site, program signal, and invite date on one public line makes it easy for peers or faculty to identify you.
- Know NRMP interview communication boundaries: per NRMP Help and Support policies, program directors and faculty are not permitted to ask you about other programs where you applied or how you plan to rank programs.
- Separate personal rank criteria from anonymous venting: record your own post-interview impressions right after each session using the August 26, 2026 NRMP Program Director Survey and September 17, 2026 NRMP Applicant Survey reports to frame what matters to you.
- Plan ahead if reapplying: NRMP's October 6, 2026 Matched, Unmatched, and Beyond report covering 2022 to 2025 showed that most applicants who did not secure a position in their first Match returned to the Match and the majority subsequently obtained a residency position.
Turning your spreadsheet notes into residency interview prep
Show details
A good derm residency spreadsheet stops being an application counter in November and becomes your interview briefing sheet. The AAMC's Virtual Interviews: Applicant Preparation Guide notes that virtual residency interviews fall into 2 formats: Live Virtual Interviews conducted face-to-face over video conference, and Asynchronous Virtual Interviews where you record webcam answers to text or prerecorded video prompts without an interviewer present.
Across both formats, the AAMC groups typical residency questions into 3 categories: Behavioral questions asking for a specific past situation, action, and outcome, General questions such as why you are interested in the program, and Situational questions asking what you would do in a hypothetical team or clinical scenario, such as a chief resident giving you sole credit on morning rounds for a difficult case a colleague helped manage.
Log the interview format, video platform, number of interviewers, interview length, and assessed competencies in your spreadsheet as soon as each invitation arrives. When rehearsing clinical examples from dermatology clinics or away rotations, follow the AAMC's strict confidentiality rule: never share names, locations, diagnoses, or combinations of details that could identify a patient or portray an identifiable colleague negatively, and refer to any patient simply as the patient.
Run your technology check on a computer or tablet rather than a phone that can accept interrupting calls, switch to wired Ethernet if Wi-Fi lags, place your light source in front of you with the camera at eye level, and shut down notification apps. To practice behavioral, general, and situational dermatology interview prompts on camera with realistic follow-ups, try Confetto. Start your free week.
Practice question
Tell me why you are interested in our dermatology residency program, and share a clinical experience that shaped what you are looking for in your training.
See an example answer
I am drawn to your program because my clinical research and third-year clerkships taught me that I want high-volume complex medical dermatology paired with longitudinal care for uninsured and Spanish-speaking patients. During my internal medicine rotation, I helped care for a patient admitted with a severe, painful drug eruption after starting a new anticonvulsant without outpatient follow-up. Because I speak Spanish, I sat down with the patient without rushing to piece together the exact medication timeline and coordinate bedside teaching with the inpatient dermatology consult resident. Watching that resident calm the family, perform the biopsy at the bedside, and arrange a bridge visit in your hospital's outpatient dermatology safety-net clinic showed me how closely inpatient consults and continuity clinics need to work together. When I compared programs this summer, your dedicated inpatient consult service, resident continuity clinic structure, and faculty mentorship in complex medical dermatology stood out right away. That combination matches the hospital-based clinician and educator I want to become. Example answer written by our team. The applicant is invented.
It answers both halves of a classic General and Behavioral residency prompt in under 90 seconds. The speaker connects specific training features from their program research spreadsheet to one concrete clinical action and outcome, while following the AAMC Virtual Interviews rule to keep the patient completely de-identified as 'the patient.'
Frequently asked questions
Can I export an official spreadsheet to compare dermatology residency programs?
Yes. Inside the Residency Explorer tool, backed by 9 national organizations, you can select multiple dermatology programs and generate a side-by-side comparison spreadsheet covering verified interviewee exam score percentiles, invitation rates by signal and state alignment, visa sponsorship, and resident work hours.
Where do I get official dermatology ERAS application and signaling Excel files?
The AAMC publishes free downloadable Excel files on its ERAS Statistics page, refreshed during the first week of every month from July through May. Current downloads include 2023-2027 Residency Applicant and Application Volume, 2027 Cross-Specialty Application Volume, and the 2027 Residency Program Signal Report.
How does program signaling affect residency ranking and interview outcomes?
NRMP's multi-cycle signaling report covering the 2023 to 2026 Match seasons found that program signaling was most consistently related to being ranked by programs, though effects varied meaningfully by specialty and signal structure. You can check prior-cycle interview invitation rates by program signal for individual dermatology programs inside Residency Explorer.
When do dermatology residency programs start reviewing 2027 MyERAS applications?
Applicants can begin submitting MyERAS applications on September 2, 2026 at 9 a.m. ET, and residency programs may begin reviewing applications and MSPEs on September 23, 2026 at 9 a.m. ET.
Does submitting applications in ERAS register me for the NRMP Match?
No. AAMC policy states that ERAS is a separate document delivery system and does not register you for the NRMP Main Residency Match or any other matching service. You must register separately with the NRMP and sign the electronic 2027 Match Participation Agreement ahead of Match Week from March 15 to 19, 2027.
Sources
- AAMC: Residency Explorer Tool
- AAMCNews: Applying to residency? The Residency Explorer tool can help
- AAMC: ERAS Statistics and Downloadable Excel Reports
- AAMC: 2027 ERAS Residency Timeline
- AAMC: Apply to Residencies with the ERAS System
- AAMC: FAQs for ERAS Residency Applicants
- AAMC: Virtual Interviews Applicant Preparation Guide
- NRMP: National Resident Matching Program Main Match
- NRMP: Data Reports and Program Signaling Research
- NRMP: Match Data and Charting Outcomes
- NRMP: Match Participation Agreements and Policies
- NRMP: Help and Support for Main Residency Match Applicants