Templates
Shift plan Excel template free & workplace-ready
Download a free shift plan Excel template for rotating teams—use as your shift schedule in Excel or Google Sheets, with FLSA and UK checks, hour totals, and PDF export.
- 100% free
- Workplace-ready
- Excel & Google Sheets
What is a shift plan and when do you need this Excel template?
A shift plan (many UK teams say shift rota or shift schedule) shows who works which block across days or weeks—especially when you run rotating schedules, three-shift production, or 24/7 coverage. This free Excel template gives you that grid with formulas for working hours and weekly totals, so you are not rebuilding a blank workbook every cycle.
Clear plans cut swap confusion, surface overtime early, and help you plan rest between shifts. When the rota is late or missing, coverage gaps, unfair night rotations, and payroll surprises follow.
Shift plan vs duty roster vs weekly schedule
Choose this download when you need rotation-heavy planning (early/late/night patterns, continuous operations, copy-forward weeks). Use the duty roster Excel template for a staffing rota with roster, compliance, and cost tabs without the shift-model focus. Use the weekly schedule template for a single-week wall planner without the longer shift-plan workbook.
What is inside the workbook
You get an Instructions tab, an Employees list, the Shift plan grid, Compliance checks (rest gaps, breaks, hour totals), and a Cost overview for payroll review—plus CSV-friendly export when you hand off to payroll or scheduling software. Presets fit hospitality, retail, healthcare, and production teams.
US and UK compliance (general information)
US and UK compliance (general information): Under the Fair Labor Standards Act (FLSA), US employers must track hours and overtime for non-exempt staff; state laws may add meal, rest, and predictive scheduling rules. In the UK, the Working Time Regulations set weekly limits and rest between shifts; National Minimum Wage and National Living Wage apply to paid hours. Confirm rates, classifications, and sector rules with your payroll provider or adviser—this template is not legal advice.
The workbook is free for Excel and Google Sheets and does not require a paid account to download. Open Instructions first, then Employees and Shift plan. Shift types use validated dropdowns; overnight blocks that cross midnight still roll into the correct day column. Compliance and Cost overview include summary charts once you enter data.
Worked examples: rotations and hour totals
These scenarios show how the Shift plan sheet totals hours per person. Run the same checks on your live file before you lock payroll or post the rota—not only on the sample rows in the download.
Three-shift factory (12 staff, one week)
Four operators rotate early (06:00–14:00), four late (14:00–22:00), and four night (22:00–06:00) across Monday–Friday. Each full shift row totals 40 h for the week; anyone above 40 h in the FLSA workweek stands out on Compliance before payroll. Copy week one forward for the rotation pattern instead of retyping names.
UK 24/7 care (split blocks)
Six carers cover day and night blocks with at least 11 hours between the end of one shift and the start of the next. Weekly hour totals help you stay within Working Time Regulations limits; the Compliance sheet highlights tight turnarounds before you publish.
Restaurant early/late (US weekend cover)
Servers work Fri–Sun 16:00–23:00 while weekday lunch shifts stay 10:00–16:00. Part-time rows may sit near 30 h while full-time kitchen staff hit 40 h—the Cost overview sheet helps you spot overtime before you post the schedule. Pair with the timesheet template if you also log actual clock times.
How to create a shift plan in Excel: step-by-step
If you are learning how to create a shift plan in Excel or building a rotating shift schedule in Excel, start on the Instructions sheet, then work through the tabs below.
- Employees: Enter names, hourly rate, target weekly hours, department, and status. This list drives dropdowns on the Shift plan sheet and payroll totals.
- Shift plan: Enter daily hours or shift blocks (for example 06:00–14:00, 14:00–22:00, or 22:00–06:00). Pick a shift type from the dropdown where provided; net hours per day and week update automatically.
- Compliance: Review hour totals, rest-between-shifts gaps, break rules, and weekly limits before you publish. Fix tight turnarounds while the sheet is still editable.
- Cost overview: Compare weekly and monthly hours and payroll cost against your pay rules and part-time thresholds.
- Publish or hand off: Print or save as PDF for the notice board, or export CSV for payroll or import into Ordio scheduling.
- Optional — protect formulas: In Excel, use Review → Protect Sheet so colleagues can edit shift cells without breaking calculations. In Google Sheets, restrict ranges the same way if several managers share the file.
For rotating plans, enter one clean week and copy it forward. Cross-check worked hours with the timesheet template or time tracking export when the period ends.
Why this free shift plan template helps rotating teams
For US and UK teams that still plan shifts in Excel or Sheets, the workbook keeps rotation patterns, hour totals, and wage checks in one file—without rebuilding formulas every time someone joins or you copy a rotation week forward.
FLSA and UK working time aware
Automatic hour totals support FLSA overtime review (40 hours per workweek for many non-exempt US employees) and UK Working Time Regulations weekly limits. Use the Compliance sheet before you publish so problem shifts are fixed in the file, not on the shop floor.
Three-shift and 24/7 patterns
Early/late splits, three-shift rotation, two-shift day/night, and continuous cover fit production, care, and security—without manual formula rebuilds each month.
Minimum wage visibility
Hour totals on the Cost overview sheet help you verify pay against federal and state minimum wage (US) and National Minimum Wage / National Living Wage (UK). Catch underpayment or rate mismatches before payroll closes—not after employees question their payslip.
Shift patterns: early/late, two-shift, three-shift, and 24-hour
Enter your times—the template handles calculation and hour totals. Pick the model that matches your opening hours and rotation rules. In three-shift rotas, many teams rotate early → late → night → off so no one is permanently on nights. When a block crosses midnight (for example 22:00–06:00), enter start and end on the Shift plan sheet; net hours still feed weekly totals and Compliance.
| Model | Typical times | Typical for |
|---|---|---|
| Early/late | 06:00–14:00, 14:00–22:00 | Retail, hospitality |
| Two-shift (day/night) | 07:00–19:00, 19:00–07:00 | Warehouses, security, smaller 24/7 sites |
| Three-shift | 06:00–14:00, 14:00–22:00, 22:00–06:00 | Production, care, clinics |
| 24-hour | Rotating blocks, continuous cover | Care, security, logistics |
Tips for fair, publishable shift rotas
Rotating teams need the same discipline as a static rota—plus a visible pattern so nobody assumes they are on nights or weekends forever.
Planning habits
- Publish at least one week ahead when you can, and update the Shift plan sheet the same day when someone calls in sick or swaps cover.
- For three-shift models, copy a clean rotation week forward instead of retyping names and times cell by cell.
- Rotate weekends, nights, and bank-holiday cover; keep the pattern in the file so swaps stay auditable.
- Save a monthly master file (for example
shift-plan-2026-09.xlsx) so formulas stay intact—you only change dates, names, and absences. - Export a dated PDF or versioned copy when you need proof of what was posted for a given week.
Legal compliance (general information)
- United States: Confirm FLSA overtime for non-exempt staff; many states add meal, rest, split-shift, or fair workweek rules—especially when someone closes late and opens early the next day.
- United Kingdom: Plan daily rest and the 11-hour gap between shifts under Working Time Regulations; check NMW/NLW against paid hours on Cost overview.
- Give staff reasonable notice of shift changes where your policy or sector guidance requires it—night and weekend blocks need lead time for childcare and transport.
- After the period closes, reconcile planned hours with time tracking in Excel, the timesheet template, or your Ordio time tracking export—small drifts add up across a team.
Common mistakes when building a shift plan
Most shift-plan problems are predictable: late publication, missed overtime, and unfair night rotations. This template does not replace legal advice, but it surfaces issues while you can still edit the file.
Pitfalls to avoid
- Insufficient rest between shifts: UK Working Time Regulations often require 11 hours between shifts. If someone finishes at 23:00, a 07:00 start the next day is risky. US teams should check state meal, rest, and split-shift rules alongside FLSA hour records.
- Late publication: Publishing the next week on Friday leaves little room for swaps or childcare planning. Aim for one to two weeks ahead when possible; keep a dated PDF if you need proof of what was posted.
- Overtime discovered in payroll: Without weekly totals, non-exempt US employees can pass 40 hours unnoticed. Fix hours on Compliance before the pay run.
- Double bookings and coverage gaps: Two people on the same block—or nobody on a cover slot—happens quickly when you edit manually. Scan the Shift plan grid before export.
- Minimum wage and rate mismatches: Hour totals on Cost overview support payroll review against federal and state minimum wage (US) and NMW/NLW (UK)—catch underpayment before payslips go out.
- Unfair rotations: The same employees on every night or weekend drives attrition. Document copy-forward rotation weeks so the pattern is auditable.
A short review of hour totals, rest gaps, and coverage beats rework after staff push back—or after a wage-and-hour question.
Operating in Germany? German working-time rules differ—add local checkpoints with your adviser if you run a German site.
Excel vs Google Sheets for your shift plan
Both formats work with the Ordio download. Pick Excel when you plan offline or on a single manager laptop; pick Google Sheets when two or more leads edit the same rotation in the browser and need comment threads on swap requests.
| Microsoft Excel | Google Sheets | |
|---|---|---|
| Best for | Offline sites, familiar desktop workflow | Shared editing with managers in the browser |
| Formulas | Built into the Ordio file | Copy via download flow; formulas stay intact |
| Publishing | Print or PDF from Excel | Share view-only link or export PDF for staff |
| CSV / payroll handoff | Export from Cost overview | Download copy; export CSV the same way |
| Version control | Save dated copies locally; optional OneDrive/SharePoint | Shared drive; cell comments for swap notes |
Excel template vs shift planning software
Spreadsheets win on cost and control for small teams; software wins when leave, qualifications, and last-minute changes pile up. Many businesses use both: a master Excel shift plan at one site and cloud scheduling where the team is growing.
| Template (Excel) | Software (Ordio) |
|---|---|
| Free, local, up to ~5 people | Cloud, from 5 people, automatic suggestions |
| Manual: enter names and shift blocks | Automatic: leave, preferences, qualifications |
| Hour totals, CSV export, overtime visibility | Time tracking, mobile updates, Ordio CSV import |
| Best up to ~5 staff, one site | Multi-site, approvals, and leave workflows |
When to stay on Excel—and when to switch
The free shift plan Excel template fits many cafés, shops, and single-site care or production teams. Move to software when keeping the sheet up to date takes more time than the planning itself.
Stay on the template when
You have a small team, one location, and manageable rotation patterns. One manager can own the file each week with no subscription cost, and PDF or CSV exports are enough for staff and payroll.
Consider Ordio scheduling when
Leave, qualifications, multi-site cover, or swap requests arrive faster than you can update a spreadsheet. Ordio employee scheduling sends live rotas to phones, flags conflicts, and works with time tracking so worked hours match the plan. You can import via CSV and keep Excel as a backup for a second site.
A practical rule of thumb: if weekly rota edits take more than an hour, or you are retyping the same rotation because swaps never end, it is time to trial scheduling software—starting from the free download on this page.
Automate shift planning with Ordio
Save planning time and cut scheduling errors by up to 95%
50% less planning time
AI-assisted scheduling saves hours every week
Better staff utilization
Smarter shift distribution across your team
Automatic working-time rule checks
Built-in checks help you build compliant shift plans
Mobile app for everyone
Staff see schedules in real time and update availability
With Ordio:
See how Ordio automates your scheduling
Watch automatic checks save planning time · No obligation · 15 minutes
More free templates
Discover more Excel templates for planning, time tracking and HR.
Frequently asked questions about Shift plan Excel template
What is a shift plan?
A shift plan is a schedule that shows who works which time block across days or weeks—especially when you rotate early, late, and night shifts or run 24/7 cover. UK teams often call it a shift rota; US teams may say shift schedule. Employers use it to match staffing to demand, plan rest between shifts, and give people advance notice. A spreadsheet template adds automatic hour totals on top of that grid.
How do I create a shift plan in Excel?
Download the free template on this page and open it in Excel or Google Sheets. Add names on Employees, enter shifts on Shift plan, and review Compliance and Cost overview before you publish. For rotating patterns, copy one week forward instead of retyping the grid. AI chat tools can suggest patterns in text, but they do not ship a workbook with formulas and hour totals—use a purpose-built template when you need payroll-ready totals.
How do I create a rotating shift plan in Excel?
Enter the pattern for week one (for example early → late → night → off, or a two-shift day/night cycle) on the Shift plan sheet, then copy that week to the following weeks. Built-in formulas total hours per person so you can spot FLSA overtime or UK weekly limits before payroll. Longer patterns (for example 4-on/4-off) still start from one documented week in the file.
Can I create a shift plan in Google Sheets?
Yes. Download the template on this page and copy the workbook into Google Sheets so formulas stay intact. Google Calendar alone is weak for hour totals and rest-between-shifts planning—Sheets matches Excel for this shift plan layout.
What is the difference between a shift plan and a duty roster?
A shift plan focuses on rotating blocks and 24/7 or three-shift models. A duty roster is the broader staffing schedule many UK teams call a rota. Use this page for rotation-heavy Excel planning; use the duty roster template when you want the roster-first workbook layout.
How do I plan a 24-hour shift schedule in Excel?
List staff on Employees, then assign covering blocks on Shift plan for every period you must staff—two-shift day/night, three-shift, or rotating 24-hour cover. Review Compliance for rest gaps (for example 11 hours between shifts in the UK) and weekly hour totals before you export a PDF or post the rota.
What is a shift schedule Excel template?
It is a ready-made Excel or Google Sheets workbook for building a shift schedule: a Shift plan grid, hour formulas, Compliance review, and Cost overview. On this page it is the same free download as our shift plan template—one file for US shift schedules and UK rotas.
Is there a free shift plan Excel template?
Yes. Download the workbook on this page at no charge and edit it locally in Excel or Google Sheets—no subscription required. You get hour totals, Compliance checks, and Cost overview tabs built for US and UK small businesses.
When should I use shift planning software instead of Excel?
Stay on Excel while the team is small and one manager can own the file each week. Consider Ordio employee scheduling when leave, qualifications, multi-site cover, or mobile swap requests outgrow a shared spreadsheet—especially if you fix the same rotation errors every pay period.