Staff scheduling
Staff scheduling in Excel or scheduling software: what suits your team?
A rota in Excel: the columns, the rules of the Dutch Working Hours Act, a free template, and what Shiftbase, Werktijden.nl, L1NDA and Bedrijfsrooster cost.
A rota in Excel works fine for a small team with fixed shifts. We show how to set it up, which rules of the Working Hours Act your rota must meet and when scheduling software pays off, with the prices of four packages.
Staff scheduling in Excel: the short answer
For a team of a few people with fixed shifts, a rota in Excel or Google Sheets is fine. It gets difficult as soon as you work with varying shifts, employees want to swap among themselves, you collect availability via WhatsApp or you want to know whether everyone reaches their contract hours. Then scheduling software saves the planner hours a week, and everyone sees their rota in an app. Scheduling software costs from free for a small team to around €3 to €9 per employee per month. On 16 November 2026 we checked the prices of four packages. This article is written for businesses in the Netherlands.
Setting up a rota in Excel
The easiest approach is a list with one row per shift, rather than a weekly grid with a box per day. Then you can add up per employee and per week. These are the columns you need:
| Column | What you enter |
|---|---|
| Date | The day of the shift |
| Employee | The name, chosen from a list so it is always spelled the same way |
| Start and end | For example 08:30 and 17:00 |
| Break | In minutes |
| Hours | End minus start minus break: the formula calculates it, also for a shift past midnight |
| Week | The week number, calculated from the date |
| Check | A warning if a shift is longer than 12 hours or the break too short |
On a second tab you enter each employee's contract hours per week, and Excel adds up the scheduled hours in a chosen week. The difference shows who is scheduled too much or too little. You can download our rota template: with fictitious examples, an overview per week and a check on shifts and breaks.
The rules your rota must meet
The Working Hours Act also applies if you plan in Excel. The main rules, as the Dutch government explains them:
- Per shift and per week: a maximum of 12 hours per shift and 60 hours per week. Over 4 weeks an average of no more than 55 hours per week, over 16 weeks an average of 48.
- Rest between shifts: 11 consecutive hours. Once every 7 days this may be 8 hours, if the work requires it.
- Rest per week: 36 consecutive hours per 7 days, or 72 hours per 14 days, possibly in two periods of at least 32 hours.
- Breaks: anyone who works longer than 5.5 hours is entitled to a 30-minute break, which can be split into two quarters of an hour. Above 10 hours it is 45 minutes (break rules).
Stricter rules apply to young people under 18 and to pregnant employees, and your collective agreement may differ. Our template checks the length of a shift and the break; you check the rest between shifts and per week yourself. Scheduling software often does that automatically.
Where Excel falls short
- Collecting availability: you ask via WhatsApp or email who can work when, and put it into the rota by hand. In scheduling software, employees enter their own availability in the app.
- Swapping and changes: if someone swaps a shift, you have to update the rota and send it round again. Who has the latest version?
- Leave and sickness: a leave request is in your email, not in the rota. You schedule someone who is off.
- Hours and pay: you retype the hours worked for the payslips. Scheduling software lets employees clock in and passes the hours on to your payroll package.
- Checking the rules: a spreadsheet does not see that someone starts again too early after a late shift.
If you plan for more than ten or so employees, or work with varying shifts in the evening and at weekends, scheduling software usually pays for itself quickly.
What does scheduling software cost?
Four packages from our staff scheduling category, with the prices as the supplier shows them on its own website on 16 November 2026. The amounts are per month.
| Package | Price | What to look for | Source |
|---|---|---|---|
| Shiftbase | Free €0 for up to 15 employees; Basic €30 for 6 employees, then €4 per employee; Premium €75 for 12 employees, then €5.25 | Free has 1 department and manual scheduling; 10 per cent off when billed annually | rates |
| Werktijden.nl | Basis €25 plus €4 per employee; Plus €31 plus €6; Pro €72 plus €9 | About 20 per cent cheaper when billed annually; excluding VAT; 14-day free trial | rates |
| L1NDA | €5.20 per scheduled employee | No fixed fee: if you schedule nobody, you pay nothing; cancellable monthly | pricing |
| Bedrijfsrooster | Basis €47 for 10 employees | Larger teams cost more; 10 per cent off when billed annually; 14-day free trial | prices |
A worked example for a team of 12 employees, billed monthly: Shiftbase Basic costs €30 plus 6 times €4, together €54; Werktijden.nl Basis €25 plus 12 times €4, together €73; L1NDA 12 times €5.20, together €62.40. If making and sending round the rota now takes you three hours a week, that is soon worth more.
How to switch from Excel to scheduling software
- Prepare your employees and contract hours: most packages import a list from Excel.
- Create your standard shifts: such as early, late and weekend, with start, end and break. Then you can plan with a few clicks.
- Have employees install the app: and enter their availability for the coming weeks.
- Run both for a few weeks: plan in the package and still send your Excel rota alongside as a check, until everyone uses the app.
- Link the hours to your payroll package: check which integrations the package has with your payroll software.
If you want to know what AI can already do for your rota, read making a rota with AI. For leave there is a separate article on leave tracking in Excel or HR software.
Frequently asked questions about staff scheduling in Excel
Can I make a rota in Excel?
Yes. Put every shift on its own row with date, employee, start, end and break, and have Excel add up the hours per employee per week. That works well for a small team with fixed shifts.
Is there free scheduling software?
Shiftbase has a free version for teams of up to 15 employees, with one department and manual scheduling. You can try Werktijden.nl and Bedrijfsrooster free for 14 days.
How far in advance must a rota be published?
The Working Hours Act requires you to publish the rota at least four weeks in advance, unless your collective agreement or a company arrangement says otherwise. If you change it later, the law requires a good reason.
How many hours may someone work per shift?
Under the Working Hours Act, a maximum of 12 hours per shift and 60 hours per week, followed by 11 hours of rest. Anyone who works longer than 5.5 hours is entitled to a break of at least 30 minutes.
Does Google Sheets work as a rota too?
Yes, and the advantage is that you can share the rota so everyone sees the same version. You can open our template in Google Sheets. Give employees read-only access, so nobody changes a shift by accident.


