Free · printable · no sign-up
Shift Schedule Template for Excel
Grab a free, editable Excel shift schedule template — or skip the spreadsheet and build it online.
Pick a rotation and Auto-fill to assign each person to a crew (A/B/C/D) on a real pattern — or click any cell to set it by hand (it cycles through your shift types, then Off, then blank). Day-off templates can mark weekends, Sundays, or US federal holidays off for the whole team in one step, and the week-copy tools help you roll a finished 7-day rota forward without re-clicking every cell.
| Staff | Shifts | |||||||
|---|---|---|---|---|---|---|---|---|
| Alex Rivera | 0 | |||||||
| Sam Chen | 0 | |||||||
| Jordan Lee | 0 | |||||||
| On duty | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Best fit
Best shift patterns for excel teams
If you want a repeatable rotation instead of building each week from scratch, these are the closest pattern fits for excel scheduling.
Which shift pattern should excel teams choose?
If you are templating a roster in a spreadsheet, simpler repeating patterns are usually easier to maintain month after month.
| Pattern | Cycle | Shift length | Best when |
|---|---|---|---|
| Fixed Weekly | 7 days | 8 hours | Best when your team works a steady week and does not need a full day/night rotation. |
| 2-2-3 | 14 days | 12 hours | Best all-rounder for four-crew 24/7 teams that want frequent breaks and no more than three shifts in a row. |
Use the page-level maker above when you want to assign shifts by hand. Use one of the pattern generators when you want a rota that repeats cleanly and is easier to share, print, and explain to the team.
What is in the Excel template
The free weekly and monthly templates come pre-built: a row per employee, day columns, a shift key (M / D / E / N / O), and a Total Hours column that adds up automatically from the codes you type. Drop-downs in each cell keep entries consistent.
How to use it
Open the file, type a shift code in each cell (M for morning, N for night, and so on), and the hours total themselves. Print directly from Excel, or use the printable PDF if you want a blank sheet to fill in by hand.
Excel vs. the online maker
Excel is worth it when you need to calculate on top of the roster — summing hours, flagging overtime, feeding payroll. If you just need to assign shifts and print, the online maker is faster. Many teams do both: plan online, export CSV, crunch numbers in Excel. More in the Excel vs online guide.
Keep an Excel roster controlled after it leaves the template
Before editing the template, define a short shift key that everyone understands and keep it consistent. Use clear labels and times, then verify that the total-hours formula matches the values your site intends to count. A spreadsheet can calculate quickly, but it will also repeat an incorrect assumption across every row if the key is unclear.
Avoid uncontrolled copies. Keep one editable master, give the published version a date, and decide who can alter formulas, shift codes, or employee details. Exporting a PDF for a noticeboard separates the readable staff copy from the working spreadsheet, while a CSV can be used for a separate review where appropriate.
Review the spreadsheet by shift and by employee. The first check finds coverage gaps and missing roles; the second finds uneven hours, closes, weekends, or short turnarounds. If the calendar changes after publication, update the master and reissue the current copy instead of asking staff to reconcile several attachments.
Keep going
Other makers & templates
Frequently asked questions
Is the Excel template free?
Yes — the weekly and monthly .xlsx templates are free to download and edit, no sign-up.
Do the hours total automatically?
Yes. Type shift codes in the day cells and the Total Hours column sums them using the built-in shift key.
Can I use it in Google Sheets?
Yes. Upload the .xlsx to Google Sheets; the layout and totals carry over.