Kick-start your next staff roster with a free downloadable Excel template.

Create printable staff rosters, track staff hours and automate payroll in Excel.
Download template Create an online roster

Laptop with a free Excel staff roster template

Getting started

Once you've downloaded your template, save it on your computer somewhere safe and then open the file. Once the file is open you will need to click "Enable Editing" and "Enable Content" as each prompt is displayed at the top of the document. You will need to enable editing if you want to be able to make changes, and you will need to enable content if you want the totals to calculate.

Enabling macros in Excel

Adding staff

If you've already started on a template and run out of space for your staff you can always add new rows. As there are formulas in the "Hours" and "Pay" columns it's best to select the row of an existing staff member, right click and select "Copy", then select the row where you'd like the new staff member, right click it and select "Insert Copied Cells".

Adding staff to your roster template

Entering shifts

For Excel to interpret shifts and calculate your totals correctly the shifts must be entered in a clear and consistent format, e.g. "9am-5pm" or "9:00-17:00". Shifts that cannot be interpreted will be ignored when totalling hours and pay. When staff are working two or more shifts per day you can split the shifts with a slash "/", or a new line by pressing ALT + ENTER.

Adding shifts to your staff roster

Unpaid breaks

To deduct an unpaid break from a staff member's hours and/or pay, you'll need to add an entry like you would add a shift (separated with a new line or a slash) in the format "1 hour break" or "30 minute break". You're free to enter any amount of time you like too, as long as you end the entry with the word "break".

Adding unpaid breaks to your staff roster

Looking for a little more power?

Create your staff roster for just $25 per month. Our site provides all of the functionality found in the template, bundled together with time off requests, text & email alerts, real-time reporting, overtime rates, day rates, salaries, shift reminders, payroll exports, timesheets, time-clocking and 24/7 online access for managers and staff.

Play with our demo or Build your own roster