Free template· UK, Excel, prints on one page

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.

rosterelf-uk-blank-rota.xlsx
The blank rota template partly filled in for a small café: hours as numbers Monday to Sunday, OFF and AL codes, and each person’s weekly total

File checked No signup

The download

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
Download Excel (.xlsx)
Only on this page

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.

CodeMeansCounts as hours?
7.5Hours worked that dayYes
OFFDay offNo
ALAnnual leave, out of the 5.6 weeksNo
BHBank holidayNo
SICKSickness absenceNo
TOILTime off in lieuNo
TRTraining, paid working timeType 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.

FAQ

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.

In RosterElf

Next week’s rota from this week’s, in one click

For when copying the sheet every week becomes the job.

A café worker beside RosterElf’s Select a roster to copy panel, with last week’s roster ready to copy

Save a week as a template and copy it forward

Any weekCopy last weekStaff app
  • 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