Pediatric Residency Spreadsheet: 2026-27 Tracker & Setup
Free, no sign-up to start.
How to use the pediatric residency spreadsheet and build your 2026-27 ERAS tracker, with official AAMC, NRMP, and AAP dates, fees, and columns.
Free, no sign-up to start.
A pediatric residency spreadsheet is either the shared Reddit applicant tracker or your own private sheet for comparing programs and interviews. According to the American Academy of Pediatrics, more than 200 programs offer over 2,700 categorical pediatrics positions, with over 97% of applicants matching. Below is how to read crowdsourced trackers safely and how to build your own sheet using 2027 ERAS and NRMP rules. Sources: AAMC ERAS Statistics and Specialty Dashboards, 2027 MyERAS Applicant User Guide, AAMC: What You Need to Know About the 2027 ERAS Application Season. Last checked November 12, 2026.
On this page
- Community spreadsheets vs your own pediatric tracker
- How to read the crowdsourced Reddit spreadsheet safely
- Official interview protections and safe-tracking rules
- Columns to build into your personal pediatric tracker
- Tracking ERAS signals, geographic preferences, and letters
- Key 2026-27 ERAS and NRMP dates to pin in your sheet
- Calculating your pediatric application budget in Excel or Sheets
- Official AAMC and NRMP data files and built-in trackers
- Turning interview notes into your Rank Order List
- Using your spreadsheet to answer "Why our pediatric program?"
- Practice question
- Frequently asked questions
- Sources
Community spreadsheets vs your own pediatric tracker
Medical students use the phrase pediatric residency spreadsheet for both informal public trackers and private personal workbooks during the Match cycle. Your private workbook in Google Sheets or Excel is where you manage your program list, signals, letters, and rank order.
You get the clearest view of your cycle when you keep both tools separate. A public sheet can tip you off when programs start releasing invitations, though self-reported entries are voluntary and unverified. Your private tracker holds the real decisions: where your support network lives, how each hospital trains residents, and how you felt on interview day.
Once invitations arrive, your tracker shifts from sorting applications to preparing for faculty and resident conversations. Confetto runs AI residency mock interviews across traditional, panel, and MMI formats with follow-up questions and rubric feedback. Start your free week.
How to read the crowdsourced Reddit spreadsheet safely
Anyone with an open edit link can type into a community sheet, so treat every entry as an unverified lead rather than official policy. Check useful updates quickly and close the browser before rumor threads waste your afternoon.
Official interview protections and safe-tracking rules
You have formal scheduling protections when interview invitations start appearing on the tracker. Under Section 6.2 of the National Resident Matching Program (NRMP) Match Participation Agreement for Programs, programs must give you at least 48 hours to accept or reject an interview offer. Requiring a 24-hour reply violates Match policy, and programs must extend offers that equal and do not exceed their available interview slots.
Follow this checklist to protect your privacy and keep crowdsourced data in perspective throughout interview season:
- Verify program details directly: Contact individual programs and check their official websites to confirm application deadlines and requirements.
- Never read a blank row as a rejection: Only a small slice of applicants post on public trackers, so zero reports never means zero invites.
- Leave out identifying details: Omit exact away rotation dates, specific faculty mentors, or rare dual-degree backgrounds when posting impressions.
- Check confirmed violations in R3: Open the Institution and Program Violations Report inside the NRMP Registration, Ranking, and Results (R3) system to check formal sanctions.
- Mute open chat tabs before big wave weeks: Filter only for the specific programs on your applied list, then close the file.
Columns to build into your personal pediatric tracker
Generic residency spreadsheets miss the clinical details that make pediatric training feel completely different from hospital to hospital. Caring for children inside a freestanding quaternary children's hospital looks very different from working on a pediatric ward inside an adult medical center.
Build or refine your sheet using the AAMC Residency Explorer tool and the NRMP Program Directory. More than 6,000 PGY-1 and PGY-2 programs participate across the NRMP Main Residency Match, so setting clear pediatric columns early keeps your list focused.
Add a track column if you plan to apply beyond categorical pediatrics. On the AAMC ERAS Statistics specialty list, combined pediatric options include Internal Medicine-Pediatrics, Pediatrics-Emergency Medicine, Pediatrics-Anesthesiology, Pediatrics-Medical Genetics, Pediatrics-Physical Medicine and Rehabilitation, and Pediatrics-Psychiatry-Child and Adolescent Psychiatry.
Include a graduate outcomes column as well, even if you are undecided between general outpatient care and fellowship. ERAS tracks pediatric fellowships across fields including Neonatal-Perinatal Medicine, Pediatric Critical Care Medicine, Pediatric Emergency Medicine, Pediatric Cardiology, Pediatric Hospital Medicine, and Pediatric Hematology/Oncology. Logging whether fellows or categorical residents take first call on procedures tells you how much hands-on autonomy you will gain.
| Column group | Specific columns to add | Why it matters in pediatrics |
|---|---|---|
| Program identifiers | Program name, city, state, ACGME ID, NRMP code, track (Categorical, Primary Care, or Med-Peds/combined) | Stops you from mixing up categorical, primary care, and combined tracks at the same institution. |
| Hospital setting | Freestanding children's hospital vs pediatric floor in adult hospital vs community hospital, urban/suburban/rural | Shapes patient complexity, transfer volume, and alignment with your MyERAS setting preference. |
| Inpatient and ICU acuity | NICU and PICU exposure, pediatric ED volume, fellow coverage, resident procedure ownership | Clarifies whether residents lead intubations, lumbar punctures, and rapid responses or split them with fellows. |
| Continuity and pathways | Continuity clinic schedule, patient language needs, advocacy, community health, or research tracks | Captures your weekly outpatient clinic continuity and longitudinal mentorship structure. |
| Career placement | General outpatient pediatrics vs subspecialty fellowship match destinations, board prep resources | Shows whether recent classes step smoothly into general practice or competitive pediatric fellowships. |
| Support and schedule | Proximity to family or support system, night float vs overnight call, stipends, parking | Tracks daily sustainability and supports the social support narrative in your geographic preferences. |
Tracking ERAS signals, geographic preferences, and letters
Once your target list is drafted, add tracking columns for your 2027 MyERAS application selections. Seeing signals, geographic divisions, and letter assignments in one view prevents costly mistakes before September review begins.
Per the 2027 MyERAS Applicant User Guide, program signals let you express genuine interest at the time of application. While program signaling increases interview invitation probability across participating specialties, it does not guarantee an interview. You should signal your most preferred programs, including your home institution and away rotation sites. Check the AAMC Program Signaling webpage for pediatrics' signal count and the list of participating programs, since MyERAS blocks signals to nonparticipating programs.
MyERAS also includes a Program Signal Explanation option to share mission alignment. Applicants who applied early could edit signals on applied programs until September 23, 2026, at 9 a.m. ET. Signals sent to applied programs locked after that opening timestamp, though unused signals can still go to saved programs later in the season.
Log each program's census division alongside its urban, suburban, or rural setting. In the 2024 ERAS cycle, interview invitation likelihood was higher across participating specialties when an applicant's geographic preference aligned with the program's location than when selecting no division preference.
Add dedicated columns for your letters of recommendation and updated 2027 MyERAS sections:
- Letter submission portal: ERAS accepts all letters of recommendation through the AAMC Letter Writer Portal.
- Pediatric letter mix: Most pediatric programs require 3 faculty letters, including at least 1 from pediatric faculty, per the American Academy of Pediatrics.
- Fourth letter option: A 4th letter documenting research or community work strengthens your application when you have those experiences.
- Request timeline: List potential writers 3 to 4 months early and ask in person at least 3 months ahead.
- Personal statement timeline: Draft 3 to 4 months early, limit each version to 1 page, and log program assignments.
- Scholarly Work update: For 2027, Scholarly Work replaces Publications in MyERAS, allowing unlimited entries and up to 3 Most Meaningful selections.
- Automatic school uploads: Your Designated Dean's Office uploads your MSPE and medical school transcript, which go automatically to all residency programs you apply to.
- Impactful Experiences: Note if you answered this optional obstacles prompt (completed by 56% of residency applicants in 2023), since interviewers may discuss it.
Key 2026-27 ERAS and NRMP dates to pin in your sheet
Create a small calendar block at the top of your tracker so token dates, signal locks, and Rank Order List windows stay visible. Registering in MyERAS does not register you for the Match, so track your ERAS and NRMP accounts as 2 separate tasks.
To open MyERAS, you first get a one-time token from your Designated Dean's Office. Per the AAMC ERAS FAQs, U.S. medical schools and CaRMS (for Canadian graduates before July 1, 2026) can issue tokens starting June 4, 2026, while ECFMG begins issuing tokens on June 25, 2026 for IMGs and Canadian graduates on or after July 1, 2026.
All residency applications submitted between September 2 and September 22 receive the same September 23 date stamp on the program's side. Military scholarship students follow an earlier schedule with military match results released in mid-December.
| Date | Milestone | Action in your spreadsheet |
|---|---|---|
| June 4, 2026 (9 a.m. ET) | 2027 ERAS season opened and U.S. schools began issuing tokens | Log your ERAS token if you have not yet registered. |
| June 25, 2026 | ECFMG began issuing 2027 ERAS tokens for IMGs | Confirm your ECFMG token and document upload status. |
| Sept. 2, 2026 (9 a.m. ET) | MyERAS application submissions opened | Verify letter assignments and personal statements for any newly added programs. |
| September 23, 2026, at 9 a.m. ET | Programs began reviewing files and applied program signals locked | Applied signals are locked, so assign any remaining signals only to saved programs. |
| Mid-December | Military match results are released | Update active civilian program rows if participating in the military match. |
| Mid-January to mid-February | NRMP R3 Rank Order List entry window | Sort interviewed programs in true preference order and certify in R3. |
| After January 29 | NRMP $50 late registration fee applies | Register and pay your $85 NRMP fee before January 29. |
| March 15 to 19, 2027 | 2027 NRMP Main Residency Match Week | Check match status Monday at 11 a.m. ET and celebrate Match Day Friday. |
| May 31, 2027 (5 p.m. ET) | 2027 ERAS season ends | Export and save a copy of your application and workbook records. |
Calculating your pediatric application budget in Excel or Sheets
For the 2027 ERAS season, residency application fees follow a simplified 2-tier rate per specialty: $11 per program for programs 1 through 30, and $30 per program for 31 or more. Fee tiers reset if you apply to an additional specialty, and neither ERAS nor the NRMP issues refunds for any reason.
Paste this formula into Google Sheets or Excel (where cell A2 is your categorical pediatrics program count) to calculate your ERAS application fee automatically: =IF(A2<=30, A2*11, 330+(A2-30) *30). Then add the $85 NRMP standard registration fee, which covers up to 20 unique program codes on your primary rank list and up to 20 on supplemental lists combined.
Add rows for exam transcripts and optional Match fees that fit your situation. DO applicants pay an $80 COMLEX-USA transcript fee once per season in MyERAS, while USMLE transcript requests and fees moved to the Federation of State Medical Boards (FSMB) portal in June 2026. NRMP charges an extra $45 per partner for Couples Match, $30 per unique rank code over 20 (up to 300 maximum ranks), and a length fee starting at $50 for lists of 100 to 150 ranks.
The table below compares combined ERAS application and base NRMP registration costs across 4 sample categorical pediatrics list sizes before sales tax or exam transcript fees. Totals are by our calculation from the 2027 MyERAS Applicant User Guide and NRMP Match Fees schedule.
| Categorical pediatrics programs | ERAS fee math | ERAS subtotal | Total with $85 NRMP base fee |
|---|---|---|---|
| 20 programs | 20 x $11 | $220 | $305 |
| 30 programs | 30 x $11 | $330 | $415 |
| 40 programs | (30 x $11) + (10 x $30) | $630 | $715 |
| 50 programs | (30 x $11) + (20 x $30) | $930 | $1,015 |
Official AAMC and NRMP data files and built-in trackers
Show details
Before relying on forum guesses about competitiveness, pull official spreadsheets and baseline filters from the AAMC and NRMP. On the AAMC ERAS Statistics webpage, you can download Excel files refreshed the first week of every month from July through May. Those workbooks show 5 seasons of applicant and application volumes, cross-specialty counts, and program signal trends, plus historical tables revised in 2026 to reflect pre-SOAP applicants only.
From December through May, the ERAS Specialty Program Signaling to Interview dashboard also updates monthly using interview data from Thalamus. Pair those macro trends with the AAMC Residency Explorer tool's Interview Likelihood feature, which shows how applicants with characteristics like yours fared at individual programs in the prior cycle.
Inside your MyERAS portal, use the Assignments Checklist and Assignments Report under the Programs tab to verify every assigned letter, personal statement, and photo (JPG or PNG up to 150 KB, face centered). Reapplicants can also import certified application entries and letters from up to 7 previous ERAS seasons.
For Match outcomes, check the NRMP Charting Outcomes reports, which shifted from biennial to annual publication on July 28, 2026. Separate reports cover U.S. MD seniors (13 measures), U.S. DO seniors (13 measures), U.S. citizen IMGs (11 measures), and non-U.S. citizen IMGs (11 measures), detailing contiguous pediatric ranks, USMLE Step 2 CK scores, COMLEX-USA Level 2-CE scores, and research, work, and volunteer counts.
Turning interview notes into your Rank Order List
Show details
Once interviews begin in the fall, hide your pre-application columns and open a post-interview tab in your spreadsheet. Jot down concrete observations right after each virtual or in-person session so October interviews stay as clear as January ones.
Record 3 notes right away: how residents interacted when faculty left the room, concrete examples of mentorship or schedule flexibility, and an honest gut rating of how happy you would feel matching there. When you enter your list in the NRMP R3 system between mid-January and mid-February, use these ranking rules:
- Rank strictly in true preference order: The NRMP algorithm is applicant-proposing, meaning it tries to place you into your first choice before checking your second.
- Ignore perceived match odds: Ranking a reach children's hospital first carries zero penalty if that program's list fills before reaching your name.
- Build a balanced competitive spectrum: Include academic reach programs alongside strong mid-range and community pediatric programs so you do not count on SOAP.
- Rank every acceptable program: List every interviewed program where you would rather train than go unmatched, and recertify your list after any change.
- Align paired rows for Couples Match: Partners register separately, pay the $45 per-partner fee, and certify linked lists with the exact same number of pairs.
Using your spreadsheet to answer "Why our pediatric program?"
A detailed pediatric spreadsheet helps you long before Rank Order Lists open because it turns generic interview answers into sharp, specific ones. Saying you love working with children and families will not separate you when every pediatric applicant shares that motivation.
The night before each interview, pull 4 notes from that program's row onto an index card:
- Hospital model: Note whether residents train in a freestanding children's hospital, a children's unit within an academic center, or a community site.
- Clinic and community fit: Reference the continuity clinic structure or patient language mix that connects directly to your clerkships or service work.
- Autonomy and career path: Mention how residents handle floor admissions, rapid responses, or subspecialty exposure in the career path you are considering.
- Geographic or signal tie: State your local family support or regional connection clearly so interviewers understand why you signaled or prioritized them.
- Mock practice out loud: Rehearse tying those 4 points together concisely with Confetto's AI residency mock interviewer. Start your free week.
Practice question
Why did you signal our pediatric residency program, and how does our training environment fit what you want after residency?
See an example answer
"I signaled your program for 2 reasons: your urban continuity clinic model and how much ownership categorical residents keep on inpatient wards. On my pediatrics clerkship and as a Spanish medical interpreter, I saw asthma readmissions stem from missed inhaler teaching and transit gaps. Your longitudinal clinic pairs residents with the same neighborhood panel throughout residency, with social workers and community health workers in the pod. That is the exact outpatient team setup I want to train in. I am also considering pediatric hospital medicine, and here categorical residents run floor admissions and rapid responses directly with the attending. My sister lives 20 minutes from the hospital, so I already have a close support system in the city for busy inpatient blocks. Between the hands-on ward autonomy, the Spanish-speaking clinic panel, and having family nearby, your program fits both my training goals and my life." Example answer written by our team. The applicant is invented.
It names 2 program-specific details in the first sentence instead of speaking about pediatrics in general. Then it connects continuity clinic structure, resident autonomy on wards, and local family support directly to the applicant's clerkship experience and signal.
Frequently asked questions
Where do applicants find the crowdsourced pediatric residency spreadsheet?
Neither the AAMC nor the NRMP publishes or verifies a crowdsourced pediatric residency spreadsheet. Because anyone can edit open community sheets, always confirm participation, deadlines, and requirements directly with each residency program.
Does AAMC or NRMP publish an official pediatric residency spreadsheet?
Neither organization runs an anonymous invite sheet, though the AAMC posts downloadable Excel files of ERAS application and signal volumes refreshed monthly. Inside MyERAS, you can also track every program and document using the built-in Assignments Checklist and Assignments Report.
How long must pediatric residency programs give me to reply to an interview offer?
Under Section 6.2 of the NRMP Match Participation Agreement for Programs, programs must give you no less than 48 hours to accept or reject an offer. Programs must also extend interview invitations that equal, and do not exceed, their total available interview slots.
How much does it cost to apply to pediatric residency programs in the 2027 ERAS cycle?
For the 2027 ERAS season, fees are $11 per program for programs 1 to 30 in a specialty and $30 per program beyond 30. You also pay an $85 standard NRMP registration fee for the Main Residency Match, plus USMLE or $80 COMLEX-USA transcript fees.
How many letters of recommendation should I track per pediatric program in ERAS?
Per the American Academy of Pediatrics, most pediatric residency programs require 3 faculty letters of recommendation, including at least 1 from pediatric faculty, and a 4th letter for research or community work enhances your application. All letters are submitted through the AAMC Letter Writer Portal.
Can I change my pediatric program signals after submitting my MyERAS application?
Applicants who submitted early could update signals on applied programs until September 23, 2026, at 9 a.m. ET. After that opening timestamp, signals on applied programs locked, though you can still assign unused signals to saved programs and apply to additional programs before SOAP.
Sources
- AAMC ERAS Statistics and Specialty Dashboards
- 2027 MyERAS Applicant User Guide
- AAMC: What You Need to Know About the 2027 ERAS Application Season
- AAMC: FAQs for ERAS Residency Applicants
- NRMP Main Residency Match Overview and 2027 Calendar
- NRMP Match Fees
- NRMP Match Data and Charting Outcomes Reports
- NRMP Policies, Interview Rules, and Compliance
- American Academy of Pediatrics: After Interviews, The Match
- American Academy of Pediatrics: The Residency Application Process and Timeline