Daycare Waitlist Spreadsheet Template
A ready-to-use spreadsheet for tracking waitlisted families. Pre-built columns for child info, parent contact, application dates, statuses, and priority tiers. Works in Excel and Google Sheets.
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Child Name | Date of Birth | Child Age ƒ | Age Group ƒ | Parent/Guardian | Date Applied | Days Waiting ƒ | Status | Priority | Notes |
| 2 | Charlotte Harris | 09/14/2025 | 0y 6m | Infant | Jessica Harris | 01/10/2026 | 75 | Waitlisted | Standard | Prefers Mon-Fri |
| 3 | Liam Chen | 03/22/2024 | 2y 0m | Toddler | David & Sarah Chen | 01/15/2026 | 70 | Offered | Sibling | Sibling of Mia |
| 4 | Ava Thompson | 11/01/2025 | 0y 4m | Infant | Marcus Thompson | 02/03/2026 | 51 | New | Standard | |
| 5 | Noah Williams | 07/08/2023 | 2y 8m | Preschool | Keisha Williams | 11/20/2025 | 126 | Enrolled | Staff | Staff child |
Download the Template
No signup required. XLSX format with formulas — works with Excel and Google Sheets.
Download Free TemplateIncludes 4 example entries so you can see how it works
What's in the Template
Full name of the child being waitlisted.
Used to determine age group and track when a child will transition to the next classroom.
Auto-calculated from date of birth. Shows current age like "1y 3m" and updates daily.
Auto-suggested from date of birth — Infant, Toddler, Two-Year-Old, Preschool, Pre-K, or School-Age. Adjust if your center uses different cutoffs.
Primary contact name for the family.
For sending updates, offers, and check-ins.
Secondary contact method — useful when spots open quickly.
When the family joined your waitlist. Sort by this column to see your list in order.
Auto-calculated from Date Applied. See at a glance who's been waiting longest — check in with anyone over 90 days.
When the family wants to begin. Helps you match openings to the right families.
New, Waitlisted, Offered, Enrolled, or Withdrawn. Update as families move through your pipeline.
Standard, Sibling, Staff, or Partner. Families with higher priority get offered spots first.
Which room the child is assigned or waitlisted for. Leave blank until placement.
Free-form field for anything else — special needs, scheduling preferences, follow-up reminders.
How to Use It
In Excel: Double-click the downloaded file. It opens directly with all formulas, dropdowns, and formatting intact.
In Google Sheets: Open Google Sheets → File → Import → Upload → select the downloaded file. Choose "Replace spreadsheet" and click Import. Formulas and dropdowns transfer automatically.
Getting started: Delete the example rows and start adding your own families. Sort by "Date Applied" to keep your list in chronological order. Filter by "Age Group" to see demand per classroom. Update "Status" every time you contact or enroll a family.
When Your Spreadsheet Stops Working
This template will get you far. But somewhere around 30-50 families, you'll start running into the same problems every director hits:
- 01Follow-ups fall through the cracks. You mean to check in with waitlisted families every quarter, but there's no reminder. Families go silent because they think you forgot about them.
- 02You can't forecast openings. When a toddler turns 3, that opens a toddler spot and fills a preschool spot. A spreadsheet can't tell you when that cascade will happen across all your classrooms.
- 03Parents call to ask where they are. Every call takes 5-10 minutes. Multiply that by the families who ask every month and you're spending hours answering a question that should answer itself.
- 04Ratio math is manual. Before offering a spot, you need to check your state's staff-to-child ratios, your current enrollment, and your staffing. That's a lot of cross-referencing for every single offer.
Seedlist Handles All of This Automatically
- Automatic check-ins — quarterly still-interested emails go out on their own. Families who don't respond get archived so your list stays clean.
- Enrollment forecasting — see when spots will open based on birthdays, transitions, and kindergarten departures. Plan months ahead instead of reacting.
- Classroom transitions — when a child ages up, Seedlist shows you the cascade: which room gains a spot, which room fills one, and who on the waitlist matches.
- Ratio compliance — your state's staff-to-child ratios are built in. Seedlist only suggests offers that keep you in compliance.
- Parent status portal — families check their own status from their phone. No more calls asking "where are we on the list?"
Not ready for software yet? The spreadsheet is yours — no strings attached.
Download Free TemplateFrequently Asked Questions
What format is the template in?
The template is an XLSX file (Excel format) with built-in formulas, dropdown menus, and formatting. It opens directly in Microsoft Excel and imports into Google Sheets (File → Import → Upload). Formulas for Child Age, Age Group, and Days Waiting calculate automatically.
Can I customize the columns?
Absolutely. The template is a starting point. Add columns for subsidy status, tour date, referral source, or anything else your center tracks. Delete columns you don't need.
How many families can the spreadsheet handle?
Technically, thousands. Practically, most directors find spreadsheets become hard to manage around 30-50 families. At that point, keeping statuses current, sending follow-ups, and tracking transitions across age groups gets time-consuming. That's when purpose-built software like Seedlist starts saving real time.
Is this template really free?
Yes, completely free. No email required, no signup, no strings. Download it and use it however you want.
What's the difference between this and the waitlist policy template?
The policy template is a written document you share with families explaining how your waitlist works (priority rules, communication cadence, offer process). This spreadsheet template is your operational tool for tracking the actual families on your list. You need both — the policy tells families the rules, the spreadsheet helps you follow them.