On-call rotation schedule template for small teams
For a team of 3 to 10, the simplest fair on-call rotation is weekly: one person is on call for seven days, handing off on the same weekday and time each week, with the next person in line as backup. List your team once and this free template fills in 52 weeks, then flags any week where the person on call has time off.
How do you set up an on-call rotation for a small team?
Put everyone who can respond in a fixed order, pick a handoff day and time, and rotate one person per week. Make the next person in line the backup, so they are already warm when their week starts. Check the rotation against planned time off before it starts, swap weeks rather than rebuilding the schedule, and write a short handoff note at the end of each week. Ample's free template does the rotation, the backup and the time-off check in Excel or Google Sheets. It does not page anyone or connect to alerting tools.
Free .xlsx and .csv · No signup · Up to 10 people · 52 weeks
What's in the workbook
- Setup
- Up to 10 names in rotation order, the first day of week 1, the handoff time and time zone, who to escalate to if the person on call can't respond, and where incidents are logged.
- Rotation
- 52 weeks, each with start and end dates, the scheduled primary and backup, a Swap to column, the resulting On call name, a Time-off check, handoff notes and incidents. The primary and backup come from the Setup list by formula, so adding a name re-flows every week.
- Time off
- One row per planned absence: person, first and last day off, notes. The Rotation tab reads it to flag clashes.
- CSV for Google Sheets
- The Rotation column headings only, for importing into a Sheet you already use. A CSV can't carry formulas or the other tabs; for the full workbook in Google Sheets, import the Excel file as described below.
What the time-off check says
| Message | What it means | What to do |
|---|---|---|
| On call has time off: swap | The person on call that week has planned time off that overlaps it. | Type a covering name in Swap to. |
| On call is also backup | A swap put the scheduled backup on call, so the week has no separate backup. | Name another backup in the handoff notes. |
| Backup has time off | The backup is away for part of the week. | Agree a different backup for those days. |
| OK | No overlap with the Time off tab. | Nothing. |
The check only knows what's on the Time off tab, with names spelled the same way as on Setup. It doesn't know about public holidays, time zones or who has the skills for a given system.
A filled-in on-call rotation example
Fictional example. Replace the names and dates with your own.
A four-person team, Maya, Jon, Priya and Leo, hands off every Monday at 10 a.m. Pacific, starting November 2, 2026. Priya is off November 18 to 20, so the check flags week 3. Leo takes week 3 and Priya takes Leo's week 4 in return. Jon is off December 1 and 2, the backup days in week 5, so the team agrees Priya backs up those two days.
| Week | Dates | Scheduled primary | Scheduled backup | Swap to | On call | Time-off check |
|---|---|---|---|---|---|---|
| 1 | Mon Nov 2 to Sun Nov 8 | Maya | Jon | Maya | OK | |
| 2 | Mon Nov 9 to Sun Nov 15 | Jon | Priya | Jon | OK | |
| 3 | Mon Nov 16 to Sun Nov 22 | Priya | Leo | Leo | Leo | On call is also backup |
| 4 | Mon Nov 23 to Sun Nov 29 | Leo | Maya | Priya | Priya | OK |
| 5 | Mon Nov 30 to Sun Dec 6 | Maya | Jon | Maya | Backup has time off |
Leo was week 3's scheduled backup, so after the swap the check says "On call is also backup". The team writes Jon in as week 3's backup in the handoff notes. Before the swap, week 3 said "On call has time off: swap".
Keep a small team's rotation fair
- Weekly beats daily for 3 to 10 people. Fewer handoffs means less context lost. With four people, each person is on call one week in four.
- Hand off on a weekday, during working hours. A Monday or Tuesday morning handoff means both people are around to talk through open issues.
- Swap, don't rebuild. When someone is away, trade a week. The order for everyone else stays the same, so people can plan around it.
- Count the weeks. Over a year, a fixed order gives everyone the same number of weeks, give or take one. Holiday weeks are the ones to share out by agreement.
- Agree what on call means. How fast to respond, during which hours, and what can wait until morning. Write it next to the escalation contact on the Setup tab.
- Give the time back. If someone was woken up overnight, make the next morning easy. A rotation that burns people out stops being covered.
Whether on-call time has to be paid depends on how free the person is while on call, and on where they work. In the US, the Department of Labor says someone required to stay on call at home is not working in most cases, but more limits on their freedom can make it paid time (Fact Sheet #22, Hours Worked). State and country rules vary; check yours.
The weekly on-call handoff
Write the handoff note in the Rotation tab before your week ends, then spend 10 minutes going through it with the next person.
- Open incidents and what's been tried.
- Anything that alerted often or looked flaky this week.
- Planned changes or launches in the coming week.
- Access the next person needs and has checked they can use.
- Follow-ups that belong to someone else, with their name.
For a longer absence where more than on-call duty needs cover, use the vacation coverage plan template for who covers what, and the vacation handoff template for the detail behind one responsibility.
Plan on-call around time off
Most rotation problems are time off nobody checked. Before the rotation starts, and again each month, add everyone's planned leave to the Time off tab and look for flags.
- Use the team coverage planner to check that enough people are left on a given day, not just the person on call.
- See overlapping absences on the team vacation calendar.
- Count the working days in someone's leave with the vacation days calculator.
- On call across time zones? Check which hours the primary and backup both work with the time zone overlap calculator.
Use the on-call rotation in Google Sheets
For the full workbook with all three tabs and the formulas:
- Download the .xlsx template and upload it to Google Drive.
- Open it with Google Sheets, then choose File → Save as Google Sheets. This makes a separate Sheets copy.
- Type two names on Setup and a start date, and check that week 1 and week 2 fill in on the Rotation tab.
- Share the Sheets copy with the team, so everyone sees one schedule.
To add the rotation table to a Sheet you already use: download the CSV, then in Google Sheets choose File → Import → Upload and pick Insert new sheet(s). You get the column headings without formulas.
Google documents the conversion in Use both Excel and Sheets.
Keep on-call next to the time off
Ample keeps leave dates, team coverage and handoff notes together, so a clash shows up when the request comes in, not the week of. The template is free to use without it.
Get early access