ShiftorShiftor Admin
Try demo for free

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 template

Create your employee schedule in five steps

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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