How to Make a Shift Schedule: Free Template (2026)

Most shift managers learn scheduling the hard way: a blank spreadsheet on a Sunday night, a stack of time-off requests, and the quiet dread of knowing that whatever you publish, someone will be unhappy. The good news is that building a solid shift schedule is a repeatable process, not a talent. This guide walks through it step by step, gives you a free template structure you can recreate in any spreadsheet today, and is honest about the moment a spreadsheet stops being the right tool.

In short: to make a shift schedule, you gather four inputs — demand per time slot, staff availability, skills, and legal rest rules — place the hardest-to-fill shifts first, balance unpopular slots measurably across the team, and publish at least a week ahead. The template below implements exactly that in Excel or Google Sheets, free.

The scheduling-software market is growing fast — Grand View Research projects the scheduling apps category to keep expanding through 2033, and in 2026 nearly every workforce suite has added an AI scheduling feature. But you do not need to buy anything to schedule well. You need a clear method. Let's build one.

Before you build: gather four inputs

A schedule is only as good as the information behind it. Skipping this step is the single most common reason rosters fall apart mid-week. Collect these four things before you place a single shift.

• Demand: how many people you need, by role, for each part of each day. Pull this from sales data, footfall, bookings, or patient load — not from gut feel.
• Availability: who can work when, including fixed unavailabilities (a second job, childcare, classes) and approved time off.
• Skills and certifications: who is qualified for which role, and any rule that a shift must include at least one qualified person (a keyholder, a senior nurse, a first-aider).
• Rules: legal and internal constraints — minimum rest between shifts, maximum consecutive days, overtime thresholds, and any predictive-scheduling notice laws in your region.

The step-by-step method

Step 1 — Map demand to a coverage grid

Start from the floor, not the people. Draw a grid of days across the top and time blocks down the side, and in each cell write how many of each role you need. This coverage grid is your target. Build it before you think about any individual employee, so your schedule is driven by what the business actually needs rather than by who asked for what first.

Step 2 — Place your fixed and hardest-to-fill shifts first

Lock in the non-negotiables before the easy slots: the overnight shift only two people can cover, the Sunday open that needs a keyholder, the role with a single qualified person. If you fill the flexible shifts first, you will almost always paint yourself into a corner where the one hard shift has no one left to take it.

Step 3 — Fill the rest against availability

Now place everyone else, checking each assignment against availability and rest rules as you go. Track running totals for each person — hours this week, weekends worked, closing shifts — in a column beside the grid. Those totals are what let you keep the schedule fair instead of accidentally loading the same reliable person every time.

Step 4 — Audit for fairness and fragility

Before publishing, run two checks. The fairness check: is the unpopular work (nights, weekends, splits) spread evenly, or has it quietly concentrated on a few people? The fragility check: if one person calls in sick, does the whole day collapse? A schedule with no slack is a schedule that will page you on your day off.

Step 5 — Publish early and make changes visible

Publish as far ahead as you can — two weeks is a good target, and in some regions predictive-scheduling laws require advance notice. When changes happen, make sure everyone sees the current version, not a stale printout. Confusion about which version is live causes more no-shows than the changes themselves.

A free shift schedule template you can copy

You can build a workable template in any spreadsheet in about ten minutes. Here is the structure that covers the essentials without becoming a maintenance burden.

• Column A: employee name. Column B: role. Column C: contracted or max weekly hours.
• Columns D–J: the seven days of the week. In each cell, enter the shift time (e.g. 09:00–17:00) or leave blank for a day off.
• Column K: a formula totalling weekly hours per person, so you can spot overwork and under-utilisation at a glance.
• A second sheet holding your coverage grid from Step 1, so you can compare what you scheduled against what you needed.
• Conditional formatting that flags anyone over their max hours in red — your cheapest early-warning system.

That template will carry a small, stable team a long way. Keep it. Free is the right price until the spreadsheet starts costing you in a different currency: time and errors.

When the spreadsheet starts costing you

A template is fine until a few thresholds quietly pile up. Watch for these signals — when several are true at once, manual scheduling is no longer the cheap option, it just looks like it.

• Scheduling regularly eats more than two or three hours of your week.
• You have crossed roughly 15–20 people, multiple roles, or several locations.
• Last-minute swaps and sick calls mean the published sheet is wrong by Tuesday.
• You keep making honest mistakes — double-booking, missed rest periods, someone over their hours — because the rules no longer fit in your head.
• Staff complain the unpopular shifts are unfairly distributed, and you have no easy way to prove or fix it.

Common 24/7 shift patterns worth knowing

If you run around-the-clock coverage, do not reinvent the rotation — adapt a proven pattern. The 2-2-3 (Panama) schedule cycles two 12-hour teams through 2 on, 2 off, 3 on across a 28-day cycle, averaging 42 hours a week with every other weekend off. 4-on-4-off runs four days of 12-hour shifts followed by four days off — simple and predictable, at roughly 2,190 hours a year. DuPont and Pitman variants mix day and night blocks with a full week off per cycle. Each pattern trades fatigue, weekends and headcount differently; pick the one your coverage math and your team's stamina can actually sustain.

The legal minimums managers miss

Rest rules vary sharply by jurisdiction, and they belong in your template as hard checks, not afterthoughts. In the EU and UK, workers are entitled to 11 consecutive hours of daily rest and a cap of 48 average weekly hours. In the US there is no federal minimum rest between shifts — but Oregon's fair-workweek law mandates 10 hours' rest and 14 days' schedule notice, Los Angeles County enforces predictability pay, and Chicago's fair-workweek thresholds are CPI-indexed and rising. The UK's Employment Rights Act 2025 adds guaranteed-hours and shift-notice rights from 2027. If a pattern in your spreadsheet quietly violates one of these, the spreadsheet will not tell you.

Frequently asked questions

How far in advance should a shift schedule be posted?

Two weeks is the standard worth aiming for; one week is the practical minimum. Some jurisdictions make this law — Oregon requires 14 days' notice — and everywhere else, late schedules simply generate the swaps and no-shows you are trying to avoid.

Is Excel good enough for shift scheduling?

For a small, stable team: yes, and this template will carry you a long way. Past roughly 15–20 people, multiple roles or locations, and frequent last-minute changes, the hidden costs — manager hours, rule violations, unfair rotations — outgrow the price of proper scheduling software.

What is the fairest way to assign night and weekend shifts?

Count them. Track nights, weekends and closes per person next to the hours column and rotate based on the numbers, not on who complains least. Fairness that is measured is fairness the team can trust.

How many staff do I need for 24/7 coverage?

As a rule of thumb, covering one position around the clock takes at least four full-time people once rest rules, days off and leave are accounted for — most operations plan 15–20% headroom above bare coverage to absorb sickness and holidays.

This is exactly the gap imRoster is built to close. You keep the control and judgement that make you good at your job; the software handles the arithmetic you should not be doing by hand. Give it your people, roles, rules, and demand, and it generates a balanced draft schedule in minutes — spreading unpopular shifts fairly, flagging coverage gaps and rule conflicts before they bite, and keeping everyone on the same live version. If your Sunday-night spreadsheet has started to feel like a second job, it is a good moment to try imRoster instead.