The ten files are two kinds of document, and the choice is about your shifts, not your trade.
If the times move around, take a rota with a start and a finish in the cell: the weekly one, the two-week one. Cafes, restaurants, shops with long days, salons, anywhere the question is who is on at four o'clock. Each cell holds a real clock time, so the file can tell you the hours, not just the days.
If people work fixed shifts, take a code grid: the monthly one, the 4-week rolling one, 4 on 4 off, the night shift rota, the care home rota, the kitchen rota. One letter per person per day is faster to fill and easier to read across four weeks than a wall of times. The letters mean something because of the small table under the grid: each code has a start, a finish and the hours, and the hours column of every person is counted from it. Change a shift from 07:00 to 07:30 in that table and every total follows.
The timesheet is a different thing again. The rota is the plan, the timesheet is what happened, one person, one month. Keep them apart and payroll arguments get shorter. The cleaning rota is not a staff rota at all: tasks down the side, initials in the cell, a count of tasks per person so the load is visible.
In Australia and New Zealand a rota is called a roster, and the roster templates include a fortnightly roster with pay and a 2-2-3 roster that repeats every fortnight.
The care home file is built the way most homes staff the day: an early from 07:00 to 14:30, a late from 14:00 to 21:30 and a night from 21:00 to 07:30, with the half-hour overlaps left in for handover. Sixteen people over two weeks: twelve day staff on two earlies, two lates and two off, four night staff on two on, two off, and the two nurses set three days apart so one of them is on every day.
Under the grid three coverage rows count who is on duty for each shift: four on every early and every late, two on every night, red as soon as a count drops below the number you type in. In the sample one carer takes annual leave in the second week, and three day shifts drop to three. When the home has outgrown the spreadsheet, the same rota with nights, call-offs and hours before payroll is on the page about rota software for care homes.
A rolling rota is a set of weekly patterns that people move through in turn. The template does it for a shop of eight with an early from 08:00 to 16:00 and a late from 12:00 to 20:00, and four patterns of five shifts each:
- Week A: Monday off, early Tuesday and Wednesday, late Thursday and Friday, early Saturday, Sunday off.
- Week B: early Monday, late Tuesday, Wednesday off, early Thursday and Friday, Saturday off, late Sunday.
- Week C: late Monday, Tuesday off, late Wednesday, Thursday off, early Friday, late Saturday, early Sunday.
- Week D: Monday off, early Tuesday and Wednesday, late Thursday, Friday off, late Saturday and Sunday.
Two people start on each pattern, and every week each person steps on to the next one: A goes to B, D goes back to A. After four weeks everyone has worked every pattern, so everyone has had one Saturday off and one Sunday off, the weekend runs with six people and the quiet Monday with four. Week five is week one again.
The dated files, the 4-week rolling rota, 4 on 4 off, the night shift rota and the care home rota, start on Monday 28 September 2026, and the timesheet opens on September 2026. Type another date into the yellow cell and every date in the header follows, so the same download serves the rest of 2026 and the years after it. The weekly and two-week rotas run Monday to Sunday and the monthly one by day number, so they carry no year at all.
Most rota templates you can download are a grid with the days across the top. That is the easy half. The half that matters is the arithmetic, and these files do three pieces of it.
- Hours from times. A shift from 22:00 to 06:00 is eight hours, not minus sixteen, which is what a plain subtraction gives you and the reason so many downloaded templates quietly produce nonsense on nights. A half-filled pair counts as zero, so one blank cell cannot invent fifteen hours.
- Coverage. Under every code grid a row counts who is on each shift every day, and turns red when the count drops below the number you set. On paper this is the thing you find out on the day; in the file it is visible while you plan. In the care home sample one week of annual leave leaves three day shifts short, and you can see which.
- Dates from one cell. The rolling rotas and the timesheet take a start date in a yellow cell and date the whole header from it. Week five of a 4-week rota is week one with a new date, so you change one cell rather than retyping a row.
Everything is a plain formula: COUNTIF, IF, WEEKDAY, EOMONTH. The files open in Excel, Google Sheets and LibreOffice without macros, and the samples are filled in so you can see the formulas working before you type over them. To build the weekly one yourself, with each formula explained, there is a step-by-step guide: how to make a rota in Excel.
A spreadsheet is genuinely fine for one site and a small team, and there is no reason to replace something that works. It stops working at a specific, recognisable point, and it is worth knowing what that point looks like before you are standing in it.
- The team cannot see it. You post a photo of the grid in a group chat. Two swaps later, four people are working from three different versions and one of them is a screenshot from Tuesday.
- Nobody is told anything. Move a shift and the file changes. That is all it does. Whether the person finds out is down to whether they scroll.
- Sickness at six in the morning. A file cannot ask eleven people at once whether they can come in. You can, one call at a time, while the delivery lands.
- The second site. Two spreadsheets means the question of who is on tomorrow at the other one now costs a phone call.
- It never catches a mistake. Double-booking someone, leaving a Saturday with nobody on, rostering a person who booked the day off: the grid takes all three without a murmur. The coverage row catches the second one; the other two it cannot see.
None of that is an argument against the templates. Take them, use them, there is no email box to fill in. It is an argument about when to stop.