Mishmarotix
Shift management that actually works

Free staff rota template for Excel

A free staff rota template for Excel and Google Sheets: one week, morning, evening and night shifts, and room for three people on each shift. Download it, no sign-up.

Download

It opens in Excel, Google Sheets and anything that reads xlsx files. Change whatever you like: shift times, how many people per shift, and the days.

What is in the free staff rota template

  • A "Week starting" cell at the top, for the date the rota is for.
  • Seven day columns: Monday to Sunday in the English sheet, Sunday to Saturday in the Hebrew one.
  • Three shifts a day, set to 07:00–15:00, 15:00–23:00 and 23:00–07:00, each with three rows for names.
  • A notes row at the bottom, for swaps, absences or anything else the team should know.

How to use it

  • Write the date the week starts at the top of the sheet.
  • Adjust the shift times in the hours column to your business: morning, evening and night are set by default.
  • In each cell, write the name of the person on that shift on that day.
  • Keep a copy for each week, so you can go back to an earlier rota.

What a template does not do

A spreadsheet does not know who is available or who asked for time off, does not warn about short rest between shifts, and does not send the rota to anyone. All of that stays manual: collecting availability in messages, checking by eye, and posting a screenshot in the group.

As the team grows, that is exactly where scheduling software saves time. Staff submit availability from their phone, constraints are checked as you assign, and the rota reaches everyone at once.

Moving from the template to the product

Your staff list can be uploaded to Mishmarotix from an Excel file, so what is already in the sheet does not have to be typed again. The page on moving from Excel and WhatsApp explains what comes across and how.

Is the rota template really free?

Yes. It is free to download and use, with no sign-up and no card.

How many staff does it fit?

As it comes, three people on each of the three shifts, so nine names a day. Copy a row to add more people to a shift.

Do I need to sign up to download it?

No. The template is free and opens without signing up.

Does it work in Google Sheets?

Yes. The file opens in Excel, Google Sheets and any program that reads xlsx files.

Can I move from the template to the system without retyping everything?

The staff list can be uploaded from an Excel file, so what is already written is not written twice.

Start a free trial

Sign in