Free template · CSV and printable
A nurse schedule template with the ratio row the others leave out
A nurse schedule template is a reusable grid of nursing staff against days, with a shift code in each cell. This one adds the block that makes it a nursing schedule rather than a staff list: enter the census and the ratio your unit is held to, and the sheet counts the nurses you have rostered against the nurses that day needs.
Free · No email address · No account
Where can I download a free nurse schedule template?
Here: the two buttons below. No email address, no account, and no thank-you page with a sales sequence behind it.
Opens in Excel, Google Sheets, LibreOffice or Numbers. The printable version is laid out landscape for a wall.
What is in it
- Sixteen staff rows against a Monday-to-Sunday week, with three worked examples to overwrite.
- A licence expiry column, because it belongs beside the name rather than in a folder nobody opens.
- A coverage block: census, ratio, nurses required, over/under, all as formulas, per day.
- A separate night-shift count, because a ratio is per shift and not per day.
At a glance
- A nurse schedule template is a weekly grid, one row per nurse, one column per day, with a shift code in each cell: D for day, N for night, OC for on call, PTO for approved time off.
- This one carries a coverage block: enter the day's census and the patients-per-nurse ratio your unit works to, and it calculates nurses required and whether you are over or under.
- The download is a CSV with live formulas. The per-nurse shift count, the scheduled counts and the over/under row recalculate as you type into the grid.
- There is a printable version for the break-room wall, laid out landscape with the calculating cells left blank for a pen.
- A spreadsheet records what you decided. It cannot know that the nurse you just rostered for Friday holds a licence that expires on Thursday.
What is a nurse schedule template?
A nurse schedule template is a reusable grid of nursing staff against days, filled in with a shift code, that turns next week's roster from a blank page into an editing job.
The grid is the easy part and every template on the web has one. What separates a nursing rota from a shift grid with nurses in it is that a nurse is not interchangeable with another nurse: she holds a licence with an expiry date, a set of certifications, a competency for the unit she is standing on, and a contract that says how many hours she agreed to. A template cannot enforce any of that. It can, at least, put the facts where somebody will see them, which is why the licence expiry column sits next to the name here rather than in a separate compliance folder.
The other thing a nursing rota has that a shift grid does not is a denominator. Four nurses is a good Tuesday on a unit of twenty and a bad one on a unit of forty, and the number that decides which is the census, a figure that lives nowhere on a normal template. So it lives on this one.
What should a nurse schedule include?
At a minimum: every nurse's name and role, a shift code for each day, the total each person is carrying, the census, and the coverage those shifts actually produce against it.
Most of that is uncontroversial. The last two are the ones that get left off, and leaving them off is how a rota comes to be correct on paper and short on the floor, because a grid of names looks full at a glance regardless of how many patients are in the beds. A coverage row is not a nicety. It is the only part of the sheet that can disagree with you.
The columns that earn their place
Name and role, because an RN and an LPN are not the same row of the ratio. Licence expiry, because it is the fact most likely to be discovered late. A shift code per day, kept to four values so the grid stays readable at arm's length. A per-nurse total, so the person carrying six shifts is visible before payroll finds her.
The coverage block
Census per day, the ratio your unit works to, nurses required, and the over/under. Required is census divided by the ratio, rounded up: you cannot roster four-fifths of a nurse. A negative over/under is a day you are short, and it is worth more than any amount of confidence about how the week looks.
Day and night counted separately
A ratio applies to a shift, not to a date. A day with six nurses on it can be perfectly staffed at 08:00 and two short at 23:00, and a single count per day averages that away into a number that is true of no moment in the actual day. The sheet counts D and N separately for that reason.
How do I build a nursing rota?
Fix the coverage you need before you write a single name, then fill the hardest shifts first and let the easy ones fall out at the end.
The order matters more than the tooling. Start from the census you expect and the ratio you work to, which gives you a required number per shift per day. That is the target, and it is the only thing on the page that is not negotiable. Then place the constrained people: the nights, the person who is unavailable Thursday, the two staff whose competencies are the only ones that cover the unit. Nurses with wide availability are the easiest to place and should therefore be placed last, because every one you place early removes an option from a problem that has not been solved yet.
Then do the pass that nobody enjoys: read down each person's row rather than across each day's column. The grid is built column by column and it fails row by row: six shifts in seven days, a night finishing at 07:00 followed by a day starting at 07:00 the same morning, someone on their fourth consecutive twelve. Those are invisible while you are filling in Tuesday and obvious the moment you read a single nurse's week.
Publish it somewhere with a version and a date. Not because anyone will read the version, but because a rota that exists in four inboxes at three revisions is a rota where two nurses will arrive for the same shift and neither of them will be wrong.
What this template cannot check for you
Everything that matters most: it cannot see a licence expiry, it cannot count rest between shifts, and it cannot refuse.
The licence column will hold whatever date you type into it, including a date in the past, and the grid beside it will accept the name anyway. The over/under row will show you a shortfall and let you publish it. Nothing here compares a night ending at 07:00 with a day starting at 07:00, and nothing here knows that the same nurse is also on the rota at your second site. A spreadsheet is a record of a decision, and it is genuinely good at that; it has no view about whether the decision was allowed.
That is the boundary of the artefact, not a complaint about it. Most units run on exactly this and are fine, because the charge nurse is carrying all of the above in her head and is usually right. It stops being fine at the point where nobody can hold it all: more staff than a screen, more than one site, agency and per-diem in the mix, a state survey asking what the coverage was on the fourteenth. That is where MedAligna refuses the assignment rather than recording it, and blocks a Friday shift for a licence that lapses on Thursday. It is the same grid, with an opinion.
Questions people actually ask
- Do I have to give an email address to download it?
- No. The download link is a direct file: no form, no account, no confirmation email. Take it and go.
- What do the shift codes mean?
- D is a day shift, N is a night, OC is on call, PTO is approved time off. An empty cell is a day off. Four codes is deliberate: the grid has to be legible from arm's length on a break-room wall, and a legend of eleven abbreviations is one nobody reads.
- Can I open it in Excel or Google Sheets?
- Both. It is a CSV with real formulas, so the counts and the over/under row recalculate as you type. Excel on Windows, Excel on Mac, Google Sheets, LibreOffice and Numbers all read it.
- How do I change the ratio?
- Type over the number in the ratio cell; the sheet points at it. Nurses required is census divided by that figure, rounded up, per day. The sheet applies whatever ratio you give it; it does not know which one your unit is held to.
- Can I use it for a whole month?
- It is built as a week, because a legible week beats an illegible month and most units re-plan weekly anyway. Copy the sheet four times and change the dates in the header row if you would rather work a month at a time.
Related
When the grid stops being able to say no
MedAligna is the same rota with the rules attached: a licence lapsing Thursday cannot be scheduled for Friday, and the coverage row turns red the day it falls short. Fourteen days free, no card.