Templates
Duty roster Excel template free & workplace-ready
Download a free duty roster template for Excel or Google Sheets—the same plan many teams call a staff roster or rota. You get working-time checks, hour totals per person, and CSV export when payroll needs clean numbers.
- 100% free
- Workplace-ready
- Excel & Google Sheets
What is a duty roster and why do you need an Excel template?
A duty roster is a published schedule of who works which shifts on which days. In the UK people often say rota; in the US you may search for a staff schedule Excel template or staff roster. A duty roster Excel template gives you that grid ready-made: shift times, formulas for working hours, and weekly totals per employee without rebuilding a blank sheet every month.
Clear rosters cut no-shows, make shift swaps visible, and give payroll a defensible hour picture. When the plan is missing or late, overtime creeps up, part-time caps get missed, and staff cannot plan around their shifts.
Duty roster vs shift plan vs weekly schedule
Choose this download when you want a rolling staffing roster (including a rota template in Excel for UK teams) with people, days, shifts, and hour totals in one workbook. Use the shift plan Excel template when you run fixed rotations or 24/7 coverage (early/late/night blocks). Use the weekly schedule template for a single-week wall planner without the longer roster tabs and cost overview.
What is inside the workbook
Beyond the roster grid you get an Employees list, Compliance checks (rest gaps and hour totals), a Cost overview for payroll review, and CSV export when you move data into payroll or scheduling software. Industry presets speed up common patterns in hospitality, retail, healthcare, and trades.
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 the Instructions sheet first, then Employees and Roster.
Worked examples: hour totals before payroll
These two scenarios show how the Roster sheet totals hours per person and week. Run the same checks on your live file before you lock payroll or send the rota to staff.
Café team (8 staff, one week)
Four baristas work 09:00–17:00 (8 h) Monday–Friday; two cover 14:00–22:00 (8 h) on weekends. Each row totals 40 h for the week; anyone above 40 h in the FLSA workweek stands out on the Compliance sheet before you run payroll. After the period closes, compare roster totals with the timesheet template or your time-tracking export.
UK care home (split shifts)
Three carers rotate early (07:00–15:00) and late (15:00–23:00) 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 rest gaps before you publish the roster.
How to create a duty roster in Excel: step-by-step
If you are learning how to make a duty roster in Excel, start on the Instructions sheet, then work through the tabs below. Open the file in Excel or Google Sheets; you do not need a paid account to use the template.
- Employees: Enter names, hourly rate, target weekly hours, department, and employment status. This list drives the roster dropdowns and cost totals.
- Roster: Assign shifts by day (for example 09:00–17:00 or 14:00–22:00). Common time formats are recognized; net hours per day and per week update automatically.
- Compliance: Scan hour totals, rest-between-shifts gaps, and break planning 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.
- Publish or hand off: Print or save as PDF for the notice board, or export CSV for payroll or import into Ordio scheduling.
When the team grows or swaps pile up, scheduling software can propose shifts, track leave, and notify phones. Until then, many managers treat this workbook as the weekly source of truth or a backup for a second site.
Why this free duty roster template helps with hours and pay
For US and UK teams that still plan in Excel or Sheets, the workbook keeps hour totals and wage checks in one place instead of scattered notes.
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.
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 under-hours or rate mismatches before payroll closes—not after employees notice on their payslip.
For hospitality, retail, and care
Presets and columns fit bakery opens, shop floor cover, and care rotas—plus CSV export when you outgrow manual copy-paste into payroll.
Tips for building a fair, publishable roster
Publish at least one week ahead when you can, and update the roster the same day when someone calls in sick. Rotate unpopular shifts so the same people are not always on closes or weekends.
Planning habits
- Track overtime and part-time hour caps on the Compliance sheet before payroll closes.
- For rotating patterns, copy a clean week forward instead of retyping names and times.
- Save a monthly master file (for example
roster-2026-09.xlsx) so you keep formulas and only change dates and absences. - Version PDFs or dated exports if you need to show what was published for a given week.
Legal compliance
- United States: Confirm FLSA overtime for non-exempt staff; many states add meal, rest, split-shift, or fair workweek rules.
- United Kingdom: Plan daily rest under the Working Time Regulations 1998 and check NMW/NLW against paid hours (see common mistakes below for rest-between-shifts examples).
- Give staff reasonable notice of shift changes where your policy or sector guidance requires it.
- Reconcile the roster with actual hours from time tracking or timesheets—small drifts add up across a team.
Common mistakes when building a duty roster
Most roster problems are predictable: late publication, missed overtime, and unfair shift distribution. This template does not replace legal advice, but it surfaces these issues while you can still edit the file.
Pitfalls to avoid
- Insufficient rest between shifts: UK Working Time Regulations often require 11 hours between the end of one shift and the start of the next. 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 or unclear publication: Publishing the next week on Friday leaves little room for swaps or childcare. Aim for one to two weeks ahead when possible, and 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. The Compliance and Cost overview sheets exist so you fix hours before the pay run.
- Double bookings and gaps: Two people on the same shift—or nobody on a cover slot—happens quickly when you edit manually. Scan the roster grid before export.
- Unfair rotas: The same employees on every close or weekend drives attrition. Rotate weekends and nights using copy-forward weeks so the pattern is auditable.
A five-minute review of hour totals, rest gaps, and coverage beats rework after staff push back—or after a wage-and-hour question.
Excel vs Google Sheets for your duty roster
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 rota in the browser.
| 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 |
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 rota 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 shifts | 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 duty roster Excel template on this page fits many cafés, shops, and single-site care 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 stable shift patterns. One manager can own the file each week, you want 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.
Hybrid setups are normal: Excel for a pop-up or second site, cloud scheduling for the main rota. Download here first; try software when weekly edits regularly take more than an hour.
Plan rosters with Ordio
Save planning time and cut scheduling errors by up to 95%
50% less planning time
AI-assisted roster planning saves valuable time
Better staff utilization
Smarter shift distribution across your team
Planned vs. actual reporting
Compare planned and actual hours automatically
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 Duty roster Excel template
What is a duty roster?
A duty roster is the plan that shows who is on shift each day and when, by role, site, or department. In the UK the same idea is often called a rota; in the US you may hear staff 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 duty roster in Excel?
Download the free template on this page and open it in Excel or Google Sheets. Add names on the Employees sheet, enter shifts on the Roster sheet, and review totals on Compliance and Cost overview. Print or export PDF for staff; keep a dated copy if you need records for FLSA or UK Working Time Regulations reviews.
How can I create a free duty roster?
Use the free download on this page: no fee for the Excel file and no subscription to edit it locally. Open it in Excel or Google Sheets, list your team, and fill in shifts. Built-in formulas total hours per person so you can post a free duty roster template your staff can rely on.
How do I make a duty roster in Excel?
From a blank sheet you would add columns for names and days, enter shift start and end times, then write formulas for daily and weekly hours. That works for a one-off plan but breaks easily when people join or swap shifts. The free template on this page already includes the Employees list, Roster grid, and Compliance totals—so you fill cells instead of rebuilding formulas each week.
Which duty roster app is the best?
For hospitality, retail, and care, many teams start with the free Excel template, then move to Ordio employee scheduling when they need approvals, notifications, and live rotas on mobile. Compare options on team size, sites, swap workflows, and whether you need integrated time tracking, not just a shared calendar.
Who is allowed to create a duty roster?
Usually the employer, a line manager, or HR owns shift planning. Document who updates the rota and how staff are told about changes. A free Excel template lets that person build a clear plan without installing software first. Check sector guidance too, for example UK HSE expectations in higher-risk settings, alongside your normal HR policies.
Which duty roster app is free?
The Ordio duty roster Excel template is free to download—no subscription for the workbook. Ordio also offers trial access to its shift planning software when you outgrow spreadsheets. The template is a practical starting point for US and UK small businesses that need clear weekly coverage without a full workforce system on day one.
Can ChatGPT create a duty roster?
ChatGPT can draft shift ideas in text, but it will not give you a working Excel file with formulas, weekly totals, and a Compliance review tab. For a roster you can actually run in payroll, use a purpose-built template that sums hours per person and flags gaps before you publish. Pair that with your policies on notice periods and fair shift allocation under FLSA or UK Working Time Regulations.