Free Excel shift schedule template

In short: This template helps small teams keep a weekly rota in one clear spreadsheet. Record the date, start and finish time, break, employee, role, location and planned hours without creating an account.

The download is a CSV file that opens directly in Excel. Save it as an Excel workbook (.xlsx) if you want to add colours, formulas or separate sheets.

What the template includes

The template contains a sample week that you can replace with your own employees and shifts.

Column	Use it to
Day and date	Place the shift on the correct day.
Start and finish	Record the planned working period.
Break in minutes	Make the planned break visible.
Employee	Name the person assigned to the shift.
Role	Show which function the employee covers.
Location	Separate departments or workplaces.
Planned hours	Record the expected hours after the break.
Notes	Add short practical information about the shift.
Manager approval	Mark the schedule as checked before sharing.

Keep personal data to a minimum. A staff schedule does not normally need private phone numbers, health information or reasons for absence.

How to use it in Excel

1. Download the file. Open the CSV in Excel, Numbers or Google Sheets.
2. Save your own copy. Choose Excel Workbook (.xlsx) if you want to keep formatting and multiple sheets.
3. Adapt the sample week. Change the dates, roles and locations, then remove rows you do not need.
4. Assign each shift. Enter the employee, start, finish and planned break on each row.
5. Check and share. Review coverage and hours, then share one clearly named version with the team.

A filename such as Shift-schedule-week-37-2026.xlsx makes it easier to identify the week and version employees received.

Adapt the sheet to your workplace

One sheet is often enough for a small team. If you manage several departments, filter the Location column or create one sheet per department.

You can also make the schedule easier to scan by:

• using one colour for each role or shift type
• freezing the first row so column headings remain visible
• adding a total of planned hours for each employee
• marking open shifts clearly instead of leaving the employee field ambiguous
• protecting formula columns against accidental changes.

Avoid making the workbook more complex than the schedule requires. If only the person who built the formulas understands it, the plan will be difficult to maintain.

Check the schedule before sharing

A tidy spreadsheet is not necessarily a complete schedule. Check at least:

• that opening hours and essential roles are covered
• that no employee has overlapping shifts
• that starts, finishes and breaks produce the correct planned hours
• that contracted hours and employee availability have been considered
• that the plan follows the relevant rules on breaks, daily rest and other working-time requirements
• that employees receive the schedule within the notice period used by the workplace. See the guide to publishing a schedule in Denmark.

The applicable rules can depend on collective agreements, employment contracts and employee groups. The template supports the planning process but does not determine which rules apply to a particular employee.

When a spreadsheet stops being enough

Excel is a practical place to start, especially when the team is small and the schedule rarely changes. Friction usually increases when several people edit the file, shifts are swapped or employees need prompt updates.

Watch for these common problems:

• Multiple versions. An attachment or printout can quickly become outdated.
• Changes. Editing the sheet does not automatically notify the affected employee.
• Availability. Requests and absence may be spread across messages, emails and other files.
• History. It can be difficult to see who changed a shift and when.
• Actual hours. Planned hours are not the same as recorded working time.

When maintaining one current version becomes difficult, scheduling software can bring the schedule, availability, changes and employee access together. Explore shift planning in Monoplan, or keep using the template for as long as it fits your workflow.

Frequently asked questions

Is the shift schedule template free?

Yes. You can download it without signing up and adapt it to your workplace.

Does it only work in Excel?

No. The CSV file also opens in Google Sheets, Apple Numbers and LibreOffice Calc. Save a copy in the application's native format before adding advanced formatting.

Can I use it for several departments?

Yes. Filter the Location column or create one sheet per department after saving the file as an Excel workbook.

Does the template calculate employee hours automatically?

The sample file shows planned hours but does not contain protected or advanced formulas. Always check calculations involving breaks, overnight shifts and later changes.

Is an Excel rota enough for time tracking?

Not necessarily. A schedule shows planned hours, while time tracking should reflect the daily hours actually worked. Read the overview of working-time recording requirements in Denmark.