Confetto

Derm Residency Spreadsheet: Data, Signals & Tracker (2027)

Practice the residency interview now

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.

Practice the residency interview now

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.

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 datasets for building a dermatology residency spreadsheet
Official tool or reportFormatRefresh scheduleKey dermatology metrics included
Residency Explorer Program ComparisonSide-by-side generated spreadsheetAnnual cycle update plus mid-August 2026 Interview Likelihood10th 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 VolumeDownloadable 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 VolumeDownloadable 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 ReportsDownloadable Excel and PDFSignals monthly, Signal-to-Interview monthly December to MayNumber of programs participating in signaling, signals received per specialty, and signal-to-interview invitation trends via Thalamus data
NRMP Charting Outcomes and Program Director SurveyInteractive dashboards and downloadable reportsAnnual release11 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.

Recommended columns for a 2-tab Dermatology and PGY-1 tracker
Column groupTab 1: Dermatology and Internal Medicine - Dermatology columnsTab 2: PGY-1 Transitional Year and Internal Medicine columnsWhere to verify the entry
Program identity and position typeProgram name, location, types of positions offered, Dermatology vs. Internal Medicine - DermatologyProgram name, location, linked city or hospital from Tab 1, Transitional Year vs. Internal MedicineERAS 2027 Participating Specialties and Programs, NRMP Main Residency Match Program Directory, and Residency Explorer
Alignment and signalsGeographic preference, medical school or hometown state alignment, program signal assigned, VSLO elective notesGeographic preference, program signal assigned if participating, medical school or hometown state alignmentMyERAS portal, Residency Explorer, and VSLO Participating Host Institutions
Competitiveness checkResidency Explorer Interview Likelihood comparison, interviewee 10th to 90th percentile Step 2 CK or Level 2 CEPrior-cycle interview invitation rate by applicant type, interviewee 10th to 90th percentile score rangeResidency Explorer Program Comparison export
Application verificationConfirmed active in ERAS for 2027, program deadline, required LoR count, supplemental instructionsConfirmed active in ERAS for 2027, program deadline, required LoR countDirect check with program website or coordinator before paying ERAS fees
Interview logisticsInvite status, notification date, live virtual vs. asynchronous vs. in-person format, platform, interview lengthInvite status, notification date, virtual vs. in-person format, date conflicts with Derm interviewsProgram invitation email and scheduling portal
Post-interview rank notesFirst-year resident weekly hours, positions offered and filled, faculty mentorship notes, tentative rankAverage first-year weekly hours, salary and benefits, positions offered and filled, supplemental rank list pairingResidency 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.

Official 2026-27 ERAS and NRMP Match milestones to track
DateOfficial milestoneAction for your derm spreadsheet
June 4, 2026 at 9 a.m. ET2027 ERAS season opens, and US medical schools and CaRMS can begin issuing one-time ERAS tokensLog your ERAS token, import prior-season MyERAS data and LoRs if reapplying within 7 years, and set up your workbook
June 25, 2026ECFMG begins issuing 2027 ERAS tokens for IMGs and Canadian graduates on or after July 1, 2026Confirm ECFMG token registration and check visa sponsorship filters in Residency Explorer
Mid-August 2026Residency Explorer launches its personalized Interview Likelihood featureExport your side-by-side Dermatology and PGY-1 comparison spreadsheet and balance your reach and target mix
September 2, 2026 at 9 a.m. ETResidency applicants may begin submitting MyERAS applications to programsVerify every program on your list is actively participating for 2027 before paying nonrefundable ERAS fees
September 23, 2026 at 9 a.m. ETResidency programs may begin reviewing MyERAS applications and MSPEs in the PDWSFinalize all initial Dermatology, Internal Medicine - Dermatology, and PGY-1 submissions and program signals ahead of 9 a.m. ET
December to MayAAMC refreshes the ERAS Specialty Program Signaling to Interview Dashboard monthly using Thalamus dataTrack macro specialty interview trends alongside your personal interview log
March 15 to 19, 2027NRMP Match Week for the 2027 Main Residency MatchKeep NRMP R3 verification status, primary Dermatology ranks, and supplemental PGY-1 rank lists certified before Match Week
May 31, 2027 at 5 p.m. ET2027 ERAS season endsDownload 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