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.

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.

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, 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.

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.

Try it on your own team

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

Make a rota generator