Excel Sheet Employee Schedule Template: How to Make One

How-to basics · Updated November 22, 2026

The fastest way to get an employee schedule template in Excel is to open Excel, go to File > New, and search for “schedule” in the template gallery. Microsoft offers several free, pre-built weekly and monthly schedule templates that you can download and edit immediately. If you prefer to build your own from scratch, you can create a simple grid with employee names in rows and time slots in columns, then use Excel’s formatting and formulas to automate shift totals and conflict checks.

Why Use Excel for Employee Scheduling

Excel is a middle ground between paper schedules and dedicated scheduling software. It is widely available, does not require a subscription (if you already have Office), and gives you full control over the layout. Unlike paper, Excel lets you copy recurring weekly patterns, color-code shifts, and calculate total hours automatically. Unlike specialized apps, it has no learning curve for basic use, and you can share the file via email or a cloud drive.

For a small business with 5–20 employees and predictable shifts, Excel is often sufficient. It also works well for volunteer rosters, family chore charts, or academic teaching schedules. However, if you have shift-swapping, multiple locations, or complex labor laws, a dedicated tool may save time.

How to Build a Basic Employee Schedule Template from Scratch

Creating your own template takes about 10 minutes and gives you exactly what you need. Here’s a step-by-step method for Microsoft 365 on Windows (steps are similar on Mac, but the ribbon names are slightly different).

  1. Set up the grid: In a new worksheet, put “Employee” in cell A1. Put the days of the week in B1:H1 (e.g., Mon, Tue, Wed). If you need time slots, put them in row 2.
  2. Enter employee names in A2:A20 (adjust as needed).
  3. Type shift codes or times in the cells. For example, “9-5” or “M” for morning, “E” for evening.
  4. Add a total hours column: In column I, use a formula to sum hours if you enter numeric hours per day. For example, if you enter hours as numbers (e.g., 8 in each cell), put =SUM(B2:H2) in I2 and drag down.
  5. Format with borders and colors: Select the range, go to Home > Borders, and choose All Borders. Use Fill Color to highlight weekends or specific shifts.
  6. Add data validation (optional): To prevent typos, select the shift cells, go to Data > Data Validation, choose List, and enter your shift codes separated by commas (e.g., M,E,N,O).

On Mac, the Data Validation menu is under Data > Data Validation as well, but the dialog looks slightly different. On Excel for the web, Data Validation is under Data > Data Validation, but it only works with lists typed directly, not ranges from another sheet.

Using Formulas to Automate Hours and Conflict Checks

Manual entry is fine for small teams, but formulas save time and reduce errors. Here are two useful formulas.

1. Sum weekly hours per employee. Assume employee names are in A2:A20, and daily hours (as numbers) are in B2:H20. In I2, enter =SUM(B2:H2) and copy down. This gives total hours for that row. For example, if B2:H2 contains 8, 8, 8, 8, 8, 0, 0, the result is 40.

2. Count shifts per day (to see coverage). In row 1, you have days. To count how many employees are scheduled on Monday (column B), use =COUNTA(B2:B20) if the cells contain any text or numbers. This returns the number of non-empty cells. For example, if 6 employees have a shift on Monday, the formula returns 6.

3. Flag over-scheduling (optional). If you want to know if any employee exceeds 40 hours, use conditional formatting. Select I2:I20, go to Home > Conditional Formatting > Highlight Cells Rules > Greater Than, and enter 40. Cells with values above 40 will be highlighted.

Note: These formulas work in Excel 2016 and later, as well as Excel for the web. No special functions are required.

How to Choose a Pre-Made Template vs. Building Your Own

Microsoft’s template gallery offers several schedule templates. To access them, click File > New, type “schedule” in the search box, and browse. Options include “Weekly schedule with times”, “Monthly employee schedule”, and “Shift schedule”. These are good if you want a polished look quickly. However, they often contain extra columns or formatting you may not need, and they are not always optimized for a specific industry.

