Skip to content
SQUADRA

← Guides

How to run a rugby club without spreadsheets

The spreadsheet is not the enemy. The trouble starts when it becomes the only place where the club’s memory lives, and that memory belongs to one person.

Fictional example: one player with a complete record, a fee marked as paid and a confirmed call-up for Saturday.
Explanatory diagram with fictional data; this is not an app screenshot.

Most amateur rugby clubs run on the same three things: a spreadsheet that one person understands, a group chat that everyone else lives in, and the memory of whoever has been there longest. It works for years. Then the treasurer steps down, or the club adds a second category, or a parent asks a question about consent and nobody knows where the answer is written.

This guide is a plan for getting out of that situation without losing a season on the way. It works with any tool, including a better-organised spreadsheet, and it ends with an honest note about where Squadra fits.

What the spreadsheet is actually doing for you

Before replacing anything, list what it does. In most clubs it is quietly doing five different jobs:

  1. Player records. Names, dates of birth, positions, shirt numbers, phone numbers, guardians.
  2. Fees. Who owes what, who has paid part, who is late.
  3. Call-ups. Who is available for Saturday, usually copied from messages.
  4. Line-ups. The fifteen, the bench, and who plays where, usually in a different file.
  5. Communication. Not in the spreadsheet itself, but in the group chat that sits next to it and disagrees with it.

Five jobs in one place is why it is hard to leave: there is no single thing to replace. The trick is to separate them first.

Step 1: write down the questions the club needs to answer

A system is only as good as the questions it can answer. Before choosing a tool, write the ten questions people actually ask in a season. Typically:

If a tool cannot answer most of your list without an afternoon of manual work, it is not an improvement.

Step 2: one list of people, in one place

The most important change, and the cheapest, is to have one place where every person is recorded once. Every other list (fees, call-ups, line-ups) should refer to that list, not copy it.

A usable record for a rugby player holds:

Anything else (height, weight, emergency contacts, medical notes) should be decided deliberately, one field at a time, and with a clear idea of who is allowed to read it. The usual error is a shared spreadsheet where the link-holder sees everything, including data about minors. That is worth solving before the tool, not after.

If players fill in their own record when they join, rather than a coach typing it in, you get fewer mistakes and nobody has to chase twenty people for a date of birth.

Step 3: fees as a ledger, not a colour

Colouring cells green and red works until the first part payment. Then a parent pays 80 of 150 and the colour has nothing to say.

A fee record needs, at minimum:

Decide as well whether the club collects money through the tool or simply records it. Many clubs only need the second: the money moves by transfer or cash as it always has, and the record is what stops the arguments. Keep expenses (referees, buses, federation, kit) in their own record, with the receipt attached, separate from what members pay.

For the treasurer’s replacement in three years’ time, write down on one page what each concept means and who decides the amount. It is the document that is almost never written and almost always needed.

Step 4: call-ups as a list with states

Move the question «who can play on Saturday?» out of the group chat. A call-up is a list of people with a status for each: yes, no, no answer yet. A «no» should carry a reason, so the staff can tell a work shift from a sore calf.

Two design decisions save you a lot of trouble:

There is a longer treatment in the guide to call-ups without the group chat.

Step 5: build the line-up from the people who confirmed

The line-up is the part clubs most often keep in a separate file, retyped every week. It should come out of the call-up: the confirmed players, with the shirt number and position from their record, already in place, so that your job on Friday is to move people, not to type names.

A line-up check worth having, whatever the tool: fifteen starters, a shirt number on each, and a position on each. It sounds trivial. It is the mistake that appears on the team sheet ten minutes before kick-off.

If you share the line-up as an image for players and families, do it from the same record, so it cannot disagree with the one the coach is using.

Step 6: separate the announcements from the conversation

A group chat mixes three kinds of message: official notices («training is cancelled»), logistics («who has the bibs?») and banter. The notices get lost, and that is the one thing a club cannot afford.

Separate them, with any tool:

And for under-18s, decide in writing who can talk privately with a minor. A single adult messaging a child alone is a situation clubs avoid by design, not by good intentions.

Step 7: move in a quiet week, and run both for a month

The worst moment to switch is mid-season, and the second worst is the week before the first match. The least painful plan:

  1. Close the current season in the spreadsheet. All the way. Do not try to migrate five years of tabs built on different criteria; archive them as a PDF.
  2. Start the new season in the new system, registering each person once.
  3. Run both for one month. Record in both, compare, and fix the mismatches while you still can.
  4. Retire the old one on a date you announce, not by letting it fade.

Tell people what changes for them in two sentences each: players, parents, coaches, treasurer. Four short messages are better than one long explanation that nobody reads.

What to keep in a spreadsheet

Do not throw the spreadsheet away out of principle. It is still the right tool for a one-off calculation, a quick budget scenario, an event with a list of forty items, or anything that has one author and one purpose. The goal is not «no spreadsheets». It is that the club’s core records (people, fees, call-ups, line-ups) do not live in one.

Where Squadra fits, and where it does not

This section is about one specific tool, so read it as such.

Squadra covers the steps above for a rugby or American football club:

What it does not do: it does not move money or collect fees (it records them), it does not send phone push notifications today (notices appear inside the app), and a club is of a single sport. To get your data out, fees and treasury export to CSV; do not assume everything does, and ask for exactly what you need before you commit.

The honest test

Pick a Monday, and without asking anyone try to answer: who owes the club money, who is playing on Saturday, and who is the guardian of the youngest player? If any of those needs a phone call, your club’s memory is still in someone’s head.

Start with the one that hurts most. For most clubs it is fees; for the rest it is the call-up. The rest follows once the first one works. If money is where it hurts, read getting the club out of Excel next.