---
title: Rotation Schedule in Google Sheets or Excel? | RotaHog
description: 'Thinking of a rotation schedule template in Google Sheets or Excel?
  Compare it with RotaHog: automatic dates, reminders, swaps and one shareable link.'
---

1. [Compare](https://rotahog.com/compare)
2. Rotation spreadsheet

# A rotation schedule in Google Sheets or Excel, compared

Most rotations start as a spreadsheet, and most of them stop being updated by March. Here is what a sheet does well, and where it quietly falls over.

[Make a rota generator](https://rotahog.com/tools/rota-generator#create)[See the comparison](#comparison)

## Which one fits

### Stay with a spreadsheet if

The rotation is one of many columns in a sheet that does other jobs too, or the rules are unusual enough that only a formula you wrote yourself will capture them.

### RotaHog fits if

The sheet exists to answer whose turn it is, and the trouble is keeping it current: extending the dates, fixing the order when someone leaves and telling people it is their turn.

## RotaHog and a spreadsheet, side by side

| Feature | RotaHog | A spreadsheet |
| --- | --- | --- |
| Setup | Type names, pick a frequency | Build or copy a template |
| Dates for the next year | Generated automatically | Drag formulas down, then redo it next year |
| Who is up today | Shown at the top of the link | Scroll to find today's row |
| Someone joins or leaves | Rebalance redeals future turns (Team Toolkit) | Reshuffle by hand |
| One-off swap | Substitute for one turn, history kept (Team Toolkit) | Overwrite the cell |
| Reminder before a turn | Email (free), Slack (Team Toolkit) | Only with scripts |
| Marking a turn as done | From the email, Slack or the page | A checkbox, if someone adds one |
| Sharing | A link that needs no account | Sharing settings and permissions |
| Flexibility | Rotations only | Anything you can build |
| Cost | Free to start, $19 or $49 a year | Free |

Checked November 2026. Plan details are on the [pricing page](https://rotahog.com/pricing).

## Moving over

A spreadsheet is the most common rotation tool there is, and for good reason: everyone has one, it costs nothing and it bends to any rule. If you want to build one, this is the usual formula.

### The spreadsheet version

Put the names in a column, say `H2:H6`. Put dates in column A, one row per turn. Then, in B2:

`=INDEX($H$2:$H$6, MOD(ROW()-2, COUNTA($H$2:$H$6)) + 1)`

Fill it down and each row takes the next name in order. It works in both Google Sheets and Excel.

### Where it falls over

- **Someone leaves.** Remove a name and every past row recalculates, so the history rewrites itself unless you pasted it as values first.
- **A swap.** Overwriting one cell breaks the formula for that row, and nobody remembers why it says Dana.
- **The dates run out.** Somebody has to notice and drag them down again.
- **Nobody is told.** The sheet knows whose turn it is. The person whose turn it is does not.

### Moving over

Open the [rota generator](https://rotahog.com/tools/rota-generator), paste the names in the same order and set the start date to the next turn. You get a year of dates, a link anyone can open and, once you sign in, email reminders. Keep the sheet if it does other jobs, and link to the rotation from it.

## Questions

Something else? [Write to me](https://rotahog.com/contact).

#
### Is there a free rotation schedule template for Google Sheets?

There are many, and they work for the first few weeks. The trouble starts when the dates run out, someone leaves or a turn gets swapped. RotaHog is free for the same job: type the names, pick a frequency, and the dates are filled in for a year with a link everyone can open.

#
### How do I make a rotating schedule in Excel?

The usual way is a date column and a name column that uses INDEX and MOD on the row number to cycle through a list. It works until the list changes, at which point every future row shifts and past turns can rewrite themselves unless you paste them as values.

#
### Can I still export the schedule?

The schedule is a plain web page, so you can print it or copy the table into a sheet. The REST API on Team Toolkit returns every turn as JSON if you want to keep a sheet in sync automatically.

#
### Why not just add reminders to the spreadsheet?

You can, with Apps Script or Power Automate, and some teams do. It means someone owns a script that breaks when a column moves. RotaHog sends the reminder from the schedule itself, so there is nothing to maintain.

## Other comparisons

### [Opsgenie alternative](https://rotahog.com/compare/opsgenie-alternative)

For teams leaving Opsgenie who used it for the rota, not the paging.

Comparison
### [PagerDuty alternative](https://rotahog.com/compare/pagerduty-alternative)

For duty rotations that never needed an incident platform.

Comparison
### [Rota generator](https://rotahog.com/tools/rota-generator)

A duty rota for any task that goes round a group.

Weekly

## Try it on your own team

Type the names, check the dates, share the link. Free, and no signup.

[Make a rota generator](https://rotahog.com/tools/rota-generator#create)

```json
{"@context":"https://schema.org","@type":"FAQPage","mainEntity":[{"@type":"Question","name":"Is there a free rotation schedule template for Google Sheets?","acceptedAnswer":{"@type":"Answer","text":"There are many, and they work for the first few weeks. The trouble starts when the dates run out, someone leaves or a turn gets swapped. RotaHog is free for the same job: type the names, pick a frequency, and the dates are filled in for a year with a link everyone can open."}},{"@type":"Question","name":"How do I make a rotating schedule in Excel?","acceptedAnswer":{"@type":"Answer","text":"The usual way is a date column and a name column that uses INDEX and MOD on the row number to cycle through a list. It works until the list changes, at which point every future row shifts and past turns can rewrite themselves unless you paste them as values."}},{"@type":"Question","name":"Can I still export the schedule?","acceptedAnswer":{"@type":"Answer","text":"The schedule is a plain web page, so you can print it or copy the table into a sheet. The REST API on Team Toolkit returns every turn as JSON if you want to keep a sheet in sync automatically."}},{"@type":"Question","name":"Why not just add reminders to the spreadsheet?","acceptedAnswer":{"@type":"Answer","text":"You can, with Apps Script or Power Automate, and some teams do. It means someone owns a script that breaks when a column moves. RotaHog sends the reminder from the schedule itself, so there is nothing to maintain."}}]}
```
