HR template
Employee shift schedule
Plan a week of shifts with a dropdown in every cell. Hours per person and coverage per shift add up as you fill the grid.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
1 sheet
- Schedule
64 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 160 filled cells in all.
Built in
- Charts
- Conditional formatting
- Dropdowns
- Frozen headers
- 1 chart
- 7 conditional format rules
A look at the Schedule sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Weekly shift schedule | |||||||
| 2 | Choose a shift code for each day. Codes and times are defined in the Shifts box on the right. | |||||||
| 3 | Week starting | Nov 16, 2026 | ||||||
| 4 | ||||||||
| 5 | ||||||||
| 6 | Employee | Mon 16 | Tue 17 | Wed 18 | Thu 19 | Fri 20 | Sat 21 | Sun 22 |
| 7 | Alex Moreno | E | E | E | E | E | OFF | OFF |
| 8 | Bailey Kim | D | D | OFF | D | D | D | OFF |
| 9 | Cameron Wu | L | L | L | OFF | OFF | L | L |
| 10 | Dakota Fern | N | N | N | N | OFF | OFF | N |
| 11 | Ellis Grant | OFF | E | E | E | E | E | OFF |
| 12 | Frankie Shaw | D | OFF | D | D | L | OFF | D |
- shifts
- schedule
- rota
- staff
- hours
More hr templates
HRWeekly timesheetRecord time in, lunch and time out for each day of the week. Hours over 40 become overtime and pay is calculated at your rates.
HRPayroll registerCalculate gross pay, withholdings, deductions and net pay for each person on a pay run. Rates live in one box so a change updates every row.
HREmployee directoryKeep contact details, teams, managers and start dates in one tidy list. Look anyone up by name and see headcount by department.
HRVacation and PTO trackerAccrue paid time off by month, log requests, and see each balance at a glance. Request days count working days only and skip holidays.
Start your employee shift schedule now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.