Free Roster Templates for Excel and Google Sheets
Download a staff roster template below. Each one is an Excel file that also opens in Google Sheets, adds up hours by itself (including shifts that finish after midnight) and prints on one landscape A4 page. No email address or sign-up needed.
Weekly staff roster
Excel .xlsx · Google SheetsAny business with a Monday to Sunday roster.
Start and finish times for 20 staff, unpaid breaks, total hours per person and per day.
Download for ExcelFortnightly staff roster
Excel .xlsx · Google SheetsTeams paid fortnightly, or rostered two weeks ahead.
Fourteen days side by side, with the same automatic totals as the weekly template.
Download for ExcelCafe and restaurant roster
Excel .xlsx · Google SheetsCafes, restaurants and small venues.
Filled in with an example week for a cafe open 6:30am to 3pm, so you can see how cover is built around trade.
Download for ExcelOSHC roster with ratio check
Excel .xlsx · Google SheetsBefore school, after school and vacation care.
Enter children booked per session and your ratio; it shows how many educators you need and whether the roster is short.
Download for ExcelChildcare room roster with ratio check
Excel .xlsx · Google SheetsLong day care and early learning centres.
Rooms by age group, children booked and the ratio for each room, with a short or OK check per room per day.
Download for ExcelHome care visit roster
Excel .xlsx · Google SheetsIn-home care and disability support providers.
One row per client visit, with hours, travel kilometres and a week-by-carer summary.
Download for ExcelWould rather not use a spreadsheet? The free online roster maker builds the same weekly roster in your browser and prints it.
How to use a roster template
- Save a copy for each week. Name it by the week it starts, for example Roster 2026-12-01. Writing over last week's file is how a disputed shift becomes impossible to check later.
- List your staff and their roles. Keep phone numbers and addresses out of it. A roster gets printed, pinned up and forwarded, and personal details don't belong on it.
- Type times as 9:00 or 17:30. The total hours column works the rest out. A shift from 22:00 to 06:00 counts as 8 hours, not minus 16.
- Enter unpaid breaks in hours. Thirty minutes is 0.5. Paid breaks stay in the shift.
- Check the totals before you send it. Compare each person's hours with their contract, and check minimum shift lengths and penalty rates for your award in the Fair Work Pay and Conditions Tool.
- Print it or share it. Every template is set to print on one landscape A4 page.
Using Google Sheets? Upload the file to Google Drive and choose Open with Google Sheets, or start a new sheet and use File, Import. The formulas carry across, ratio checks included.
What a good roster template needs
Most free templates are a grid of names and days. That's fine until someone asks how many hours they did last fortnight. These are built around the questions a roster actually gets asked.
- Hours that add up by themselves. Every template uses =24*MOD(finish-start,1), which is the one formula that gets overnight shifts right.
- Breaks kept apart from the shift. A 9:00 to 17:00 shift with a 30-minute unpaid break is 7.5 paid hours. Typing 7.5 into the shift instead hides the break, and the break is what people query.
- Daily totals. Hours per day is the number your wage budget runs on. Thursday at 29 hours against a Saturday at 41 tells you where the money goes.
- A ratio check for care services. The OSHC and childcare templates take the children booked and your ratio, then mark each session or room as OK or short. You enter the ratio yourself because it differs by age group and by state; check ACECQA for yours.
- Visits, not shifts, for home care. A carer's day is a run of client visits with travel in between, so the home care template has one row per visit and a week-by-carer summary.
One limit worth knowing: the ratio check counts the educators rostered to each session or room for the day. It doesn't check every hour, so opening, closing and lunch-break cover still need a look of their own.
When a spreadsheet roster stops working
A template is the right tool for a small, steady team. It starts to cost you when the roster changes after it's sent. Someone calls in sick at 6am, you fix the spreadsheet, and half the team is still looking at the version from Tuesday's email. Nobody gets a notification, and there's no record of who was asked to cover.
That's the point where an app earns its place. Get My Roster puts the roster on each person's phone, sends changes as they happen and lets you offer an open shift to everyone eligible, with the first to accept getting it. It's free for up to 5 staff, so a small team can try it before deciding.
Roster templates: frequently asked questions
Is there a free roster template for Excel?
Yes. Get My Roster offers free weekly, fortnightly, cafe, OSHC, childcare and home care roster templates as Excel files. They need no sign-up, add up hours automatically and print on one landscape A4 page.
Can I use these roster templates in Google Sheets?
Yes. Upload the Excel file to Google Drive and open it with Google Sheets, or use File, Import in a new sheet. The formulas, including the ratio checks, work in Google Sheets.
How do you calculate hours on a roster?
Subtract the start time from the finish time and multiply by 24 to turn the result into hours. In Excel or Google Sheets the formula =24*MOD(finish-start,1) also handles shifts that finish after midnight. Subtract unpaid breaks afterwards.
What should a staff roster include?
Each staff member and their role, start and finish times for every shift, unpaid breaks, total hours per person, daily totals for the wage budget, and the week it applies to. Care services also need the children booked and the educator-to-child ratio.
How many educators do I need for OSHC?
Divide the number of children booked by the educator-to-child ratio that applies in your state and round up. The ratio for school-age children differs between states, so check the ACECQA ratio table. The free OSHC template does this calculation per session.