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.

Chasing forms every week?
In RosterElf staff set their own availability in the app, and the roster warns you when a shift clashes with it. Import your staff from a CSV to start.
Your download has started.
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
More roster templates and guides
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.
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.
Next week’s roster 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 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