Rotas sorted in minutes, not hours
We handle the hard bit. You approve and publish. Your team gets notified instantly.
We handle the hard bit. You approve and publish. Your team gets notified instantly.
If you’re coordinating a ward rota and want a starting point that isn’t a blank cell A1, you’re in the right place. This post has a free Excel ward rota template you can download and adapt, plus — because we think you should know what you’re getting into — a straight look at where Excel rotas tend to fall over.
Disclaimer: This template is a starting point, not a compliance guarantee. It does not check your rota against the 2016 junior doctor contract, the Working Time Regulations, or any trust-specific policies. Responsibility for publishing a compliant, safe rota sits with the rota coordinator and, where applicable, the Guardian of Safe Working Hours. Use this template as scaffolding and check the output yourself.
Download the NHS Ward Rota Template (.xlsx)
The template covers:
Start on the Staff tab and list every member of the team — name, role (consultant, registrar, SHO, FY2, etc.), contracted hours, and working pattern. This list feeds every other tab, so getting it right once saves rework later.
Move to the Weekly Rota tab. Each column is a day, each row is a staff member. Drop a shift code into the relevant cell — EA for Early, LA for Late, N for Night, LD for Long Day, OC for On-Call, AL for Annual Leave, O for Off. The conditional formatting will colour the cell automatically, and the headcount row at the bottom will update to show how many staff are on each shift.
The Annual Leave tab is a running log. Log every request as it comes in, even before it’s approved, so you can see overlaps before you commit to anyone. The template includes a simple concurrent-leave counter so you can spot when too many people are off at once.
The Monthly View tab pulls four weekly grids onto one sheet so you can see the whole month at a glance. It’s read-only — edit the weekly tabs and the monthly view updates automatically.
For small, stable teams with predictable shift patterns, an Excel template like this genuinely is enough. If you have ten people, two shift types, and nothing changes from month to month, you can run a ward rota this way for years.
It’s also a good starting scaffold if you’ve inherited a rota that was being done on paper, or if the previous coordinator left and took their mental model with them. Getting staff, shifts, and leave into one structured file is a step forward on its own.
We’re not going to pretend otherwise — Excel rotas break in predictable ways once the team or the complexity grows past a certain point. Here’s what to watch for.
The template has no idea what the 2016 contract says. It will happily let you schedule a doctor for a 14-hour shift followed by an 8-hour rest gap, which is a breach. It will let you stack 5 consecutive night shifts on one person, which is also a breach. You are the compliance layer, and that means walking through every shift gap manually every time you change the rota.
For a junior doctor rota, this is the single biggest reason Excel eventually stops being enough. One breach that makes it through to publication triggers an exception report, a Guardian review, and potentially a fine — and the question “how did that happen” usually has the same answer: the spreadsheet didn’t flag it.
A registrar calls in sick at 07:00. You swap someone from the afternoon shift to cover. That person was meant to be on a late shift the following day, but now they don’t have 11 hours of rest, so you swap someone else. That person now has 6 consecutive long days.
In a spreadsheet, each of those swaps is a manual edit, and it’s on you to spot that the third-order consequence has just broken compliance. In practice, coordinators either catch it (and redo the rota a fourth time) or miss it (and find out at the next Guardian meeting).
Whoever is editing the file has the current version. Everyone else is looking at an out-of-date one. By the time you’ve emailed the updated PDF, the registrar who’s already on their way home thinks they’re off tomorrow, but actually you put them on an early shift two hours ago because someone else called in.
You can patch this with a shared drive, but “shared drive with a live spreadsheet” has its own problems — two people editing at once, one person’s changes overwriting the other’s, the file getting locked at an inconvenient moment.
When you change a spreadsheet, no one knows. You have to tell them. This is fine when “them” is four people, but it’s a job in itself when “them” is 25, and it’s a liability when someone doesn’t see the email and turns up for a shift that no longer exists.
Most rota coordinators have built some version of a leave-balance formula in Excel. Most rota coordinators have also had it silently break — a reference shifting when a row gets inserted, a tab getting renamed, a formula getting overwritten by a paste. Leave balances that don’t balance are a source of quiet conflict.
The honest rule of thumb: if you’re spending more than about half a day a week on the rota, or if you’ve had a compliance breach in the last six months that traced back to a manual error, a spreadsheet is no longer the cheap option. It’s just the option you’re already using.
Purpose-built rota software enforces compliance as you build (so breaches don’t reach publication), sends notifications automatically when shifts change, and keeps one live version that everyone sees. You lose the flexibility of “I can type anything into any cell” and you gain everything that flexibility was actually costing you.
If you want to see what that shift looks like in practice, we do concierge onboarding for specialty teams — we’ll build your first rota with you and you can keep the result whether you continue with us or not.
Download the NHS Ward Rota Template (.xlsx)
Use it as a starting point, run the compliance check yourself, and know what it can and can’t do. And if you hit the point where it’s costing more time than it saves — that’s not a failure of the template. It’s a signal.
Rapid Rota gives you the power to plan smarter, faster, and fairer.