Skip to content
FitRank

Employee schedule template (Excel), free download

A weekly employee schedule template and a monthly one in a single .xlsx, with shift codes you set, hours per person and coverage per shift worked out by formula. No macros, no sign-up. Open it in Excel, Google Sheets or LibreOffice.

Download the template (.xlsx)Four sheets, about 14 KB, no macros.

What is in the work schedule template

Four sheets. The two grids are what you print or share; the other two are the settings and the notes.

  1. Sheet 1

    Weekly

    Monday to Sunday, one row per employee, one shift code per day. Hours, shifts worked and days off per person by formula, a total row, and a coverage block that counts people on each shift each day. Comes with an example week you overwrite.

  2. Sheet 2

    Monthly

    Thirty-one day columns driven by one cell: type the month's first day and the day names follow, with the 29th to 31st going blank in shorter months. The same hours, totals and coverage formulas as the weekly sheet.

  3. Sheet 3

    Shifts

    Your shift codes, names and start and end times. Hours per shift are worked out, including night shifts that end after midnight, and the grids' drop-downs read from this list.

  4. Sheet 4

    Instructions

    How to use it, what the formulas check, and what a spreadsheet will not do for you.

How to use the weekly employee schedule template

What a template can and cannot do

A spreadsheet is a good record of a schedule and a fair checker of hours. It does not choose the schedule. It will not tell you who should take the open Saturday shift, whether a person has the skills for a task, or why one person is a better fit than another, and it keeps no history of the decisions you made. We wrote up how far automated employee scheduling in Excel goes and where it breaks.

To fill a week from availability and limits, the free automatic schedule generator runs in your browser and exports a CSV you can paste into this template. For the question the grid cannot answer, which person fits an open task and why, FitRank ranks your people with rules in code, a probability for every typed answer, and a manager who makes every final call. See how FitRank decides.

Related reading

Questions about the template

Is the employee schedule template free to download?

Yes. It is a plain .xlsx file with no macros, no sign-up and no watermark. Use it, change it and share it inside your company as you like.

Does it work in Google Sheets and LibreOffice?

Yes. The formulas are COUNTIF, COUNTA, COUNTBLANK, SUMPRODUCT, TEXT, DATEVALUE and MONTH, which all three support. Upload the file to Google Drive and open it with Sheets, or open it directly in LibreOffice Calc.

How do I add more employees?

Insert rows above the Total row on the Weekly or Monthly sheet and copy an existing row's formulas down. The totals and the coverage block keep covering every employee row above the Total row.

Can I change the shift codes?

Yes. Edit the Shifts sheet: codes, names and times. The drop-down lists and the hours formulas on both grids read from it. Keep OFF and L (leave) if you want the days-off count to stay right.

Will the template choose who works which shift?

No. It records the schedule and checks hours and coverage. To fill a week automatically from availability and limits, use the free schedule generator on this site. To rank who fits an open task and see why, that is FitRank.

When the question is who, not when

FitRank ranks your people for open tasks with a probability and a reason for each. We are taking on a small number of pilot companies.