Free template · Excel, PDF and CSV
An employee schedule template that is honestly just a good grid
An employee schedule template is a weekly grid of staff against days, with each person's start and finish time written into the cell for the day they work. It is the simplest useful scheduling artefact there is: one row per employee, one column per day, and a total that counts itself.
Free · No account · Sent to your inbox
Where can I download a free employee schedule template?
Here: the buttons below. Enter your email address and we send the files to your inbox. No account, no card.
The spreadsheet opens in Excel, Google Sheets, LibreOffice or Numbers, and its totals are live formulas that recalculate as you type. The PDF is laid out landscape, ready to print for a wall. Also available as a CSV or a printable web page.
What is in it
- Hours per person for the week, worked out from times typed as 09:00-17:00; a 22:00-06:00 night counts as 8.
- An Over flag against a weekly hours limit you set (40 to start).
- A Check flag on any cell the sheet cannot read, so a typo shows up instead of counting as zero.
- People and hours scheduled per day along the bottom, so a thin Wednesday is visible without counting.
- Twenty staff rows against a seven-day week from the date you pick, three worked examples to overwrite, and a landscape PDF that prints the calculated figures.
At a glance
- An employee schedule template, also called a staff schedule template or staff scheduling template, is a weekly grid: one row per employee, one column per day, a start and finish time in each cell they work.
- This one is deliberately general, times rather than clinical shift codes, because the person who needs a plain weekly rota is as often running a front desk as a ward.
- The spreadsheet carries live formulas: hours per person worked out from the times you type, overnight shifts included, an Over flag against your weekly limit, and people and hours per day, all recalculating as you type.
- It comes as Excel, PDF or CSV, all built from the same sheet, with the PDF laid out landscape for a wall, all free and sent to your inbox.
- A spreadsheet stops working at roughly the point where you cannot hold the constraints in your head: more than one site, staff with real availability, or anything that has to be checked before it is published.
What is an employee schedule template?
An employee schedule template is a reusable weekly grid of people against days, filled in with the hours each person is expected to work, so that next week's rota starts as an edit rather than a blank page.
That is genuinely the whole idea, and its plainness is the reason it has survived every attempt to replace it. A grid of names and days is legible to everyone who has ever had a job, needs no training, prints, photocopies, and works identically whether you employ six people or sixty. Any honest account of scheduling software has to start by admitting that the spreadsheet is a strong incumbent, not because people are stubborn, but because for a large number of teams it is genuinely sufficient.
This template is deliberately general. It holds start and finish times rather than clinical shift codes, and it has no opinion about what a role means. If you want the version that understands what a nurse is, that is a different sheet and it is linked at the foot of this page.
How do I make an employee schedule?
Write down the coverage each day needs first, place the people with the least flexibility next, and fill in the flexible ones last.
The mistake almost everyone makes is starting with Monday and working forward, which feels like progress and is actually how you spend Friday afternoon discovering the only two people who can cover it are already on five shifts each. Coverage first: how many bodies, in which roles, at which hours, each day. That is the target, and it is worth writing above the grid rather than carrying in your head, because the moment it is written down it can be argued with.
Then the constrained people. Whoever is unavailable Thursday, whoever only works mornings, whoever holds the one competency the Saturday needs. Every flexible person you place early removes an option from a problem you have not solved yet, and flexible people are the easiest to place at the end, which is exactly why they should be.
Then read it in the other direction. A rota is built column by column, day by day, and it fails row by row, person by person: six days in seven, a close followed by an open, someone quietly at forty-eight hours. None of that is visible while you are filling in Wednesday, and all of it is obvious the moment you read one person's week straight across.
When does a schedule spreadsheet stop working?
At the point where the constraints stop fitting in one person's head, which arrives sooner than anyone expects, and is usually noticed after it has already happened.
The spreadsheet does not fail loudly. It keeps producing a perfectly tidy grid the entire time it is producing wrong answers, which is precisely the problem: there is no error, only an outcome, and the outcome arrives on a Tuesday as a person who is not there. The warning signs are worth naming because they are recognisable rather than abstract.
You are the only one who knows what it means
If the rota needs you to explain it (that Priya never does Thursdays, that this cell is provisional, that the highlighted ones are unconfirmed), the knowledge is not in the file. It is in you, and it goes on holiday when you do.
It exists in more than one place
The version in your inbox, the version on the wall, the version somebody photographed on their phone last Wednesday. The moment there are two, one of them is wrong, and the person who arrives for a shift that was moved is not the person who made the mistake.
The same person appears on two sites
Cross-site double-booking is the failure a grid structurally cannot see, because each site's grid is a separate file and neither of them has ever heard of the other one.
Something must be checked before it is published
This is the real line. A spreadsheet records decisions; it has no view on whether a decision was permitted. The moment your rota is subject to a rule that has a consequence (a certification that must be current, a rest gap that must exist, a ratio you are held to), you are relying on a file that is structurally incapable of enforcing it, and the fact that it has not caught you out yet is not evidence that it will not.
Questions people actually ask
- Is it really free?
- Yes. Enter your email address and we send the file to your inbox. There is no account to make and no card to give.
- Can I open it in Excel or Google Sheets?
- Both, and LibreOffice and Numbers. Take the .xlsx for Excel or the CSV for anything else; both carry real formulas, so the hours per person and per day recalculate as you type.
- How do I add more employees?
- Insert a row inside the staff block, above the last staff row, and a matching row inside the calculated hours block below the grid, then copy the formulas down from the row above. The totals count a range, and a row added underneath sits outside that range and gets silently ignored, which is the single most common way a working spreadsheet quietly starts lying.
- Does it calculate hours or pay?
- Hours, yes; pay, no. Each cell's hours are worked out from the times as written, wrapping past midnight, then totalled per person for the week and flagged Over past your limit; a cell it cannot read shows Check. It takes no unpaid break off, and its arithmetic is wall-clock: a shift crossing a clocks change is an hour longer or shorter than its times say, and the sheet's notes tell you when your week has one. It calculates nothing to do with money.
- Is there a version for clinical staff?
- Yes. The nurse schedule template has shift codes, a license expiry column and a coverage block that checks staffing against census and ratio. It is linked at the foot of this page.
Related
When the grid needs an opinion
MedAligna checks eligibility before an assignment is saved rather than recording it afterwards. Fourteen days free, no card, no sales call.