How to Make a Shift Schedule + Free Template
A useful employee schedule answers four questions: who works, when, where, and with how many colleagues? This guide takes you from staffing requirements to a published roster, with a small example covering two worksites.
Download the free templateCreate your employee schedule in five steps
List locations and coverage times
For each worksite, record the days, start and end times, and number of people needed. Keep the coverage requirements separate from employee names so unfilled shifts remain visible.
Collect employee availability
Record absences and available times before assigning people. Also check required skills, agreed hours, and the working-time rules that apply to your business.
Assign shifts
Assign suitable, available employees to each shift. Check overlaps and travel between sites: two shifts do not fit together if there is no time to move between locations.
Check hours and coverage gaps
Add up each employee's scheduled hours and compare them with agreed hours. Then review every worksite: is enough staff assigned at each required time? Explicitly plan breaks and any cover needed during them.
Publish and track changes
Decide who approves the roster and where employees find the current version. Ask for confirmation and record changes after publication. Sending a schedule is not the same as having a shift confirmed.
Worked example: cover two sites across five days
This fictional cleaning schedule needs two people at each site at the same time, Monday through Friday:
- Site A: 06:00–08:00, two employees.
- Site B: 18:00–20:00, two employees.
Staffing requirement: 2 sites × 2 people × 2 hours × 5 days = 40 staff-hours per week. That is 20 individual employee shifts of two hours each. Four employees working five shifts each would have ten scheduled hours apiece.
This calculates required coverage, not payroll. Account separately for breaks, additional duties, and travel in your actual workflow. If one employee is absent on Tuesday morning, Site A is short by two staff-hours; extra hours in the evening do not fill that morning gap.
Free shift schedule template for Excel and Google Sheets
The CSV contains the 20 example shifts with day, worksite, employee, start, end, break minutes, status, and notes. Open or import it in your spreadsheet application. No sign-up is required.
Download the employee shift schedule (.csv)
Replace the sample entries with actual dates, locations, and employees. Fill in breaks and verify hours before publishing. This is a planning worksheet without automatic conflict checks, not a Shiftor import template.
When does a shift scheduling app help?
A spreadsheet can work for a manageable roster. When several people edit schedules, sites change, or confirmations and attendance are tracked separately, a shared workflow becomes more useful. Test a complete planning month with your team before switching.
With Shiftor, you can plan shifts, assign employees, publish rosters, and connect the schedule to QR attendance. Explore shift planning · Check pricing · Try the demo
Find the right scheduling workflow for your team
Shift schedule template and guide
Calculate coverage and download an example employee schedule.
Employee scheduling software
Manage availability, shifts, and attendance together.
Shift scheduling app
Go from a first schedule draft to a published roster.
Scheduling for cleaning companies
Assign cleaning teams across customer worksites.
Scheduling for security companies
Coordinate posts, shifts, and attendance on site.
Small business shift scheduling
Start with one team and expand scheduling as you grow.
Replace spreadsheet rosters
Keep schedule changes and publishing in one place.