A weekly staff rota, free.
Plan a week of shifts for up to 10 people. Pick a code for each day and the hours and daily cover are worked out for you, even for night shifts.
✓ 100% free ✓ Instant download ✓ Excel for Windows & Mac
| Name | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Hours |
|---|---|---|---|---|---|---|---|---|
| Sarah | E | E | E | E | E | OFF | OFF | 37.50 |
| James | OFF | OFF | L | L | L | L | L | 37.50 |
| Priya | L | L | L | L | L | OFF | OFF | 37.50 |
| Tom | E | E | OFF | OFF | E | E | E | 37.50 |
| Liam | N | N | N | N | N | OFF | OFF | 37.50 |
| Chloe | OFF | OFF | OFF | HOL | HOL | N | N | 30.00 |
Simple, and it does the counting
Colour-coded shifts
Early, Late, Night, Off and Holiday, each in its own colour so the week is easy to read.
Hours worked out
Change the shift times and everyone’s hours update. Night shifts past midnight included.
Daily cover
See how many people are on each shift, every day of the week.
Yours in under a minute
Click “Download it free”
You’ll go to a secure download page. There’s nothing to pay.
Enter your email
The download link is sent straight to your inbox, and you can download it straight away too.
Open it in Excel
Type your staff names, pick a shift for each day, and the hours add themselves up.
Free version or full version
The free rota is great for one week. The full Shift Rota & Staff Schedule adds costs, contracts, cover warnings and more.
| Free | Full version · $12.99 | |
|---|---|---|
| Colour-coded shift drop-downs | ✓ | ✓ |
| Hours per person, night shifts included | ✓ | ✓ |
| Daily cover counts | ✓ | ✓ |
| Weeks | 1 | 4 |
| Staff | 10 | 30 |
| Shift codes | 5 | 12, your own |
| Staff costs per person and per day | – | ✓ |
| Contracted vs actual hours | – | ✓ |
| Red short-staffed warnings | – | ✓ |
| 4-week summary with charts | – | ✓ |
Hi, I’m Lee
I run Sheet Leveller on YouTube, where I make quick, no-nonsense Excel tutorials. This free rota uses the same night-shift formula as my timesheet tutorials, ready to use today.
Questions
Is it really free?
Yes. You just enter your email address so the download link can be sent to you.
Will you email me?
Now and then, with new Excel templates and tips. You can unsubscribe at any time with one click.
Does it use macros?
No. It’s a normal .xlsx file, so there’s nothing to enable and no security warnings.
Which versions of Excel does it work with?
Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac.
Get next week’s rota done.
Download the free Weekly Staff Rota and let Excel do the counting.
Download it freeNeed costs and cover warnings? See the full Shift Rota & Staff Schedule.