Do you want to manage your staff’s allocations, shift schedules and view the results in a 4 week grid fashion (like below)? Then you are going to love my FREE Staff Roster Excel Template.
![Beautiful 4 week roster template for staff management - Excel](https://chandoo.org/wp/wp-content/uploads/2024/02/STAFF-ROSTER-TEMPLATE.png)
What can you do with this template?
- You can set up (up to 3) employees on shifts across a 4 week grid.
- See who is working on what days with staff pictures
- Manage employee’s time off and get alerted if you map someone on their day off.
- Look at staff allocation and workloads in a graph to see who is doing more and who is doing less work.
- Beautiful, simple and elegant worksheet to interactively manage the shift / roster.
Template Compatibility
This template is designed to work with modern Excel only. You need Excel 365 or Excel on Web to use this file.
How to use this template?
![5 Features of the Excel Roster Template](https://chandoo.org/wp/wp-content/uploads/2024/02/5-features-of-the-roster.png)
Step 1: Set up your employee data on the “employees” tab. You need the names & their pictures. When adding pictures, use insert picture > in-cell option to add them to the cells.
![Add employee details - Staff roster template](https://chandoo.org/wp/wp-content/uploads/2024/02/employee-list-for-roster.png)
Step 2: Add any time-off or vacation information using the “Vacations” tab. Specify the employee name and date on which they are away.
![Employee vacation (time-off) data](https://chandoo.org/wp/wp-content/uploads/2024/02/vacation-details-for-roster.png)
Step 3: Set the start date for the roster, using the cell G3. Optionally, set the week start. Leave the value as 1 to start the week on Monday.
![setting up the start date for employee schedule](https://chandoo.org/wp/wp-content/uploads/2024/02/start-date-for-roster.png)
Once you change G3 value, the roster will display next 4 weeks worth of dates in the grid.
Step 4: Using the drop-down options in each day, map employees to the shift. You will get a warning icon if you either duplicate a name or if the employee is on vacation.
![demo of the staff roster](https://chandoo.org/wp/wp-content/uploads/2024/02/roster-demo.gif)
Step 5: Refer to the Workload graph on the right to see how busy your staff are. Use it to assign work fairly.
![workload calculation and graph](https://chandoo.org/wp/wp-content/uploads/2024/02/roster-workload-graph.png)
Step 6: That is all. There is no step 6. Happy Rostering.
Employee Roster Template -How to use it? [Video Tutorial]
Need help with rostering your staff or setting up employee schedules? Watch this tutorial to understand how I built this workbook and how to use it.
Download Staff Roster Template
Click here to download the Staff Roster Workbook.
Try Other Excel Workbooks too…
I have dozens of templates on all aspects of managing a business. Check out some of the below to speed up your work.