Free staff rota templates for UK businesses
Four Excel rota templates built for the way UK teams actually work — Monday-start weeks, bank holiday codes, and rolling patterns that are already worked out rather than left blank.
Browse the templatesUpdated August 2026. Shift codes and working time notes checked against GOV.UK guidance.
These rota templates are planning tools, not legal or payroll advice. They do not check working time limits, rest breaks or minimum wage for you. Check GOV.UK, or take advice, before relying on a rota for compliance. It does not constitute legal, HR, or professional advice and should not be relied on as a substitute for advice specific to your business, workforce, or circumstances.
A rota is a scheduling document and a pay document at the same time. It tells people when to turn up, and it is usually the first thing anyone reaches for when a question about hours, holiday or minimum wage comes up months later.
These templates are built around that second job. Each one carries a shift-code legend so AL, BH, SICK and TOIL mean the same thing to everyone reading it, and a set of working time reminders on the Instructions tab — the 48-hour average, the 20-minute break, the 11-hour daily rest — because those are the constraints a rota can quietly breach.
Key takeaways
- Four Excel templates: weekly, monthly, rolling patterns and a blank printable grid
- Monday-start weeks throughout, which is how UK rotas are normally written
- The rolling template has 4-on-4-off and continental 2-2-3 already worked out across four teams, with a live cover count
- Every template carries the same shift-code legend so the rota reads the same way to everyone
- A rota records what you planned — not what was worked, which is a different question at payroll
The templates
Pick the planning horizon that matches how you work
Weekly staff rota
A Monday-to-Sunday grid with names, roles, shift times and an automatic weekly hours total. The one most teams want.
Read moreMonthly staff rota
All 31 days across one row per person, so leave clashes and bank holiday gaps are visible a month ahead.
Read moreRolling rota (4 on 4 off)
Two rolling patterns already solved across four weeks and four teams — 4-on-4-off and continental 2-2-3 — with a cover count under every day.
Read moreBlank rota
An empty Monday-to-Sunday grid with 20 rows, set to print on one landscape page. For filling in by hand.
Read moreWhat every template includes
The same conventions across all four, so they read consistently
Monday-start weeks
UK rotas run Monday to Sunday. All four templates follow that, so a rota lines up with how weekly rest is counted.
A shared shift-code legend
OFF, AL, BH, SICK, TOIL and TR are defined on the Instructions tab of every file, so nobody has to guess what a letter means.
Working time reminders
The 48-hour average, the 20-minute break over six hours, and the 11-hour daily rest rule are printed alongside the grid.
Totals that calculate
Enter hours as numbers and per-person and per-day totals add themselves up. Leave it blank and they show nothing.
UK contract types
Sample roles include zero-hours rather than the Australian "casual", so the rota reflects how UK teams are actually made up.
No signup
Every file downloads directly. No email address, no gated form, no follow-up sequence.
Who these are for
Shift-based UK teams planning cover across a seven-day week
More free UK resources
Tools and guides that sit alongside the rota
UK employment guides
Holiday entitlement, minimum wage, rota law, shift patterns and sick pay — written for employers.
Browse the guidesMinimum wage compliance checker
Work out what your staff are effectively paid once unpaid time and deductions are counted.
Open the checkerFree tools
Calculators and generators for planning and costing your workforce.
See all toolsThe rules behind the rota
What you can and cannot put on a rota, and what it costs
Working time
Holiday and absence
Doing it in software
Sources
The working time and pay figures referenced in these templates
When a spreadsheet stops being enough
A spreadsheet rota is genuinely fine for a small, stable team. It stops being fine at a predictable point: when the exceptions start outnumbering the plan.
The first crack is usually the swap. Someone trades a shift, the printed copy on the wall no longer matches the file, and two versions of the truth start circulating. The second is sickness — with statutory sick pay now payable from day one, a short absence is a payroll event as well as a cover problem. The third is the question you cannot answer from a rota at all: how many hours did this person actually work? A rota records what you planned. It has nothing to say about the ten minutes before opening, the handover that overran, or the shift somebody stayed late to cover — and in a minimum wage enquiry, the burden is on the employer to show what was worked.
That is the gap clocked-in records close, and it is the practical reason teams move off spreadsheets. Not because the spreadsheet was bad, but because the questions changed.
Or stop rebuilding the rota every week
RosterElf keeps the rota, shift swaps, clock-in records and the payroll export in one place — so the plan and what actually happened stay in step.
Rota template questions
-
Yes. Every file downloads directly with no signup, no email address and no follow-up sequence. Use them, edit them, share them with your managers.
-
Use the weekly one if your cover changes week to week — that suits most hospitality and retail teams. Use the monthly one if you plan leave and cover a month ahead, which is common in care. Use the rolling one if you run a fixed repeating pattern for 24/7 cover. Use the blank one if you want to print it and fill it in by hand.
-
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets — the layout, formatting and SUM formulas all carry over. They work in LibreOffice Calc too.
-
Yes. There is nothing locked. Change the colours, add your logo, add or remove columns — they are ordinary Excel files.
Before you download
General information only — not legal advice
This document is a general HR template provided for informational purposes only. It is not legal advice and may not reflect the latest changes in legislation or apply to every workplace situation. RosterElf Pty Ltd and the template provider accept no liability for any loss arising from reliance on this document. Users should seek independent legal advice and customise the template to ensure it complies with all relevant laws, awards and workplace requirements.