medishift

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 →

rota-template-excel.xlsx
Rota Template Excel: Free 4-Week Staff Rota

What's in the template

Each sheet has one job. This is how they work together.

rota-template-excel.xlsx · Rota
  1. Ansicht des Blatts „Rota“

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

  1. On the ‘Rota’ sheet, enter the start date and your nation.
  2. On the ‘Shifts’ sheet, set start, end and break for your shifts.
  3. Enter names in column B and pick a code for each day.
  4. Look at the red findings on the ‘Checks’ sheet and adjust the rota.
  5. 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 shiftsWTR 1998 reg 10
20-minute break when working time is more than 6 hoursWTR 1998 reg 12
Weeks over 48 hours marked, because 48 is the average over 17 weeksWTR 1998 reg 4
Weeks without a day off marked, for the weekly rest of 24 hoursWTR 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.

CriterionExcel templatemedishift
Rota to the teampartly: print it or email ityes: publish it, everyone sees it in the app
Holiday requestspartly: by word of mouth or on paper, then type Hyes: request in the app, on the rota once approved
Building the rotapartly: cell by cell by handyes: Kira fills the week by your rules, you accept the suggestion
Someone drops outpartly: ring round, then change the fileyes: open shift, or Kira suggests who can cover, fairly
Rota on the gopartly: printout on the wallyes: 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.

    More about rota planning
    A staff rota in the medishift app

    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

    November 2026
    MonTueWedThuFriSatSun

    Wednesday 18 November

    Loading available slots …

    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.