Running a Paddling Club Roster Without a Spreadsheet

Ask a paddling club where its roster is and you'll get one of three answers. A Google Sheet somebody set up four years ago. A WhatsApp group with 63 members and no idea which of them still paddle. Or the club secretary's head.

Usually all three, and they disagree.

This is not a small problem dressed up as a big one. The roster is the thing every other decision reads from: who to seat, who to invite, who's been missing, who's paid, whose parent has signed what. When it's wrong, everything downstream is quietly wrong too — and nobody finds out until line-up night.

What a roster actually has to hold

A list of names is not a roster. Here's what a paddling club genuinely needs on file, and what each field is for:

• Name and contact — obviously. But contact needs to be reachable without anyone circulating phone numbers, because you will eventually add a member who doesn't want theirs in a 60-person chat.
• Paddling side. Left, right, or both. This single field decides whether your boat can even be filled. "Both" is the most valuable entry in the whole sheet and the one most likely to be missing.
• Weight, and when it was measured. Not for anybody's ego — for hull trim. A weight from two seasons ago is folklore.
• A time trial or test result. The number you actually select from. Divided by weight, not on its own.
• Squad. Masters, youth, mixed, race crew. Most clubs are three clubs in a trenchcoat, and one flat list forces you to filter by hand every single time.
• Role. Coach, paddler, steersperson, drummer. Determines what someone should be able to see and do.
• Consents. Photo permission, and for anyone under 18, guardian permission. This is the field clubs skip and then discover they need on the day a photo goes up.
• Attendance history. Not because you're policing anybody — see the attendance post — but because "who's actually been in the boat this month" is the input to almost every selection conversation.

Now count how many of those your spreadsheet has, and how many are current.

The four ways the spreadsheet fails

It's worth being specific, because "spreadsheets are bad" is not an argument and most coaches have heard it from someone selling something.

1. It has no owner, so it has no truth. Everybody can edit it, which means nobody is responsible for it. Two people sort the same column differently on the same evening and one of them silently wins.

2. It can't be read on a dock. A 14-column sheet on a phone in the rain, with wet hands, is not a usable interface. So the coach doesn't open it, and the marks get entered "later" — which is to say, sometimes.

3. Members can't maintain their own row. Every change routes through one volunteer. New phone number? Message the secretary. Switched to paddling both sides? Message the secretary. The secretary is on holiday. The sheet decays.

4. It doesn't know what it means. A sheet holds "84" in a weight column. It doesn't know that's stale, or that the person is now injured, or that they've missed six sessions. It can't tell you anything you didn't already type.

Moving off it without losing a season

The mistake is treating this as a migration project. It isn't. It's a season of running two things in parallel and letting one of them win.

Start with the roster only. Not attendance, not video, not crew plans. Get every current member listed once, with side and role correct. Ignore everyone who hasn't paddled since last season — if they come back, they come back, and re-adding one person is easier than auditing forty.

Let people fill in their own details. This is the entire difference between a roster that decays and one that doesn't. Send an invite link, let each paddler enter their own side, weight and contact, and the field that used to route through one volunteer now maintains itself.

Keep the spreadsheet read-only for one season. Don't delete it; freeze it. If something is missing you can look, but nobody edits it. A sheet you can still edit is a sheet people will still edit.

Do the first real test on a low-stakes night. Line-up for a regular Tuesday, not for a regatta. You want to discover a missing "paddling side" field on a night when it costs you five minutes, not on the day the boat has to be on the water at nine.

Then add one thing at a time. Attendance next, because it feeds selection. Practices with RSVPs after that, because they feed attendance. Everything else can wait.

What you get back

The honest answer is: fewer messages. A roster that maintains itself removes an entire genre of admin — the "can someone send me the list" thread, the "is X still paddling" question, the version of the sheet that got copied and edited in a fork nobody knew about.

The less obvious answer is that decisions get better. Once side, weight and a test result are current for everyone, seating stops being an argument about who's strongest and starts being arithmetic — and the arguments you do have are about the things worth arguing about.

PaddleLens does this half for free: roster, squads, invite links, practices, roll call, messaging and photo folders, for the whole club, with no per-member software cost. The club side of it is here. Optional video analyses and text packs are metered, and a club may separately collect its own dues through a connected Stripe account; you can run a whole season without using any of them.

Whatever you use, the test is the same: can a coach open it one-handed on a dock, and can a paddler fix their own row without asking permission? If the answer to either is no, you'll still be running on the spreadsheet a year from now — just with a second system beside it.