A work schedule tells each member of staff when they are working and tells you whether the business is covered. Published early enough, it also lets people arrange their lives around the job, which is the single biggest factor in how many last-minute swap requests you field.
Below are 10 free employee work schedule templates in MS Word and MS Excel — weekly rotas, monthly rosters, rotating shift patterns, availability forms and leave trackers. All fields are editable, so set your staff names and operating hours once and reuse the sheet each period.
1. Weekly Staff Rota
Staff names down the left, days across the top, shift times in the cells. The standard rota most small businesses run on, and the right starting point if you are replacing a whiteboard.
MS WORDDownload Now ↓
2. Monthly Shift Roster
A full month on one sheet using short shift codes rather than times. Publishing a month ahead gives staff enough notice to arrange cover between themselves, which removes most of the management work.
MS EXCELDownload Now ↓
3. Fortnightly Rota
Fourteen days on one page, which suits businesses paying fortnightly or running alternating week patterns. Easier to balance fairly than a single week, because weekend duty evens out across the period.
MS WORDDownload Now ↓
4. Hourly Coverage Schedule
Shows how many people are on duty in each hour of the day rather than just who is working. For restaurants and shops with sharp peaks, this is the view that reveals you are overstaffed at three and short at midday.
MS EXCELDownload Now ↓
5. Rotating Shift Pattern
Early, late and night shifts cycling between teams over a repeating pattern. Set the cycle once and it generates itself; the rest-period gaps between rotations are the part to check carefully against your local working time rules.
MS EXCELDownload Now ↓
6. Schedule with Weekly Hours Total
Totals each person’s hours as you enter the shifts, so you see contracted hours and overtime before the rota is published rather than when payroll runs. Feeds straight into your salary slips at the end of the month.
MS EXCELDownload Now ↓
7. Department and Team Schedule
Staff grouped by department or function, so you can check each area is covered rather than just counting heads. Necessary once different roles are not interchangeable — three people on shift is no use if none of them can open the till.
MS EXCELDownload Now ↓
8. Leave and Time-Off Tracker
Entitlement, days booked, days taken and remaining balance for each person across the year. Keeping this beside the rota is what stops three people being approved for the same week in August.
MS EXCELDownload Now ↓
9. Employee Availability Form
Handed to staff rather than produced by you: they mark the shifts they can and cannot work. Collecting these before drafting the rota prevents most of the rework, particularly with students and part-time staff.
MS WORDDownload Now ↓
10. Blank Work Schedule
An empty grid with no names or hours preset, so it adapts to any size of team or pattern of opening. Print a stack and fill one in each week by hand if that suits your operation better.
MS WORDDownload Now ↓
Which Work Schedule Suits Your Business?
- A small team with steady hours — template 1, the weekly rota.
- Shift work across a whole month — template 2.
- Sharp daily peaks — template 4, which shows coverage by hour.
- Round-the-clock operation — template 5, the rotating pattern.
- Watching hours and overtime cost — template 6, which totals automatically.
- Mostly part-time or student staff — template 9 first, then build the rota from what comes back.
How to Build a Rota That Works
- Start from demand, not from staff. Work out how many people each part of each day actually needs before deciding who works it. Most overstaffing comes from rostering habits rather than requirements.
- Collect availability and leave first. Build around known absences rather than discovering them after publishing. Template 9 and template 8 exist for this reason.
- Check skills coverage, not just headcount. Every shift needs someone who can handle each essential task — keyholder, supervisor, anything requiring certification.
- Distribute the unpopular shifts fairly. Weekends, nights and public holidays should rotate. Perceived favouritism in a rota does more damage to a team than almost anything else a manager does.
- Check hours and rest periods before publishing. Total each person’s hours and look at the gaps between shifts. Working time limits, break entitlements and minimum rest periods are set by law and vary by country, so check your local rules.
- Publish as far ahead as you can. Two to four weeks is common practice, and some jurisdictions now set a legal minimum notice period for shifts. Longer notice means fewer swap requests.
- Have a documented swap process. Staff arranging cover between themselves, with a manager signing it off, is far less work than handling every change yourself.
What a Good Rota Changes
Coverage Matches Demand
Scheduling by hour rather than by shift usually finds the same labour cost spread more usefully across the day. That is normally the fastest saving available in a service business.
Payroll Gets Simpler
When hours are totalled as the rota is built, contracted hours and overtime are visible before the month ends rather than as a surprise afterwards. The schedule becomes the source document for pay.
Staff Can Plan Their Lives
Predictable, early-published shifts reduce turnover more reliably than most retention initiatives, because unpredictable hours are one of the most common reasons people leave hourly work.
Other Rotas Line Up With It
Tasks assigned to someone not on shift simply do not happen. Build your cleaning schedule and other recurring duties against the staff rota, and keep deadlines on a monthly schedule so the two stay consistent.
Frequently Asked Questions
How far in advance should a work schedule be published?
Two to four weeks is common practice and gives staff time to arrange cover themselves. Some countries, states and cities have introduced predictable scheduling laws that set a legal minimum notice period and may require payment for late changes, so check what applies where you operate.
What are the legal limits on working hours and breaks?
They vary substantially by country and sometimes by industry — maximum weekly hours, daily and weekly rest periods, night work restrictions and break entitlements are all set by local employment law. A template cannot check compliance for you, so confirm the rules that apply to your business before publishing a rota.
What is the difference between a work schedule and a timesheet?
A schedule is planned in advance and says when people should work. A timesheet records what was actually worked afterwards and is what payroll should be based on, since shifts get swapped and extended.
How do I handle shift swaps fairly?
Let staff arrange swaps between themselves and require a manager to approve the result, checking that skills coverage and hours limits still hold. Write the change onto the published rota rather than leaving it as a verbal arrangement.
Can I edit these templates in Google Sheets?
Yes. Upload the file to Google Drive, right-click and choose Open with → Google Sheets for the Excel versions or Google Docs for the Word ones. Sharing a read-only link is a simple way to publish the rota to staff.
Are these templates free for commercial use?
Yes. Use them in any business at no charge and add your own branding. You cannot resell the template files themselves.
