Shift schedule template in Excel
Shift schedule template in Excel
Covering every day of the month with two or three shifts, holidays included, is one of those jobs that gets done from memory and forgotten just as easily. Someone writes on a slip of paper who opens on Saturday, someone else swaps a shift by message at the last minute, and by the time the day comes nobody is sure whether Sunday has anyone at all. The outcome is always the same: hours nobody covered, two people on the same shift and a day off that no one remembers asking for.
A shift schedule exists to put that planning in writing before the month begins. It does not record what happened, the way a timesheet or an attendance tracker does: it sets out what is going to happen, with a name on every day and a shift assigned to it, so the whole team can read it and so each person's day off stops depending on someone's memory.
This file is an Excel workbook with a grid of twelve employees across the thirty-one days of the month, a drop-down list of shifts in every cell and a summary that counts the days covered and splits them by shift. It also includes an instructions sheet with the step-by-step. There are no macros and no hidden data, and it opens in any recent version of Excel or in LibreOffice.
⬇ Download the template (Excel .xlsx)What a shift schedule is and who this template is for
A shift schedule is the table that states, for each day of the month and each person, which shift they are due to work and which days they rest. It reads like any calendar: days across the columns and people down the rows. What sets it apart from an ordinary calendar is that every cell holds a specific value, morning, afternoon, night or rest, and that value is picked from a list, so there is no way to write two different words for the same thing.
That detail looks minor and it is exactly what makes the difference. When shifts are written by hand, one month says "morning", the next says "AM" and the one after says "first shift", and comparing months becomes impossible. With a closed list the counting happens on its own: how many morning shifts, how many nights, how many rest days and, above all, how many days of the month were left uncovered.
The template is built for businesses that run extended hours: shops and warehouses open on Saturdays and Sundays, restaurants and bakeries, pharmacies, small plants with two or three shifts, security services, clinics and laboratories, workshops that work weekends, and cleaning or maintenance crews. It also works for internal areas that need to cover a phone line outside normal hours. It is not meant for operations with four rotating crews on a cycle that moves every week, where software that builds the rotation by itself is a better fit.
What the template includes
The file is ready to use from the first time it opens: the planning grid, the drop-down lists already applied, the monthly summary calculated and an instructions sheet. This is what you will find inside:
| Component | What it holds |
|---|---|
| Header of the format | Room for the business name, the month, the year and the person who prepared the schedule, so the sheet is identified. |
| Employee grid | Twelve rows, one per employee, with the name at the start of each row and space for anyone who joins during the month. |
| Days of the month | Thirty-one columns, one per calendar day, ready to take the shift that belongs to that date. |
| Shift drop-down list | The four options of the format, morning, afternoon, night and rest, applied to the whole grid, so nobody writes a shift under another name. |
| Monthly summary | Block with the days covered, the employees registered and the count of each shift, calculated from what was marked in the grid. |
| Instructions sheet | A guide with the recommended order for filling the grid and an explanation of how the summary count works. |
The columns of the sheet
The sheet has a single layout: people down the rows and days across the columns. That shape lets you read the whole month at once and, at the same time, run down a column to check that a given date is covered.
| Column | What goes in it |
|---|---|
| Employee | The person's full name, one row for each employee scheduled, up to twelve. It is best to write it exactly as it appears on payroll, so the sheets line up later without questions. |
| Days 1 to 31 of the month | One column per calendar day. In the cell you pick the shift for that date from the drop-down list, or leave rest when that person is off. |
| Month header | The business name, the month and the year, placed above the grid, so the sheet is identified when it is printed. |
| Summary block | The days covered, the employees registered and the count of each shift, placed below the grid as a reading of the month. |
How the schedule is split: an example with numbers
The schedule does not run complicated maths: it adds up what is marked. Every cell with a shift chosen counts as one scheduled day, and the summary groups those days by the shift that was marked. A small example makes it clear:
| Shift | Days marked |
|---|---|
| Morning | 6 |
| Afternoon | 4 |
| Night | 3 |
| Rest | 2 |
| Total for the month | 15 |
Three employees with five days marked each come to fifteen days covered, and the summary splits those fifteen across the four shifts. The count is a sum by row and by column: if the team marks six morning days, four afternoon days, three night days and two rest days, the summary closes at fifteen and no cell is left unexplained.
That total is the first check on the schedule. If the summary comes out lower than the number of days in the month multiplied by the number of active employees, there are blank cells, and blank cells are exactly the ones that end up as uncovered hours. Before publishing the schedule it is worth reading the count for each shift: a month with six night days and only one morning day may be perfectly fine if the business sells more at night, or it may be the sign that shifts were handed out at random.
Rest days behave in a similar way. If the rest count is low, someone is working too many days in a row; if it is high and concentrated on the same people, the split was not even. The summary decides nothing on its own, but it puts the imbalance in plain sight, and that is what later makes it possible to fix without an argument.
How to use the template step by step
The first schedule of the month takes a few minutes; with practice the sheet almost builds itself. The recommended order is this:
- Write the month, the year and the business name in the header, and the name of the person preparing the schedule if you wish, so everyone knows which period the plan belongs to.
- List the employees in the first column, one per row, until the team that will work that month is complete.
- Mark the rest days for the whole month first. Settling days off before shifts avoids the classic mistake of leaving someone with no rest because the grid was filled straight through.
- Pick the shift for each day from the drop-down list. If a date needs two people on the same shift, repeat the shift in both rows involved.
- Run down the grid column by column, day by day, and confirm that every date has at least one person assigned. Blank columns are visible at once, and they are the ones that end up as uncovered hours.
- Read the monthly summary: how many days were marked, how many per shift and whether rest days are spread evenly across the people.
Tips and common mistakes
Almost every problem with a schedule comes from building it in a hurry and not reading it before publishing. The mistakes that come up most often are these:
- Leaving days uncovered without noticing. Running down the grid by columns, not by rows, is what makes a blank date visible. A blank column is a day when nobody opened.
- Handing out rest days from memory. When days off are marked last, someone always ends up with less rest than the others. Marking them first spreads the load with a reason behind it.
- Changing a shift without leaving a trace. If someone cannot come in and another person covers, writing the change on the same grid and confirming it in writing stops the hours from failing to match the plan at month end.
- Scheduling the same person to close and to open. A night shift followed by a morning shift leaves few hours of rest and multiplies operating mistakes.
- Relying on colour instead of the word. A schedule read through colours cannot be counted, cannot be printed in black and white and does not mean the same thing to two people.
- Confusing the schedule with attendance. The schedule says what was planned; attendance says what happened. When the two sheets do not match, the difference is what has to be explained, and that takes having both.
When to move to software
The template handles planning well while the team fits on one sheet and there are few shifts. As the operation grows, with several sites, staff rotating between locations and shift changes almost every day, the Excel schedule starts to fall behind: it is built on Monday and by Friday it no longer matches what happened, and every change means correcting the grid, the timesheet and the attendance record by hand. That is where a system changes the job. Kardex Tauro is inventory and sales software built for small businesses that records the operation as it happens, so hours stay linked to the person and the actual day without copying the schedule again.
That does not make the format worthless. While a business is at the stage where the owner knows each person and knows who can cover a holiday, Excel is the fastest and cheapest tool: it does not depend on the internet, it can be printed, it gets taped to the wall of the area and anyone can see how it is filled in. The signal to move on is simple: when the schedule changes three times in the same week, when staff are covering two sites at once, or when reconciling payroll hours against the plan already takes a whole afternoon, manual control has become the problem.
Download the template, schedule next month with the team you have today and read the grid by columns before you publish it. A schedule everyone can read, in words, with no colours and no codes, prevents most of the staffing problems that are otherwise argued about with nothing to point to.
⬇ Download the template (Excel .xlsx)
