Templates
Shift Plan Excel – & workplace-ready free
Free shift plan excel template for Excel and Google Sheets. Shift models, rest periods, mini-job checks, and printable PDF export for shift teams. Download now.
- 100% free
- Workplace-ready
- Excel & Google Sheets
How does a professional shift plan look?
A professional shift plan clearly shows who works when—with name, date, shift times, and optionally roles or departments. The shift plan Excel template by Ordio offers ready-made columns, automatic working-time calculation, and hour totals per employee. You enter names and shifts—the template calculates the rest. Ideal for 24-hour operations (care, clinics), hospitality, and retail.
A clear plan supports fair rotas, reduces scheduling conflicts, and helps you align with wage and hour rules. In the United States, the Fair Labor Standards Act (FLSA) governs hours, overtime, and records for non-exempt employees; many states add meal breaks and rest rules. In the United Kingdom, the Working Time Regulations 1998 set weekly limits, rest breaks, and daily rest between shifts—planning with adequate gaps between shifts is essential.
The template supports common shift patterns—from early/late splits to three-shift and 24-hour coverage. For simpler weekly planning without rotation, try our duty roster Excel template. Shift model details are below.
Workplace-ready planning
Workplace-ready planning: The template helps you publish rosters with clear shift times and automatic hour totals—simple, efficient, and transparent without expensive software or monthly subscriptions.
Design and content
The template is free and ready to use in Excel or Google Sheets. No registration—download and start immediately. Columns are preconfigured and formulas are installed. Perfect for bakeries (breakfast shifts), clinics (24-hour cover), and hospitality with changing rotas.
The design is deliberately simple: clear columns for names and weekdays, uniform time formats. You stay on top of larger teams. Optionally use colours for shift types (e.g. blue for early, green for late, grey for night)—the template stays flexible.
A professional shift plan always includes: name, date, shift times, and where relevant roles or departments. The Ordio template covers all these elements.
Edit and use the shift plan Excel template
Download the free Ordio shift plan template and open it in Excel or Google Sheets. Follow these steps.
- Edit employee list: Enter employee names in the first column. Extend or shorten the list at any time—add new rows as needed. For larger teams, alphabetical sorting helps.
- Add shifts: Enter shifts in weekday cells—for example 06:00-14:00, 14:00-22:00, or 22:00-06:00 for three-shift cover. Use a consistent format (e.g. 06:00-14:00) so the template recognises times correctly.
- Create a rotating shift plan: How do you build a rotating schedule in Excel? Enter one week's pattern (e.g. Week 1: early, Week 2: late, Week 3: night) and copy it to following weeks. The template handles calculation—you maintain the pattern.
- Review totals: The template automatically calculates working hours and flags high totals. You can see if someone approaches overtime or if rest between shifts looks tight. Cross-check completed weeks with our timesheet template.
- Adjust: Customise rows and columns, use colours, and optimise the layout for your industry. Optional: enable sheet protection so formulas are not changed accidentally—important for shared files.
- Export: Save as PDF for the notice board. You can keep the template locally—no cloud required.
After the steps
For rotating plans: apply one week's pattern and copy it to following weeks. This saves several hours each month. The shift plan template suits all industries—from bakery to clinic.
Sheet protection: In Excel, go to Review → Protect Sheet. You can allow editing only in shift cells while protecting formulas. Several people can work on the same file without accidental deletions.
Export as PDF when you need a posted copy. Update the template regularly and use it as a reference for payroll.
Shift patterns: early/late, three-shift, and 24-hour
The Ordio template works for all common shift patterns. You enter the times—the template handles calculation and hour totals. No manual formulas required.
The shift model depends on your industry and opening hours: bakeries often use early shifts; clinics and care need 24-hour cover. Three-shift operation is standard in production—early, late, and night rotation. The table below gives an overview.
| Model | Typical times | Typical for |
|---|---|---|
| Early/late | 06:00-14:00, 14:00-22:00 | Retail, hospitality |
| Three-shift | 06:00-14:00, 14:00-22:00, 22:00-06:00 | Production, care, clinics |
| 24-hour | Rotating shifts, continuous cover | Care, security, logistics |
Plan shifts with the Excel template
With the Ordio template you plan shifts quickly and with clear hour visibility. Automatic calculation reduces errors in overtime and part-time totals.
Example for 8 employees
Enter names in the first column—for example Alex, Jordan, Sam, Taylor, Morgan, Casey, Riley, and Jamie. For a typical week with early/late splits: Alex and Jordan work Mon-Fri 06:00-14:00; Sam and Taylor 14:00-22:00. Morgan and Casey cover the weekend; Riley and Jamie are on leave.
The template sums hours per person: Alex has 40 hours, Morgan 16—you see if someone approaches overtime under FLSA or high weekly totals under UK rules. When someone is sick: enter cover, the template updates totals. You keep track of leave, illness, and absences—important for fair distribution and compliance.
Assign employees to shifts: start with fixed full-time patterns, then fill gaps with part-time staff. The template shows whether coverage fits.
Reuse and publish
The template is free, needs no registration, and works in Excel or Google Sheets. You save time, reduce mistakes, and stay organised. Save a copy as a template for the next month. Publish rosters early so staff can plan—many US states and UK employers benefit from advance notice even where not strictly mandated.
You can duplicate the shift plan template—for example one sheet per month or department. This keeps history for comparison. For multiple locations or automatic suggestions, Ordio employee scheduling is a cloud-based alternative.
When is shift planning software worth it?
For small teams (up to five people), the shift plan Excel template is often enough. You download the template, add shifts, and you are done. The template is free, works offline, and needs no onboarding. Perfect for getting started with shift planning.
From five employees, planning gets more complex: leave, illness, qualifications, and preferences. Then Ordio employee scheduling is worth considering—the cloud software plans automatically, accounts for all factors, and saves considerable planning time. With mobile apps, employees can view their rota and submit requests. Software complements the Excel template for teams that need more automation.
Many companies in hospitality, retail, and care use Ordio. Start with the free Excel template and move to the full version when your team grows. Ordio time tracking connects seamlessly to scheduling—plan and record hours in one system. No double entry. The template remains useful as backup or for smaller departments.
Frequent errors in shift planning
Typical shift-planning mistakes cost time, money, and morale. Many teams plan in Excel for years and overlook wage and hour gaps until an audit or employee complaint.
Common pitfalls
Publish rosters early enough for staff to plan. The Ordio template helps you avoid:
- Insufficient rest between shifts: UK Working Time Regulations typically require 11 hours daily rest; US state rules may require meal and rest breaks. If a shift ends at 22:00, the next should not start before 09:00. The template highlights tight turnarounds—manual planning can miss these, especially on night rotas.
- Late publication: If you publish the next week on Friday, there is little buffer for call-outs. Plan at least one to two weeks ahead and export as PDF in time.
- Overtime overlooked: Under FLSA, non-exempt US employees earn overtime after 40 hours in a workweek. Without automatic totals, teams exceed limits unnoticed—with payroll and compliance consequences. The template warns you in time.
- Double bookings: Two employees assigned to the same shift? This happens quickly when planning manually. The template shows all shifts at a glance—check before publishing. Especially common with shift swaps or cover.
- Unfair distribution: Always the same people on weekends or nights? This leads to dissatisfaction. Use rotating patterns and document distribution—the template helps you keep overview.
- Minimum wage gaps: UK NMW/NLW and US federal/state minimum wage require correct hourly rates—hour totals from the template support payroll review.
With the Ordio template
With the Ordio shift plan template you significantly reduce planning errors. Automatic calculation and totals save rework and compliance risk.
Tip: Review rest gaps and hour totals before publishing—a short check prevents later corrections. The template does not replace legal advice but helps you keep key requirements visible.
Operating in Germany? German working-time rules differ—add local checkpoints with your adviser if you run a German site.
Template vs. software: when to switch?
The Excel template is ideal for getting started and small teams. Many companies ask: stay with Excel or switch to software? The answer depends on team size, planning complexity, and requirements.
Stay with the template when
You have up to five employees, planning is manageable, and you do not need automatic suggestions. The template is free, works offline, and needs no onboarding. Perfect for bakeries, small restaurants, or trades with stable shift patterns. Also often sufficient for retailers with fixed opening hours or practices with set appointment slots. You have full control over the file—no subscription or monthly costs.
Switch to software when
Your team grows (from five to eight or more), leave and absences complicate planning, or you coordinate several locations. Ordio employee scheduling plans automatically, accounts for preferences and qualifications, and saves considerable planning time. Integration with time tracking eliminates double data entry. Employees view their rota, submit requests, and apply for leave in an app. You get conflict alerts and can replan in a few clicks.
The switch is possible at any time: start with the free template, test software as needed, and move when it fits. Both options support US FLSA and UK Working Time Regulations awareness through clear hour totals and published rotas.
Many companies use the template in parallel: Excel for small sites or departments, Ordio for the main operation. Moving from template to software usually takes only a few days. Ordio offers a free trial so you can try the software without obligation.
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 – free & workplace-ready
How can I create a shift plan?
With the free Ordio shift plan Excel template you build a plan in minutes: enter staff and shifts after download. The template supports common patterns (including three-shift and 24-hour models) and calculates working hours automatically. Check totals against US FLSA overtime rules and UK Working Time Regulations before you publish; larger teams can use Ordio shift planning in the cloud.
How do I create a shift plan in Excel?
Download the Ordio shift plan Excel template and open it in Excel or Google Sheets. Enter names and shifts—the template calculates hours per person and week. Ideal for hospitality, retail, and care in the US and UK. Free to download; align pay with federal minimum wage in the US and National Minimum Wage in the UK where applicable.
Can I create a shift plan in Google Calendar?
Google Calendar suits simple appointments, not shift plans with hour totals and rest planning. Use the Ordio template in Google Sheets so formulas stay intact. UK teams should still respect Working Time Regulations for weekly hours and rest; US teams should track hours for FLSA overtime. For teams of five or more, Ordio shift planning is worth a look.
How do you build a shift plan in Excel?
Open the free Ordio shift plan template, list staff in the first column, and assign shifts to weekdays. The template totals hours so you can spot overtime or understaffing early. You save time versus a blank workbook—and it fits many shift patterns used in US and UK operations.
How do I make a shift plan in Excel (step-by-step)?
Download the Ordio shift plan Excel template, open it in Excel or Google Sheets, and fill in names and shifts. Built-in formulas handle hour totals; review the plan against your policies and HSE or OSHA expectations for safe coverage where relevant. Free download—ready in minutes.
How do I create a rotating shift plan in Excel?
Use the Ordio shift plan template: enter the pattern for one week and copy it to following weeks. It supports rotating models including three-shift and 24-hour operation, with automatic hour totals. Watch average weekly hours under UK Working Time Regulations and daily or weekly overtime under the FLSA in the US.
How do I build a rotating shift plan in Excel?
With the Ordio template, define the shift pattern for week one and roll it forward. Hours are calculated for you. For very complex rotations or multi-site teams, Ordio shift planning automates more of the work while you keep pay and rest rules aligned with UK and US requirements.
How do I create a shift plan in Excel?
Download the free Ordio shift plan Excel template and open it in Excel or Google Sheets. Enter staff and shifts—the template calculates hours automatically. Ideal for hospitality, retail, and care. Ready in minutes; confirm rest breaks and pay rates with your HR or payroll adviser.
Can you create a shift plan in Excel?
Yes. The free Ordio shift plan Excel template includes formulas for hour totals—you only enter names and shifts. Works in Excel and Google Sheets, free to download. Use it as a practical roster for US and UK teams; this is operational planning, not legal advice.