Free staff rota template for Excel
A weekly rota template with start and end times, unpaid breaks and automatic hour totals for up to 12 people. Download it, fill it in, print or share it.
No email needed. Works in Excel, Google Sheets and LibreOffice.
A weekly rota that does the maths
Monday to Sunday
One sheet per week with four columns per day: start, end, unpaid break and hours.
Hours calculated
Hours per shift, per person and per day add up automatically, even for shifts past midnight.
Rule checklist
A second tab lists what to check before you share: breaks, rest between shifts, days off, under-18s.
Fill in your rota in three steps
Add your team
Write names and roles in the first two columns. Delete rows you don’t need.
Enter shifts
Type start and end in 24-hour format, for example 09:00 and 17:30, plus the unpaid break in minutes.
Check the rules
Use the checklist tab to look for missing breaks and short rest between closing and opening shifts.
When a template stops being enough
| Rota template | Shiftokay | |
|---|---|---|
| Price | Free | Free up to 5 people, then from €3 per person |
| Hour totals | ✓ | ✓ |
| Break and rest checks | Manual checklist | Automatic, on every shift |
| Sharing with staff | Print, PDF or photo | One live link and a staff app |
| Shift swaps | By message | Requested in the app, you approve |
| Payroll | Copy hours by hand | CSV export for BrightPay and Sage 50 |
Rota template questions
Is the rota template really free?
Yes. Download the Excel file, use it for your business and change it as you like. No sign-up needed.
Does it work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The hour formulas keep working.
How are hours calculated?
Each day has start, end and unpaid break in minutes. The template works out the hours, including shifts that end after midnight, and adds them up per person and per day.
Does the template check breaks and rest periods?
No, a spreadsheet can’t do that reliably. The second tab has a checklist. If you want automatic checks, Shiftokay flags missing breaks, short rest and too many hours while you plan.
When should I switch from a spreadsheet to rota software?
Usually when you plan more than a handful of people, when swaps happen every week, or when you type hours into payroll by hand. Shiftokay is free for up to 5 people, so you can try it without risk.
Want the rota to check itself?
Shiftokay turns your template into a live rota that flags rule problems. Free for up to 5 people.