Free Employee Schedule Template (Excel)

Short answer: An employee schedule template in Excel is a weekly grid with one row per employee, a start and end time for each day, the employee’s role, and a total-hours column that adds up the week. Copy the template below or click Download CSV, open the file in Excel, and replace the sample names and times with your own.

A spreadsheet is the fastest way to move a schedule off a whiteboard or a paper calendar. This page gives you a ready-made weekly layout, a formula that totals hours (including overnight shifts), and practical tips so the schedule you post is one your team can actually follow.

Free weekly employee schedule template

What the template includes

• Employee and role. One row per person. The role column (cashier, shift lead, cook, driver) lets you check at a glance that every shift has the right skills on the floor.
• Start and end time for each day. In the CSV, each day has its own start and end column so Excel can do the math. Leave both cells blank for a day off.
• Unpaid break hours. Enter the total unpaid meal time for the week (for example, four 30-minute breaks = 2). The formula subtracts it from scheduled time.
• Total paid hours. A formula adds every shift for the week, handles shifts that cross midnight, and subtracts unpaid breaks.
• Header fields. Week of, location, manager and the date the schedule was posted, so printed copies are never confused with older versions.

How to use the template in Excel

1. Download and save. Click Download CSV, open the file in Excel, then use File > Save As and choose Excel Workbook (.xlsx). A CSV cannot keep formatting, so saving as a workbook keeps your column widths and colors.
2. Format the time columns. Select the start and end columns, choose Format Cells > Time and pick a format such as 1:30 PM. Type times with AM or PM (for example 7:00 AM) so Excel stores them as real times rather than text.
3. Replace the sample rows. Overwrite the three sample employees and fill the blank rows. Copy the last row down if you need more people; the formula adjusts to each row automatically.
4. Check the totals. The total column uses MOD(end-start,1)*24 for each day. MOD makes an overnight shift such as 10:00 PM to 6:00 AM count as 8 hours instead of a negative number.
5. Print or share. Set Page Layout > Orientation > Landscape and Fit All Columns on One Page. Add the week-of date to the header before you print.
6. Copy the sheet for next week. Right-click the sheet tab, choose Move or Copy, tick Create a copy and rename it with the new week’s date. Keeping each week on its own tab gives you a simple history.

Prefer Google Sheets? Open Sheets, choose File > Import > Upload, select the CSV and keep “Convert text to numbers, dates, and formulas” turned on so the hours formula works.

Worked example: totaling a week

Jordan, a shift lead, works Tuesday to Thursday from 7:00 AM to 3:30 PM and Saturday and Sunday from 8:00 AM to 4:30 PM. Each shift is 8.5 hours, so five shifts are 42.5 scheduled hours. Jordan takes a 30-minute unpaid meal break each day, which is 2.5 hours for the week. The template shows 42.5 − 2.5 = 40.0 paid hours.

That number matters. Under the federal Fair Labor Standards Act, covered non-exempt employees must be paid at least time and one-half their regular rate for hours worked over 40 in a workweek (U.S. Department of Labor, Overtime Pay). If Jordan picks up one more shift, the extra hours are overtime. Use the overtime pay calculator to see what that would cost before you approve it, and read our FLSA overtime rules guide for the details. Some states add daily overtime rules, so check your state too.

Tips for a schedule your team can follow

Start with coverage, then add names

Before you type a single name, list how many people and which roles you need for each part of each day. Fill the busiest periods first, then use part-time shifts to cover the gaps. The role column makes it easy to spot a morning with no one who can open or a closing shift with no key holder.

Collect availability before you build

Ask employees for their weekly availability and time-off requests by a fixed cutoff, then build around it. Our guide to employee availability scheduling explains how to collect it without endless back-and-forth.

Post the schedule early and keep the date on it

Publishing the schedule well ahead of the week gives people time to plan childcare, school and second jobs. In some cities and states, advance notice is a legal requirement for certain employers; see our predictive scheduling laws guide.

Set a clear rule for shift swaps

Swaps will happen. Decide who may swap, how much notice is needed and who approves, and write it at the bottom of the sheet. A manager should confirm that the replacement has the right role and will not tip into overtime. Shift swaps with manager approval take this out of text threads entirely.

Compare scheduled hours with actual hours

A schedule shows planned hours; payroll needs the hours people actually worked. Track real time in and time out with our free timesheet template, then compare it with the schedule each week to catch late starts, early leaves and unplanned overtime.

Keep old schedules

Do not delete last month’s tabs. The Department of Labor says records on which wage computations are based, including work and time schedules, should be retained for two years (DOL Fact Sheet #21).

When a spreadsheet schedule stops working

An Excel schedule works well for a small team in one location. It gets harder when:

• You run several locations or departments and need to see everyone at once.
• Employees learn about changes late because the latest version lives on one manager’s laptop.
• Swaps and call-outs are handled by text, so the posted schedule is no longer accurate.
• Nobody notices an employee is heading into overtime until payroll is already done.

How EZTime helps with employee scheduling

If you outgrow the spreadsheet, EZTime employee scheduling software keeps the same weekly grid but makes it live. AI shift scheduling builds a draft from your coverage needs and employee availability, employees see their shifts on the mobile app, and swap requests go to a manager for approval. Overtime and break alerts flag problems before the week starts, and because scheduling sits next to the time clock (GPS app, NFC tags, tablet kiosk or biometric clocks), you can compare scheduled and actual hours and export payroll-ready reports in Excel or PDF for any payroll software.

See EZTime pricing: plans start at $2 per employee per month with a 14-day trial.

This article is general information, not legal advice. Laws change; check your state labor department or an employment attorney before making decisions.

Frequently asked questions

Is this employee schedule template really free?

Yes. You can copy the table on this page or download the CSV and use it in Excel or Google Sheets with no sign-up.

How do I calculate hours for an overnight shift in Excel?

Use =MOD(end-start,1)*24. Without MOD, a shift from 10:00 PM to 6:00 AM returns a negative number. The template already uses this formula for every day.

Why does my total show 0 or an error?

Usually the times were stored as text. Retype them with AM or PM (for example 9:00 AM) and make sure both start and end cells are filled for that day.

Can I use the template for more than one week?

Yes. Copy the sheet for each new week and rename the tab with the week-of date. Keep the old tabs as a record of past schedules.

Does the template track actual hours worked?

No. It shows scheduled hours. Use a timesheet or a time clock to record actual time in and time out, then compare the two before payroll.

How many employees can I put on one sheet?

There is no hard limit; copy the last row down as needed. For larger teams or several locations, scheduling software is usually easier to keep up to date.