Rota Template Excel: Free 4-Week Staff Rota
Free rota template Excel: four weeks for up to 15 staff, with rest and break checks under the Working Time Regulations and bank holidays for each UK nation.
Updated November 2026 · Excel · no sign-up
Without Excel: do it in medishift instead, start for free →

What's in the template
Each sheet has one job. This is how they work together.
This rota template Excel file plans four weeks for up to 15 staff. You pick a shift for each day, and the file checks the 11 hours of rest between shifts and the 20-minute break, and marks the bank holidays of your nation.
How to fill in the template
- On the ‘Rota’ sheet, enter the start date and your nation.
- On the ‘Shifts’ sheet, set start, end and break for your shifts.
- Enter names in column B and pick a code for each day.
- Look at the red findings on the ‘Checks’ sheet and adjust the rota.
- Print the rota or save it as a PDF for the team.
How the template calculates
Working hours = end − start − break (if the end is before the start, it is the next day)Rest = start today + 24 hours − end yesterday, only when both days are shiftsDays off = 7 − days with a shift, for each week from Monday| At least 11 hours of rest between two shifts | WTR 1998 reg 10 |
| 20-minute break when working time is more than 6 hours | WTR 1998 reg 12 |
| Weeks over 48 hours marked, because 48 is the average over 17 weeks | WTR 1998 reg 4 |
| Weeks without a day off marked, for the weekly rest of 24 hours | WTR 1998 reg 11 |
What a rota template has to contain, and the rest rules that catch people out →
Limits of the template
For a small team the file is enough. This is where it reaches its limits.
- The findings sit on their own sheet, not in the cells of the rota itself.
- One person plans in one file. It does not record who changed what.
- The 48-hour average over 17 weeks needs more than four weeks; the file only marks single weeks above 48.
- Northern Ireland has its own Working Time Regulations (2016) with the same limits under different regulation numbers.
- Rules for young workers, night workers and collective agreements are not checked.
- The team only sees the rota once you print it or send it round.
Excel rota template or medishift
The template is enough if you build the rota by hand. If it should be ready faster, follow your own rules automatically or cover absences fairly, medishift does that with the AI assistant Kira.
| Criterion | Excel template | medishift |
|---|---|---|
| Rota to the team | partly: print it or email it | yes: publish it, everyone sees it in the app |
| Holiday requests | partly: by word of mouth or on paper, then type H | yes: request in the app, on the rota once approved |
| Building the rota | partly: cell by cell by hand | yes: Kira fills the week by your rules, you accept the suggestion |
| Someone drops out | partly: ring round, then change the file | yes: open shift, or Kira suggests who can cover, fairly |
| Rota on the go | partly: printout on the wall | yes: app for iOS and Android |
Automatic weekly planning and cover suggestions with Kira are not part of the free plan of medishift. You can try every feature for the first 14 days.
The rota on their phone, not on the wall
In medishift you publish the rota and everyone sees their shifts in the app. Holiday requests come in there too, and you approve them with one tap.

See medishift in 30 minutes
We show you, using your own team, how rota, time tracking and leave work together without Excel. Pick a time that suits you.
- 30 minutes
- Via Google Meet
- Free and without obligation
1. Pick a slot
Wednesday 18 November
FAQ: Rota template Excel
Fifteen people over four weeks. For the next period, enter a new start date or save one copy of the file per month.
Yes. If there are fewer than 11 hours between two shifts, the ‘Checks’ sheet shows a red finding with the actual rest, for example ‘Rest 10.5 h’. That is the daily rest under regulation 10 of the Working Time Regulations 1998.
Yes. A shift with more than six hours of working time needs a break of at least 20 minutes under regulation 12. If the break on the ‘Shifts’ sheet is shorter, the day turns red.
Because the 48-hour limit is an average over 17 weeks, not a cap for one week, and a worker can opt out of it in writing. The template marks the week so you can keep an eye on the average.
Yes. The file holds the bank holidays from gov.uk for England and Wales, Scotland and Northern Ireland from 2026 to 2028, including substitute days. You pick your nation on the ‘Rota’ sheet.
Yes. The ‘Shifts’ sheet has ten free rows. Enter a code, start, end and break, and the shift appears in the drop-down and counts as working time. If it should not count as working time, set ‘Counts as work’ to ‘no’.
Yes. The file uses only functions that Excel and Google Sheets both know, so the checks and drop-downs work after you upload it to Google Drive.
Related templates

Weekly Work Schedule Template: Free Excel & PDF
Free weekly work schedule template for Excel and as a printable PDF: start and finish times, hours against the contract, rest checks and a monthly plan.

Hospital Rota Template: Free 24/7 Ward Rota
Free hospital rota template for Excel: long days, nights and twilights for up to 25 staff over four weeks, with rest and break checks and UK bank holidays.

Timesheet Template with Overtime: Excel & PDF
Free timesheet template for Excel and as a printable PDF: four weeks for one person, with weekly overtime, pay at your overtime rate and break and rest checks.




