Free Shift Rota Template – Excel Weekly Staff Rota (1 Week, 10 Staff)

A free shift rota template for Excel that does the sums for you. Set up your shifts once – early, late, night, long day, holiday – with start and finish times, unpaid breaks and how many staff each shift needs. Then pick a shift code for each person and day. The rota colour-codes every shift, adds up paid hours against each person’s contract and checks cover every day, so you can spot a short-staffed shift before it happens.

What it does

• Weekly staff rota – 10 staff × 7 days with dropdown shift codes and colour-coding
• Automatic dates – type the Monday of the week and every day heading updates
• Paid hours – worked out from start, finish and unpaid break, including night shifts that finish after midnight
• Hours vs contract – see at a glance who is over or under their contracted hours
• Cover check – counts staff on each shift every day and turns red when you are short
• Protected formulas – calculations are locked so nothing breaks by accident

Who it’s for

Managers and supervisors in care homes, retail, hospitality, warehouses, clinics and small businesses who need a simple work rota template without paying for scheduling software.

What’s included

• 1 Excel workbook (.xlsx): How to Use, Rota and Shifts
• Sample staff and shifts so you can see how it works – overwrite them with your own

Need more than one week?

The full Shift Rota Planner gives you a 4-week rota for 30 staff, more shift types, a summary dashboard and cover checks across the whole month.

Frequently asked questions

Is this rota template really free?
Yes. Add it to your basket and check out at £0 to download it. You can use it at work or at home.

Can I print the rota?
Yes. The Rota tab is set up to print on one landscape page so you can pin it up for your team.

Does it work in Google Sheets?
It is built for Microsoft Excel 2010 or later on Windows or Mac, including Microsoft 365. It is not designed for Google Sheets.

Requirements

Microsoft Excel 2010 or later, including Excel 2019, 2021 and Microsoft 365 (Windows or Mac).

This is a digital download. No physical item will be shipped. Your file is available to download immediately after checkout.