Free template· Excel, plus a printable PDF form

Free employee availability template (Excel)

An employee availability template records when each person can work: every day of the week with yes or no, earliest start, latest finish, preferred and maximum hours, and dates they are away. Staff fill in one form each; the team summary sheet puts everyone’s answers side by side so you can roster around them.

rosterelf-employee-availability.xlsx
The employee availability template’s team summary filled in for a six-person cafe: Y, N, P or I for each day, with preferred and maximum weekly hours

File checked No signup

How to

What to ask, and how to roster from the answers

The Excel file has a form for each employee and a team summary for you. The PDF is the same form on one page, to print and hand out. Either way, the answers are only useful if you ask the right things and collect them in time.

Ask for limits, not just days

For each day: available or not, earliest start and latest finish. Then preferred and maximum weekly hours, and any dates away. “Free on Saturday” is not enough if they must leave by 2pm.

Use the four answers consistently

Y (yes), N (no), P (preferred) and I (if needed). P tells you where to put someone first; I is your back-up list for gaps.

Set a cut-off before you build the roster

For example Friday 5pm for the week after next. Late answers go into the following roster, so nobody has to rebuild a published week.

Copy each form into the Team Summary

The summary does not fill itself: type each person’s answers into their row. One row per person, days across, hours at the end.

Roster from the summary

Fill P cells first, then Y, then I, and keep each person under their maximum hours. Ask staff to resubmit when their week changes, such as a new semester or a second job.

What’s in the file

  • A form for each day: available, earliest start, latest finish
  • A dropdown per day: Yes, No, Preferred or If Needed
  • Weekly hours, unavailable dates and a signature line
  • A Team Summary tab with a row for each of 14 staff
Download Excel (.xlsx)
Free templates

More roster templates and guides

All free roster templates

The form and template collect availability only; they do not set or change anyone’s hours of work. Agreed hours for part-time staff come from their employment agreement and award; see fairwork.gov.au.

FAQ

Employee availability FAQ

  • Give every staff member the same form to fill in: the times they can and cannot work each day, preferred and maximum hours, and dates away. Use the Excel form, the printable PDF form, or software that lets staff update availability from their phones. Set a clear deadline and ask staff to resubmit as their commitments change.

  • The form is what each employee fills in about their own week; the template here is the form plus a team summary sheet for the manager. If you want a printable form to hand out, use the PDF form on this page. If you want to collect answers and roster from them in one file, use the Excel template.

  • Put the employee’s name at the top, list Monday to Sunday down the first column, then add columns for available, earliest start, latest finish, preferred and maximum hours, and notes. Use one tab per employee so responses stay separate and easy to compare. This template comes with that layout and a team summary sheet.

  • Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. Sharing it as a Google Sheet means staff can fill in their own tab on a phone, which saves you collecting separate files.

  • Collect availability weekly or fortnightly, depending on how often your roster changes. Set a clear cut-off, for example Friday 5pm for the following week’s roster, so you have every response before you start scheduling.

  • Collecting availability by email and spreadsheet works for small teams. As you grow, chasing responses and cross-referencing them with your roster becomes a time sink. Rostering software lets staff set their own availability in the app and warns you when a shift clashes with it.

In RosterElf

Next week’s roster 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 roster as a reusable template
  • Copy last week’s roster instantly
  • Clone individual shifts across days
  • Staff see their shifts on the iPhone and Android app