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.

Next term you’ll chase every form and retype the summary again.
In RosterElf staff set their own availability in the app, and you see it while you build the rota. You publish the finished rota to everyone’s phone, and approved hours go to Xero UK or a CSV.
Your download has started.
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
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:
| Who | What limits their hours |
|---|---|
| Student on a visa | The 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 job | Hours with every employer count together towards the 48-hour weekly average. |
| Zero-hours worker | No 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.
Next week’s rota from this week’s, in one click
For when copying the sheet every week becomes the job.
Save a week as a template and copy it forward
- 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
More rota templates
Working time rules from GOV.UK: maximum weekly working hours and rest breaks at work.
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.