Need a simple shift schedule template for Excel? These free templates can be used to plan monthly, weekly, or daily staff shifts without building a schedule from scratch.
They are useful for stores, small offices, restaurants, salons, part-time teams, and any workplace that needs a clear staff schedule. Some templates are simple shift charts, while others can calculate working hours or the number of staff members by time slot.
In Japanese workplaces, shift schedules are often printed and checked by managers, staff, and sometimes head office. A clean Excel format helps everyone see who is working, when they start, and where there may be a shortage. One small thing I noticed when using these kinds of sheets: if the start date is wrong, the whole month feels off. So it is worth checking the date field first before sharing the file.
Free Shift Schedule Templates for Excel
You can download free Excel shift schedule templates below. There are monthly, weekly, and daily formats, so choose the one that fits your workplace.
Click the thumbnail image to see a larger preview. Use the “Download” button below each image to open the download page.
Monthly Shift Schedule Templates
Enter a date in the “Period Start Date” field, and the dates and days of the week for the month will be set automatically. To use it, enter the start time in the “In” column and the end time in the “Out” column.
This template does not automatically calculate working hours, so it is better for simple shift planning rather than payroll checking.
If the table feels too small after entering staff names, adjust the row height or reduce the number of staff members. This is a common small issue when trying to print everything on one sheet.
This is useful when a manager wants to check staffing balance quickly, especially before weekends, holidays, or busy periods.
There is also a remarks row below the dates, which is handy for adding notes such as public holidays, store events, or days when extra staff may be needed.
Weekly Shift Schedule Template
A weekly format is easier to check than a monthly one when shifts change often. For example, it works well for part-time staff, temporary workers, and small teams that adjust schedules every week.
Daily Shift Schedule Templates
Enter the start time and end time, and the template will automatically calculate working hours, the time chart, and the number of staff members for each hour.
The chart color is controlled by conditional formatting. If you want to change the color, select the relevant time cells and edit the conditional formatting settings in Excel.
When you enter the start and end time, the template calculates working hours and the number of staff members by time slot. The chart itself is not created automatically, so you need to fill in the shift blocks manually.
How to Make a Shift Schedule in Excel
You can also create a shift schedule by yourself in Excel. There are many ways to do it, but the basic idea is simple: make a table for staff names, start times, end times, and time slots.
Below is an example of a daily shift chart that calculates working hours and the number of staff members assigned to each hour.
1. Adjust the Cell Size
First, adjust the width and height of the cells.
The default Excel cell width is usually too wide for a shift chart. If you want to show many time slots across the page, make the cells smaller. In this example, the cells are set to about 30 pixels wide and 30 pixels high.
2. Create the Staff and Time Table
Next, create the main table for the shift schedule.
In the sample, the table includes Type, Name, Task, Start Time, End Time, and time slots from 7:00 to 23:00. You can change these items depending on your workplace. For example, a restaurant may need Lunch, Dinner, and Closing tasks, while an office may only need morning and afternoon shifts.
3. Add Total Rows and Columns
Add a column on the right side to calculate each person’s working hours. Then add a row at the bottom to count how many people are working at each time.
This makes the schedule easier to check. It is also useful when you need to avoid being short-staffed at busy times.
4. Calculate Working Hours
Working hours can be calculated from the start time and end time.
For example, if the start time is in cell I3 and the end time is in cell K3, the basic formula is:
=K3-I3
However, if the end time is blank, Excel may show an unnecessary value. To keep the sheet clean, use an IF function like this:
=IF(K3="","",K3-I3)
Copy the formula down the column to calculate working hours for all staff members.
5. Count the Number of Staff by Time Slot
To count how many staff members are working at each time, use the COUNTIFS function.
For example, the following formula counts the number of staff members working at 7:00:
=COUNTIFS(I4:I16,"<=7",K4:K16,">7")
This formula checks whether each staff member’s start time is before or equal to 7:00 and whether the end time is after 7:00.
After creating the first formula, copy it to the right to count the number of staff members for each time slot.
6. Clean Up the Design
Finally, adjust the design so the schedule is easy to read. Add a title, date field, borders, colors, and any notes you need.
For Japanese-style business documents, a clean layout is usually safer than a colorful one. Managers and staff often print the schedule, so avoid using too many colors or tiny text. A simple table is easier to check on paper, especially in the morning when everyone is busy.
Common Mistakes When Using a Shift Schedule
A common mistake is changing the date or time format without checking the formulas. For example, if some cells are entered as text instead of time, working hours may not calculate correctly.
Another small issue is forgetting to update the start date before copying the template for the next month. It sounds basic, but it happens. Before printing or sending the file, check the period, dates, days of the week, and total staff numbers.
Summary
Excel shift schedule templates are useful when you want a simple way to manage staff shifts without using a full scheduling system.
The templates on this page include monthly, weekly, and daily formats. Some are best for simple planning, while others can calculate working hours or count the number of staff members by time slot.
If you are managing shifts by hand, switching to Excel can make corrections much easier. Once the basic format is ready, you can reuse it every month and adjust it little by little to fit your workplace.
