Holiday Guests Planner Spreadsheet, Houseguest Room and Bed Assignments, Airport Pickup Schedule, Who Stays Which Night, Google Sheets

Family and friends coming to stay for the holidays? Plan who sleeps where and when: every arrival, every bed, every airport run, and a clear view of who is staying each night.

WHAT YOU GET
• Travel list for up to 25 parties: arrival and leaving dates and times, flight or train number, where they arrive, and whether they need a pickup or a drop-off
• Guest list for up to 80 people with party, age, bed, dietary notes, and dates that come from their party or their own
• Rooms and beds: every bed, sofa bed, air mattress and crib, how many it sleeps, who's in it and whether it's overbooked
• Who's staying each night: a guest-by-guest grid for up to 21 nights with sleeping over, adults, kids, arrivals, departures and spots left
• Bed plan: each bed night by night, with clashes in red
• Rides: every airport, train and bus pickup and drop-off in date order, with the time to leave home and the time you'll be back
• Prep list of 20 jobs to get the house ready, dated back from the first arrival
• Dashboard with days to the first arrival, the busiest night, spots left and what needs attention

HOW IT WORKS
1. Add your beds on Rooms and your drive times to the airport and station on Settings.
2. Add each party's travel, then each guest with their party and bed.
3. Check Nights, Bed Plan and Rides, and work through Prep. The Dashboard shows what needs attention.

FEATURES
• A guest sleeps over every night from the day they arrive to the night before they leave
• Spots left each night, and a flag on nights with more guests than beds
• A bed booked for more people than it sleeps is flagged on Rooms, Guests and Nights
• Leave-home times from your own drive and wait times for each place
• Two rides to the same place close together are flagged so one trip can cover both
• Flags for guests with no bed, missing dates, rides with no driver and beds not made up
• Prefilled prep jobs and places you can edit
• Clean, printable layout

WORKS WITH
• Microsoft Excel (desktop or Microsoft 365)
• Google Sheets (free with a Google account)
• Apple Numbers
• LibreOffice
Best on a computer or tablet.

WHAT YOU RECEIVE
• Holiday Houseguest Planner - Blank.xlsx, ready for your houseguests
• Holiday Houseguest Planner - Sample.xlsx, filled with example data so you can see how it works
• A quick start guide (PDF)
This is a digital download. Nothing is shipped, and the files are yours to keep. For personal use.

HOW WE MAKE IT
Every Toast & Tally planner is designed in-house with AI-assisted tools, then every tab, formula and sample file is checked and tested before it is listed.

QUESTIONS?
Message us on Etsy. We're happy to help you get set up.