An Excel staff rota template that actually gets used

A staff rota Excel template only works if people can read it at a glance and you can change it without a spreadsheet fight. Put names down the side, days across the top, and one cell per shift. Keep formulas light so it still opens on a cheap laptop behind the counter.

What a broken rota actually costs you

The cost is not the file. It is the half hour on Sunday rewriting cells because two people swapped and nobody wrote it down. It is the morning you discover two staff on the same late shift and nobody on the early one. It is the texts while you are with a customer, asking who is in tomorrow.

On a shop floor, a van, or a salon, that mess lands on you. You become the memory. Staff stop looking at the sheet because last week it was wrong. Then you spend more time chasing than you would have spent making one clear page.

A usable staff rota template Excel file is boring on purpose. One week per tab, or one month with a freeze on the name column. Printable on A4 without cutting off Saturday. Colours that mean a role or a site, not a favourite person.

What a good process looks like

Decide the week first. Most small teams run Monday to Sunday or a rolling seven days from the day you print. Write the rule once at the top of the sheet so nobody has to ask.

Collect availability before you fill cells. A scrap of paper in the back room, a group message with a deadline, or a tick list on the wall. Do not start colouring cells until you know who cannot work Thursday.

Fill the must cover slots first: opening, closing, the busy afternoon, the person who can lock up. Then fill the rest. Leave a blank only if you truly have nobody. A blank that looks decorative is how double bookings start.

Publish one version. Print it, pin it, and save the file with the week in the name, like Rota 9 Mar. When someone swaps, change the file and reprint. Two copies in two places is how you get two truths.

Columns that earn their keep

• Name, then contracted hours or usual pattern if you need it
• One column per day, split morning and afternoon if your shifts are that short
• A notes column for cover, training, or a van run
• A total hours column with a simple SUM, nothing cleverer
• A row at the bottom that counts how many people are in each slot

What to leave out

Do not hide holiday in a comment bubble. Do not merge cells across days. Do not lock the sheet so only you can type, then wonder why nobody updates a swap. Do not use ten colours. Three is plenty: on, off, cover.

Build the sheet in this order

1. Open a blank workbook. Set print to A4 landscape, narrow margins, fit all columns to one page.
2. Row 1: week commencing and the site or van if you have more than one.
3. Row 2: Mon to Sun, or your actual open days. Repeat the date under each day so a printout still makes sense in week three.
4. Column A: staff names in the order people expect, not alphabetical if that is not how you talk.
5. Fill shifts as short codes you already use: E, L, OFF, HOL, SICK. Write the key on the sheet.
6. Freeze the name column and the day headers so scrolling does not lose the labels.
7. Add a hours total. Check it against what you actually pay, not against a fantasy week.
8. Print one copy. Stand where staff stand. If you cannot read Saturday from two metres, enlarge the font and cut a column.

Save a blank copy as the master. Duplicate it each week. Do not keep typing over last week until the colours mean nothing.

Paper, Excel, or an app

You do not need software to start. You need one source of truth that survives a wet counter and a phone with no signal.

If Excel is the job, treat the file like a tool on the van: named, dated, and not a dumping ground for last year’s unused tabs.

What an agent would do with the rota

A custom AI agent is not a magic spreadsheet. Used well, it takes the chasing around the sheet. It can remind you whose hours are light before you publish. It can turn a list of “cannot do Thursday” into a first draft you still check. It can ping the person who is down for close when nobody confirmed.

You still decide who is trusted to lock up. You still say no to a swap that leaves the till short. The agent handles the repeat admin: collecting the yes and no, filling obvious gaps, keeping one dated copy so Sunday is not a rewrite from memory.

Mistakes that make staff ignore the sheet

Tiny font so you can squeeze eight weeks on one tab. People will not squint. Split the months.

Using first names only when you have two Sams. Use the name they answer to on the floor.

Changing the codes every month. If L meant late, do not make it lunch.

Publishing before holidays are in. Then you spend the week patching holes in public.

Keeping the file only on your phone. If you are on a job, nobody can check who is in. A printed copy plus one file in a place staff can open is the minimum.

If you run more than one site, put the site in the tab name and in row 1. A staff rota excel template that looks the same for both shops will get the wrong person sent to the wrong door.

Review the template every few months. If a column is always empty, delete it. If you always add a note about the van, make that a real column. The sheet should match how you already talk, not how a classroom spreadsheet looks.

What Cleo would do

A custom Cleo built for rota admin can collect who is free and who is off before you sit down with the sheet. It can draft the week from your usual pattern, flag slots with nobody in them, and remind staff of the shift they accepted. You still approve the final copy and print it. Cleo does not invent hours or send people to the wrong site.

Common questions

Should I use one tab per week or one big month?

One tab per week is easier to print and harder to wreck. A month view is fine if you freeze the name column and still print week by week for the wall.

What shift codes work on a shop floor?

Use the words you already shout: E, L, OFF, HOL, SICK, or AM and PM. Put the key on the sheet. Do not use colours alone, because a black and white printout then means nothing.

How do I stop two people editing the file?

One named file per week, one person who publishes it, and a printed copy as the public version. Swaps go through that person, then you reprint. Shared editing without a rule creates two rotas.

Do I need formulas for a small team?

A SUM for hours and a COUNT of people in each slot is enough. Heavy formulas break on old laptops and scare people off typing a simple swap.

When is Excel the wrong tool?

When staff never see a printer or a counter laptop, and every day is a different site. Then a wall chart or a simple shared list they already open may beat a spreadsheet nobody checks.