Free blank rota template (printable Excel)
A blank rota template is an empty Monday-to-Sunday grid with name and role columns, ready to fill in by hand or on screen. This one has 20 rows, prints on one landscape page, and still totals each person’s hours if you type them as numbers. There are no sample names to delete first.

Next week you’ll print a fresh grid and write it all out again.
In RosterElf you import your staff from a CSV once, save the week as a rota template and publish it to everyone’s phone. Approved hours go to Xero UK or a CSV.
Your download has started.
What’s in the file
- An empty Mon to Sun grid for 20 staff, with role and notes
- Total hours per person and a daily total row by formula
- An Instructions tab with shift codes and working time reminders
What goes in each cell
Type hours as numbers (7.5) and the Total column adds them up. Anything else is a code, and codes count as no hours, so a blank printout totals zero and stays readable.
| Code | Means | Counts as hours? |
|---|---|---|
| 7.5 | Hours worked that day | Yes |
| OFF | Day off | No |
| AL | Annual leave, out of the 5.6 weeks | No |
| BH | Bank holiday | No |
| SICK | Sickness absence | No |
| TOIL | Time off in lieu | No |
| TR | Training, paid working time | Type the hours instead |
Writing by hand? Use the same codes, so the rota on the wall reads the same as the one on screen. If you would rather start from something filled in, the weekly rota template takes start and finish times and has sample staff in place.
More rota templates
Working time rules from GOV.UK: maximum weekly working hours and rest breaks at work. The file counts hours only; it does not work out pay.
Blank rota FAQ
-
Yes. The page setup is already landscape and fitted to one page wide, so all seven days print without spilling onto a second sheet. Print it and fill it in by hand, or type into it first.
-
That is what it is for. The rows are set to a height that leaves room to write in, and the shift code legend on the Instructions tab prints separately if you want it on the wall too.
-
Insert rows anywhere inside the grid and the formatting carries. If you insert below the daily total row, extend its range so the new rows are included.
-
Blank is faster if you know what you are doing and want to print it. If you would rather see a worked example first, the weekly rota template has staff, roles and shift times already filled in.
-
There is no requirement for a rota to be in any particular format. But you do have to keep records adequate to show minimum wage was paid, and a paper rota shows what was planned rather than what was worked. See our minimum wage guide.
Next week’s rota from this week’s, in one click
For when copying the sheet every week becomes the job.
Save a week as a template and copy it forward
- Save any rota as a reusable template
- Copy last week’s rota instantly
- Clone individual shifts across days
- Staff see their shifts on the iPhone and Android app