Free Excel and Google Sheets

Free staff rota template for Excel

A weekly rota template with start and end times, unpaid breaks and automatic hour totals for up to 12 people. Download it, fill it in, print or share it.

No email needed. Works in Excel, Google Sheets and LibreOffice.

What’s inside

A weekly rota that does the maths

🗓

Monday to Sunday

One sheet per week with four columns per day: start, end, unpaid break and hours.

➗

Hours calculated

Hours per shift, per person and per day add up automatically, even for shifts past midnight.

✅

Rule checklist

A second tab lists what to check before you share: breaks, rest between shifts, days off, under-18s.

How to use it

Fill in your rota in three steps

Add your team

Write names and roles in the first two columns. Delete rows you don’t need.

Enter shifts

Type start and end in 24-hour format, for example 09:00 and 17:30, plus the unpaid break in minutes.

Check the rules

Use the checklist tab to look for missing breaks and short rest between closing and opening shifts.

Spreadsheet or app?

When a template stops being enough

Rota templateShiftokay
PriceFreeFree up to 5 people, then from €3 per person
Hour totals✓✓
Break and rest checksManual checklistAutomatic, on every shift
Sharing with staffPrint, PDF or photoOne live link and a staff app
Shift swapsBy messageRequested in the app, you approve
PayrollCopy hours by handCSV export for BrightPay and Sage 50
FAQ

Rota template questions

Is the rota template really free?

Yes. Download the Excel file, use it for your business and change it as you like. No sign-up needed.

Does it work in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The hour formulas keep working.

How are hours calculated?

Each day has start, end and unpaid break in minutes. The template works out the hours, including shifts that end after midnight, and adds them up per person and per day.

Does the template check breaks and rest periods?

No, a spreadsheet can’t do that reliably. The second tab has a checklist. If you want automatic checks, Shiftokay flags missing breaks, short rest and too many hours while you plan.

When should I switch from a spreadsheet to rota software?

Usually when you plan more than a handful of people, when swaps happen every week, or when you type hours into payroll by hand. Shiftokay is free for up to 5 people, so you can try it without risk.

Want the rota to check itself?

Shiftokay turns your template into a live rota that flags rule problems. Free for up to 5 people.