UK
Start trial
Free template· UK, Excel, opens in Google Sheets

Free staff availability template (Excel)

A staff availability template collects when each person can work before you write the rota. This one has a form per person, with morning, afternoon and evening for seven days marked Available, Preferred or Unavailable, a weekly hours cap and a valid-from date, plus a team summary that puts everyone on one grid.

rosterelf-uk-employee-availability.xlsx
The team availability summary filled in for six staff, each marked Available, Preferred or Unavailable by session

File checked No signup

The download

What’s in the file

  • An Availability Form tab: morning, afternoon and evening for each day
  • Drop-downs for Available, Preferred or Unavailable
  • A Team Summary tab: everyone on one grid, with max hours a week
  • An Instructions tab with shift codes and working time reminders
Download Excel (.xlsx)
Only on this page

Why the max-hours column matters in the UK

It is the column people skip and then need. Four cases where a weekly cap changes the rota before it is published:

WhoWhat limits their hours
Student on a visaThe visa’s term-time work limit, often 20 hours a week at degree level. Check their visa conditions.
Under-18 (over school leaving age)8 hours a day and 40 a week, with no averaging and no opt-out.
Someone with a second jobHours with every employer count together towards the 48-hour weekly average.
Zero-hours workerNo guaranteed hours, and availability is not an acceptance of any shift offered.

Keep notes behind an Unavailable slot factual and short: caring responsibilities or health details can be special category data under UK GDPR.

In RosterElf

Next week’s rota from this week’s, in one click

For when copying the sheet every week becomes the job.

A café worker beside RosterElf’s Select a roster to copy panel, with last week’s roster ready to copy

Save a week as a template and copy it forward

Any weekCopy last weekStaff app
  • Save any rota as a reusable template
  • Copy last week’s rota instantly
  • Clone individual shifts across days
  • Staff see their shifts on the iPhone and Android app
FAQ

Staff availability FAQ

  • It depends entirely on the contract. A contract with fixed or minimum hours can specify when they are worked; a zero-hours contract cannot compel availability, and an exclusivity clause in one is unenforceable. Collecting availability is a planning exercise, not a way of creating an obligation that the contract does not.

  • Every term for a student-heavy team, quarterly otherwise, and always before a seasonal peak. The valid-from date exists so a stale form is visibly stale rather than quietly wrong.

  • No, and conflating the two is the most common mistake. Availability says a person could work; it is not an acceptance and, for a zero-hours worker, not an agreement to work. Keep offers and acceptances in the zero-hours rota.

  • You need a lawful basis to hold them, normally legitimate interests, and should keep them no longer than necessary. Notes about caring responsibilities or health can be special category data, so keep the notes field factual and minimal. See our employee records and UK GDPR guide.

  • Yes. Upload the .xlsx to Google Drive and open it with Google Sheets: the layout and the formulas carry over. It works in LibreOffice Calc too.