Free shift swap template (Excel)
A shift swap template records every swap between staff: who gives the shift up, who takes it, the date and times, who approved it and when. This one keeps a running log in date order, works out the hours of each swapped shift, overnight shifts included, and has a column to confirm the 11-hour rest still holds.

Every swap means updating the log, the wall copy and payroll by hand.
In RosterElf staff offer up a shift from their phone, colleagues free to cover it are notified, and a manager approves the swap. The rota updates for everyone, and approved hours go to Xero UK or a CSV.
Your download has started.
Three checks before you approve a swap
A like-for-like swap on paper is not always one in practice. The declined swap in the example failed the first check.
Rest either side
Eleven hours between the end of one working day and the start of the next, for both people. Callum was closing at 23:00 the night before, so a 07:00 start would have left him 8 hours.Skills for the role
Whether the person taking the shift has the training or certification it needs: a personal licence holder on a bar, food hygiene in a kitchen.Hours for both people
What the swap does to each person’s week. It can create overtime, push someone towards the 48-hour average, or take an under-18 past 8 hours a day.What’s in the file
- A Swap Log: who gives up the shift, who takes it, and when
- Hours per swap worked out from start and finish by formula
- Drop-downs for status and the rest check, plus who approved it
- 30 rows to log swaps, and an Instructions tab
Next week’s rota from this week’s, in one click
For when copying the sheet every week becomes the job.
Save a week as a template and copy it forward
- Save any rota as a reusable template
- Copy last week’s rota instantly
- Clone individual shifts across days
- Staff see their shifts on the iPhone and Android app
More rota templates
Working time rules from GOV.UK: maximum weekly working hours and rest breaks at work. The file counts hours only; it does not work out pay.
Shift swap FAQ
-
Unless the contract says otherwise, a swap needs the employer’s agreement: the shift is rostered to a person, and two staff cannot reassign it between themselves. In practice most employers approve routinely, but the approval is what makes the swap the employer’s record rather than a private arrangement.
-
A swap the worker requested is not the employer changing their shift, so the coming right to reasonable notice and short-notice cancellation payments is aimed at employer-initiated changes rather than worker-requested swaps. The detail is subject to consultation. See our Employment Rights Act shift rights guide.
-
Because payroll works from the original rota unless somebody tells it otherwise. One swap is easy to remember; fourteen across a month is not. The log shows what changed, who agreed it and when, and it shows a pattern of one person routinely giving shifts away.
-
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets: the layout and the formulas carry over. It works in LibreOffice Calc too.
-
No. A rota records what was planned. Minimum wage compliance turns on what was actually worked, and the burden of proof sits with the employer, so you need a record of hours as well. Our free timesheet templates cover that side.