Hotel housekeeping schedule template.
A weekly schedule for room attendants, housepersons and supervisors. Type the rooms each day brings and how many rooms one attendant cleans in a shift, and the sheet works out how many attendants that day needs – then shows whether the week you have written covers it.
Free, no email required. Made for Excel and Google Sheets (File → Import).
What is in the file
- The week – a row per person with their job title, a column per day, and a drop-down list of your shifts in every cell.
- Rooms to clean – one line for the rooms each day brings, departures and stayovers together, and one cell for the rooms an attendant cleans in a shift at your hotel. The sheet divides the first by the second and rounds up to whole people.
- Who you need each day – room attendants from the line above, plus the housepersons and the supervisor you type in. Under each, the number scheduled: "4 of 5" means one attendant short.
- Weekly hours – per person, from the paid hours of each shift, with anyone above the number at the top of the sheet marked.
- A blank week to print – the PDF is the same grid without the example.
How to use it
- Replace the example team with yours. Write each job title the same way on every row: the count of room attendants looks at the job title column.
- From your arrivals and departures for the week, type the rooms to clean on each day.
- Type how many rooms one attendant cleans in a shift at your hotel: your own standard, or the number in your union agreement if you have one. The 14 in the file is only an example.
- Pick each person's shift for each day from the list in the cell.
- Read the lines marked "scheduled". In the example week, Saturday reads 4 of 5 for room attendants: 62 rooms at 14 rooms each need five people, and four are scheduled.
- Adjust and read again: move a day off, add a shift for a part-time attendant, or change the rooms when the forecast moves.
What a housekeeping schedule has to get right
Rooms set the day, not the calendar
A Tuesday with 38 rooms to clean and a Saturday with 62 are different days. A schedule that repeats the same headcount all week is short on one of them or has more people than the work on the other. That is why this template starts from rooms.
A departure is more work than a stayover
If the mix of departures and stayovers changes a lot from day to day, count a departure as more than one room when you fill in the rooms line, with a weight that matches how long it takes at your hotel. The attendants needed then follow the work, not the room count.
Some jobs do not follow the room count
A houseperson for linen and public areas in the morning, one for the evening, a supervisor on every day: these are needed whether the hotel is half full or full. In the file they are typed in as fixed numbers, next to the room attendants that follow the rooms.
Hand the open rooms to the evening shift
Late departures, rooms asked not to be disturbed, a room waiting on maintenance: the evening shift needs that list from the day shift. The shift handover template is a one-page form for it.
Hotels in New York
New York State adds its own rules on a weekly day of rest, meal periods, long days and short shifts. They are set out in plain words, each with its source, in New York rules on hours and rest.
Common questions
How many rooms should one room attendant clean in a shift?
The template does not set that number, because it depends on your rooms, your standards and, where there is one, your union agreement. Type the number your hotel works to. The 14 in the example is only there to show the calculation.
How do I plan for a day with many departures?
Count each departure as more than one room when you fill in the rooms line, using a weight that matches how long a departure takes at your hotel. The number of attendants needed for that day rises with it.
Can I add laundry or public area attendants to the same sheet?
Yes. Add their rows to the week, add their shift to the shift list if it is a different one, and add a line under "Who you need each day" with their job title and shift. The count follows the job title.
Does it work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets, or use File → Import inside a sheet. The file uses drop-down lists, highlighted cells and the COUNTIF family of functions, all of which Google Sheets has.
When the template stops being enough
A spreadsheet holds one week at a time, and the next week starts with typing again. It also shows a short day only to the person who has the file open.
In Schedio you set once how many room attendants, housepersons and supervisors each day needs, with a separate setting for busy dates such as a holiday weekend or a group arrival. The schedule then marks every day that is short, an open shift can be offered to the team, and each attendant gets their own week by email, in Telegram or in WhatsApp, in their own language. Housekeeping and the front desk are two departments of the same hotel, at $49 a month for the hotel.
No card · first month free · cancel anytime · plus tax at checkout