Employee Schedule Template (Free Excel + Sheets)

Spreadsheets handle scheduling just fine until they don't.

One Reddit user put it perfectly: "Google Sheets works fine until you need it to be fair. Fair requires tracking history, and that's where it gets messy." Another manager schedules 22 people across two locations on a spreadsheet and swears by it. Both are right. It depends on where you are.

If you're scheduling under 15 people and your biggest problem is "everyone needs to see it," a good template solves that. If you're spending 3+ hours a week fighting with formulas, copy-pasting shifts, and fielding "when do I work?" texts, you've outgrown templates. But most people aren't there yet.

Here's what a solid schedule template looks like, how to set one up, and the signs that tell you it's time to move on.

The 3 template types you actually need

Most template sites throw 37 options at you. You need three.

1. Weekly schedule (best for most teams)

The workhorse. One tab per week, employee names down the left, days across the top. Each cell gets a shift time.

Works best for: Restaurants, retail, cafes, bars. Any team with a predictable weekly pattern.

Structure:

• Row 1: Days of the week (Mon-Sun) with dates
• Column A: Employee names, grouped by role
• Cells: Shift times (9A-5P) or "OFF"
• Bottom row: Total hours per employee
• Color coding: Morning shifts (light blue), evening shifts (light orange), day off (gray)

This is the template our free schedule builder generates. You pick your team size, roles, and shift patterns, and it exports a formatted Excel or Google Sheets file ready to fill in.

2. Biweekly schedule (for rotating shifts)

Same structure as weekly, but covers 14 days on one view. Essential if you run rotating schedules where no two weeks look the same.

Works best for: Healthcare, warehouses, security, 24/7 operations.

Key additions:

• Shift rotation pattern row (Week A / Week B)
• Overtime tracking column (highlight anything over 40 hours)
• Night shift indicator (dark background cells)

3. Monthly overview (for managers who plan ahead)

Less detail per day, more visibility across the month. Shows who's working when at a glance without shift-level detail.

Works best for: Planning vacation coverage, spotting understaffed weeks, tracking employee availability patterns.

Structure:

• Calendar grid (31 columns)
• Employee names in rows
• Cells marked: W (working), O (off), V (vacation), S (sick)
• Row totals show days worked per employee

How to build a schedule template in Excel (step by step)

You don't need a pre-made template. Building your own takes 20 minutes and you'll understand every formula.

Step 1: Set up the grid

Open a new workbook. In cell A1, type "Employee." In B1 through H1, type Monday through Sunday. In I1, type "Total Hours."

Add your employee names in column A, starting at row 3. Leave row 2 for dates (you'll update this each week).

Step 2: Add shift times

In each cell, type the shift in a consistent format: "9A-5P" or "7:00-15:00." Pick one format and stick with it. Mixing "9AM-5PM" with "09:00-17:00" makes formulas harder later.

For days off, type "OFF" or leave blank. Blank is cleaner but OFF is easier to spot.

Step 3: Calculate total hours

In column I, add a formula that counts hours. The simplest approach: if you're using decimal shift lengths (8, 6, 4), use =SUM(B3:H3). If you're using time formats, you'll need a helper row that converts shift times to hours.

A simpler method: create a lookup. Put standard shift lengths in a reference table (Morning = 8h, Evening = 6h, Split = 10h) and use VLOOKUP to total them automatically.

Step 4: Add conditional formatting

This is what separates a usable template from a wall of text.

• Overtime flag: Highlight column I cells red when total hours exceed 40
• Empty shifts: Highlight blank cells in yellow (unfilled shifts need attention)
• Role colors: Use font color or cell shading to distinguish servers from cooks from hosts

Step 5: Protect and share

If using Google Sheets: Share with "view only" for employees, "edit" for managers. If using Excel: protect the sheet but unlock the shift cells so only those can be edited.

Save this as your master template. Each week, duplicate the tab, update the dates, and adjust shifts. Never edit the master directly.

5 mistakes that make schedule templates fail

Templates work until one of these kills them.

1. No version control

"Wait, which version is the latest?" If your schedule lives in an email attachment or a shared drive with files named "Schedule_FINAL_v3_REALLY_FINAL.xlsx," you have a problem. Use Google Sheets (one URL, always current) or a shared OneDrive/SharePoint file.

2. No availability tracking

The schedule says Maria works Tuesday. Maria told you three weeks ago she can't do Tuesdays anymore. But that conversation happened over text and you forgot.

Templates don't track availability. You need a separate system for that, even if it's just a shared note. Better yet, let employees update their own availability somewhere you'll actually check before building the schedule.

3. No overtime formulas

"I didn't realize Jordan hit 44 hours until payroll." If your template doesn't automatically flag when someone crosses 40 hours (or whatever your overtime threshold is), you're asking for surprises. One formula in the total column fixes this. Add it.

4. Texting changes instead of updating the sheet

You swap Maria and Alex on Wednesday. You text them both. You forget to update the sheet. Next week, you build the new schedule from the old (wrong) sheet. Now Alex is double-booked and Maria's confused.

The rule: if the schedule changes, the sheet changes first. Then you notify. Not the other way around.

5. One person holds the keys

If the only person who understands the spreadsheet formulas is the GM, and the GM goes on vacation, the schedule stops. Document your template. Label the tabs. Add notes to the formulas. Someone else should be able to use it without a training session.

When templates stop working (the honest answer)

Templates break at predictable points.

Under 10 employees: Templates work great. Simple, fast, no learning curve.

10-20 employees: Templates still work but start to creak. You'll spend 1-2 hours per week on the schedule. Shift swaps become a texting headache. Overtime calculations get complicated with multiple roles.

20-50 employees: This is where most people switch. The time spent maintaining the spreadsheet exceeds the cost of software. Shift swap requests pile up. Employees text "when do I work?" because they can't find the sheet. Availability changes get lost.

50+ employees: If you're still using a spreadsheet at this size, you're either a wizard or in pain. At 50 employees with variable shifts, the schedule has 350+ cells per week. One mistake cascades through the whole thing.

The honest answer: spreadsheets cost you time, not money. The question is whether your time is worth more than €2-5 per employee per month. For most managers, the switch happens around 15-20 employees or 2+ hours per week spent scheduling.

Template vs. scheduling software: quick comparison

If you only need scheduling and nothing else, the template wins on cost. The moment you need time tracking, shift swaps, or automatic notifications, software pays for itself.

Download the free templates

We built a schedule template generator that creates a customized Excel or Google Sheets file based on your team size, roles, and shift patterns. It's free, no signup required.

What you get:

• Weekly schedule with your actual employee names and roles
• Automatic hour calculations
• Color-coded shifts by role
• Overtime highlighting
• Print-friendly layout

If you'd rather build from scratch, the step-by-step guide above gives you everything you need.

And if you've already outgrown templates, Turnozo does scheduling, time tracking, and timesheets for €2.47/employee/month. 30-day free trial, no credit card.