A church rota that spots the clashes for you

Whoever does the church rota knows the drill: a spreadsheet that has grown for years, a pile of holiday messages, and a sinking feeling when the same four people end up doing everything. This kit gives the job some structure.

List the jobs you fill each week (up to 12 slots, such as Welcome, Reader, Sound desk, Children's team, Refreshments) and the skill each one needs. Add your volunteers with their skills and how often they are happy to serve. Then fill the Rota by picking names from drop-downs.

As you go, the Rota warns you. Red means that person said they are away that day. Amber means they are already on the rota that day. Lilac means the slot needs a skill they have not listed. Each row counts gaps and clashes, and the Dashboard shows gaps in the next four weeks.

The Fairness tab counts how many times each person serves in each month, and highlights anyone over the limit they gave you. The Weekly Rota tab turns any date into a clean list of jobs, names and phone numbers, ready to print or paste into your group chat. There is also a simple reminder column for safeguarding check renewal dates.

It uses plain formulas with no macros, and works in Excel and Google Sheets. The PDF guide walks through every tab and includes printable pages: a blank rota, a volunteer sign-up form, an away dates form, a team contact list and a "This Sunday's team" sheet.

If your rota lives on a piece of paper by the door or in a messy spreadsheet, this is an easy step up. Add your volunteers, name up to six jobs, set the first Sunday, and pick names from drop-downs. If someone ends up on twice in one day, the cell turns amber. The Volunteers tab counts how many times each person is on, so it is easy to share the load.

It is free to use for any church or ministry. The PDF guide includes a printable blank rota.

When you need more (a full year, away dates, skill checks, a fairness view and a printable weekly list), the full Steeple Sheets Volunteer Rota Kit is there.