Building your own is better if you have unique shift patterns, need specific formulas, or want to avoid clutter. It also teaches you the structure so you can modify it later. A hybrid approach: download a template, then strip it down and add your own formulas.

Common Problems and How to Solve Them

One frequent issue is that employees accidentally overwrite formulas when they edit the schedule. To protect formulas, lock the cells that contain formulas and protect the sheet. Select the formula cells (e.g., I2:I20), right-click > Format Cells > Protection, and uncheck “Locked”. Then go to Review > Protect Sheet, and set a password. Employees can only edit unlocked cells.

Another problem is that the schedule becomes unreadable when printed. Use Page Layout > Print Area > Set Print Area to select just the schedule range. Also, go to Page Layout > Orientation and choose Landscape if your grid is wide. On Mac, these options are under Page Layout as well.

If you need to handle shift swaps, a simple approach is to add a “Notes” column and ask employees to write changes there, but that can get messy. A better method is to use a separate “Swap Log” sheet where employees list their requested changes, and you update the main schedule accordingly.

Comparing Excel with Dedicated Scheduling Software

Excel is flexible and cheap, but it lacks features like automated shift rotation, mobile apps, and real-time notifications. Dedicated tools like When I Work, Deputy, or Homebase offer those features, but they cost money per user per month. For a small team, Excel is often enough. For a growing business, the time saved by software may justify the cost.

One key difference: Excel is static unless you manually update it. Software can integrate with payroll and time clocks, reducing data entry. Excel also has no built-in way for employees to request time off or swap shifts without you doing it manually. If those needs are frequent, consider a hybrid: use Excel for planning and a free online tool for employee self-service.

Frequently Asked Questions

Q: How do I make an employee schedule template in Google Sheets?
Google Sheets works similarly to Excel. Create a grid, use the same SUM formula, and apply formatting. To access templates, go to sheets.new and click Template Gallery, then choose “Schedule”. Data validation is under Data > Data validation. The main difference is that Google Sheets saves to the cloud automatically, making sharing easier.

Q: Can I use Excel to track employee availability?
Yes. Create a separate sheet with employee names and days/times they are available. Then, when making the schedule, you can manually cross-reference or use conditional formatting to highlight conflicts. For example, if an employee is unavailable on Tuesday, you could highlight Tuesday cells in red on their row.

Q: How do I calculate overtime in Excel?
If you have daily hours in B2:H2, you can calculate weekly overtime with a formula like =IF(SUM(B2:H2)>40, SUM(B2:H2)-40, 0). This assumes a 40-hour threshold. Place it in a new column. Remember that overtime rules vary by location, so check your local labor laws.

Q: Is there a way to share the Excel schedule with employees without emailing a file?
Yes. Save the file to OneDrive or SharePoint and share a link. In Excel, click File > Share > Share with People. You can set permissions to “Can view” or “Can edit”. On Excel for the web, this is built in. Alternatively, export the sheet as a PDF and send it via chat.

Q: My template has too many columns. How do I remove them?
Select the columns you don’t need, right-click, and choose Delete. Be careful not to delete cells that contain formulas. If you delete a column that is referenced in a formula, the formula may break. Check the formulas before deleting.

Q: Can I create a rotating shift schedule automatically?
Excel doesn’t have a built-in rotation feature, but you can use a formula to rotate shift types. For example, if you have a list of shift codes in a column, you can use the OFFSET function to shift the list each week. However, this is advanced. A simpler method is to copy and paste the previous week’s schedule and manually adjust.

Final Tips for a Clean, Error-Free Schedule

  • Always keep a backup copy of your template before making major changes.
  • Use consistent shift codes (e.g., M, E, N) to make the schedule easy to read.
  • Add a legend at the bottom of the sheet explaining the codes.
  • Review the schedule for double-bookings before publishing. Use conditional formatting to highlight duplicates if needed.
  • Test your formulas with sample data to ensure they calculate correctly.

With these methods, you can create a functional employee schedule template in Excel that saves time and reduces scheduling conflicts.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.