Free template

Hotel Staff Roster

Plan a week of morning (M), evening (E), night (N) shifts and weekly offs (O) for front office, housekeeping, F&B and maintenance, with automatic counts of shifts and offs per person.

Free, no sign-up. Works in Excel, Google Sheets and LibreOffice. Columns marked “auto” are formulas.

Preview

DepartmentEmployeeMonTueWedThuFriSatSunShiftsOffs
Front officeNehaMMEEONNautoauto
Front officeVikramEEOMMMEautoauto
HousekeepingSunitaMMMOMMMautoauto
F&BArjunEOEEEEMautoauto

How to use this template

  • Avoid a night shift followed by a morning shift the next day.
  • Plan housekeeping strength from forecast departures, not just occupancy.

Related tools and templates