Free multi-location roster template (Excel)
Schedule staff across multiple sites or locations in one template. Perfect for franchises, multi-site retailers and service companies that need to coordinate coverage across different venues from a single roster.
Multi-location roster
Excel format (.xlsx) • Ready to download
No signup required. Works with Excel and Google Sheets.
This multi-location roster template is a general planning tool only. It does not calculate travel time, wages, penalties, overtime or award entitlements. For pay-aware scheduling and compliance support, use dedicated rostering software and check your obligations with Fair Work. It does not constitute legal, HR, or professional advice and should not be relied on as a substitute for advice specific to your business, workforce, or circumstances.
What's in this template
A unified view across all your sites
Location column
Tag the site or branch for every shift, so you can filter and sort by location in seconds.
Employee name
The staff member assigned to each shift — keep a single roster across all your sites.
Shift date
The day of the week or specific date the shift falls on, so nothing is double-booked.
Shift time
Start and end times for each shift, ready to read at a glance per site.
Notes
Travel arrangements, site access, keyholder contacts and anything else a manager needs.
Filter by site
Use Excel filters on the Location column to view, print or send one site at a time.
How the multi-location view works
Each row is a single shift at a specific site. The Location column lets you filter and sort by site, while still seeing the complete network picture when you need it.
| Location | Employee | Day | Shift | Notes |
|---|---|---|---|---|
| Sydney CBD | Sarah Jones | Monday | 9am - 5pm | |
| Parramatta | James Smith | Monday | 8am - 4pm | Keys with manager |
| Sydney CBD | Emma Wilson | Monday | 12pm - 8pm | |
| Bondi | Sarah Jones | Tuesday | 9am - 5pm | Covering for Tom |
How to roster staff across multiple locations in Excel
Four steps to coordinate every site
1. Centralise every site
List all your locations on one sheet with a Location column, so the whole network sits in a single view instead of scattered files.
2. Tag who can work where
Keep a second tab listing each employee and their approved sites. Cross-reference it so you only ever assign staff to locations they can cover.
3. Assign shifts and travel
Add one row per shift with the site, person, date and time. Use the Notes column to flag travel time between sites and avoid back-to-back clashes.
4. Filter and share by site
Filter the Location column to copy out a single-site roster for each manager, then publish or print it.
Prefer to skip the setup? The free template above already has the Location column, filters and layout built in. For more on laying out a reusable grid, read our guide to designing roster templates.
Who uses this template
Built for businesses with more than one site
Franchises
Schedule staff across multiple stores from one roster
Multi-site retailers
Coordinate cover across several shops or branches
Service companies
Assign technicians and crews to different job sites
Running a franchise or chain? See our guide to franchise multi-site rostering and our deeper look at the challenges of multi-location rostering.
When one spreadsheet can't keep up
A multi-location roster in Excel works for a couple of sites. But once you're tracking who can work where, juggling travel time and making sure each manager only sees their own roster, a single sheet gets unmanageable fast. RosterElf builds each site's roster for you, factors in availability across your shared team, and shares it straight to staff phones.
Rostering guides
Plan smarter across sites with these how-to guides
Manage multi-site rosters
A practical guide to coordinating coverage, travel and shared staff across several locations.
Read the guideManage staff availability
Collect and track who is available at which site so you never over-book a shared team.
Read the guideDesign roster templates that work
Lay out a reusable roster grid so planning across sites takes minutes, not hours.
Read the guideRelated templates
Explore more free roster templates
Multi-location roster FAQ
-
Centralise every site on one sheet with a Location column, then add a row for each shift recording the site, employee, date and time. Keep a second tab listing which sites each employee is approved to work, and cross-reference it before assigning shifts so nobody is double-booked. This free template comes pre-built with that layout, or follow the step-by-step section above. For a deeper walkthrough see our guide on managing multi-site rosters.
-
Add a separate sheet listing each employee and their approved locations, then cross-reference it when building the roster so you only assign staff to sites they can work. Collecting this up front is part of good staff availability management.
-
Yes. Each row is a separate shift, so one employee can have shifts at different sites across the week. Use the Notes column to record travel time between locations so you avoid scheduling back-to-back shifts at sites that are too far apart.
-
No — this is a planning template only. It does not calculate travel time, wages, penalties or award entitlements. Record travel arrangements in the Notes column, and for automated multi-site scheduling and pay-aware calculations use dedicated rostering software.
Before you download
General information only — not legal advice
This document is a general HR template provided for informational purposes only. It is not legal advice and may not reflect the latest changes in legislation or apply to every workplace situation. RosterElf Pty Ltd and the template provider accept no liability for any loss arising from reliance on this document. Users should seek independent legal advice and customise the template to ensure it complies with all relevant laws, awards and workplace requirements.