Back to Blog
running club operationsclub admin toolsrunning club foundersmember rosterclub communication

How to Move a Running Club Off Spreadsheets

How to move a running club off spreadsheets: sort every column, decide what stays in a sheet, and get members to rejoin in one place without losing anyone.

RunLink Team9 min read
A run club organizer at a cafe table after a morning run with a laptop, a highlighted printed member list and a phone, other runners chatting in the background

You can move a running club off spreadsheets, but you do not move the spreadsheet. You move the people. Sort the sheet column by column, give each kind of information its own home, keep the money and paperwork columns in a locked sheet on purpose, and run a short switch window where members join the new place themselves.

That last part is the one founders skip, and it is why so many migrations quietly fail. The new tool goes live, the old sheet keeps getting edited, half the club never makes the jump, and six weeks later you are maintaining two lists instead of one.

The reason it stalls is simple. Most club rosters are not one list. They are five lists stapled together in one file, and each of those lists wants a different home. Once you see the five lists, the move gets a lot less scary. This is part of run club management software decisions, but the method below works whatever tool you land on.

What is actually in your running club spreadsheet?

Open the sheet and look at it like a stranger would. A typical club roster grows one column at a time, each added in a hurry by whoever needed it that week. A year in, it usually holds some version of these:

  • Names and contact details. First name, last name, email, phone, maybe an Instagram handle someone asked for once.
  • Roles. Who leads the Tuesday tempo, who runs the social calendar, who is a co-captain, who has keys to the store.
  • Who is coming. A tab per week, or a column per run, with checkmarks or headcounts.
  • Emergency contacts. A name and a number, sometimes a note about allergies or a medical condition.
  • Money and paperwork. Dues paid, the date paid, shirt size for the order, waiver signed yes or no.

Here is a five-minute exercise that makes the rest of this post easy. Color every column by who actually needs it. Green if everyone in the club should be able to see it or benefit from it. Yellow if only run leaders and co-captains need it. Red if only the treasurer or the founder should ever touch it.

Most founders find their sheet is a mess of all three colors on the same row. That is the real problem. A spreadsheet has one sharing setting for the whole file, so you either overshare the red columns or lock everyone out of the green ones. That tension is what pushes the roster into a dozen private copies.

Which columns should move and which should stay in a sheet?

Once the columns are colored, sorting them is mostly mechanical. The green and most of the yellow columns move to wherever the club lives day to day. The red columns stay somewhere locked, and that is a feature of a good move, not a failure of it.

ColumnWhere it goesWho sees it
Who is in the clubThe club's member list in your new homeMembers and leaders
Who holds which roleRoles on that member listMembers and leaders
Who is coming SaturdayAn RSVP on each run's eventMembers and leaders
Announcements and chatterThe club's group chatMembers
Emergency contactsA locked sheet or form, leaders onlyRun leaders
Dues ledgerA locked sheet or the payment tool you already useTreasurer
Signed waiversThe waiver tool or file you already useFounder or treasurer

Move who is in the club. This is the backbone. Everything else in the club is some view of this list: the run is "the members, on Saturday at 7," the announcement is "the members, in the chat."

Move roles. If your run leaders only exist as a note in column F, nobody outside the founder knows who to ask. Roles belong on the member list where people can see them.

Move who is coming. The weekly RSVP tab is the column that rots fastest, because it has to be rebuilt every week. Put an RSVP on each run instead and let members answer it themselves.

Keep money in a locked sheet. A dues ledger is accounting, and accounting wants a narrow audience and a clear history. If you already collect dues through a payment app, the ledger stays wherever your treasurer reconciles it.

Keep waivers and medical detail out of the everyday tool. Signed waivers belong in the tool or folder that stores them. Emergency contacts and medical notes should be visible to the people leading a run and nobody else. A smaller, locked sheet with only those columns is safer than the giant shared file you have now.

The result is not zero spreadsheets. It is one small, private sheet that does one job well, instead of one big shared sheet doing five jobs badly.

How do you get members to switch without losing the quiet ones?

This is where most moves lose people. The loud regulars switch on day one. The quiet members, the ones who run every Thursday but never answer a group text, simply drift, because nobody asked them directly.

A two-week switch window fixes most of that. A rough shape:

  1. Announce the date everywhere at once. Same message in the group chat, on social, and at the end of the next two runs: from this date, the club lives here, and here is why.
  2. Post the next three runs only in the new place. Not in both. If the runs are still in the old thread, there is no reason to move.
  3. Invite people one at a time. A personal ask lands where a blast does not. Split the list among your run leaders so each one asks the people they actually run with.
  4. Make the old chat read-only. Pin one message pointing to the new home, then stop answering questions there.
  5. Archive the old chat and sheet at day fourteen. Not delete. Archive, so the history is there if you need it.

One principle runs through all five steps: do not import people silently. It is tempting to bulk-load every email from the sheet and call the move done. But a person who was added without asking has no reason to open the app, and a person who chose to join is a person who reads the next update. The join is the point. It is the moment someone says yes, I am in this club.

If you are worried about the club losing momentum during the switch, keep the runs themselves completely unchanged. Same day, same time, same meeting spot. Change one thing at a time, and the thing you are changing is where people find the club, not the club itself. If the club is also outgrowing its structure, our guide on when a run club gets too big to manage pairs well with this move.

What should you check after the move?

Day fourteen is not the finish line. It is the audit.

Compare the old list against who joined. Put the old roster next to the new member list and mark every name that has not made it across. That gap is your follow-up list, and it is almost always the quiet members. A short, personal message from the run leader they know works far better than a reminder to everyone.

Check every run leader holds the right role. Before the next run goes out, confirm the people leading runs are marked as leaders in the new home. Otherwise a newcomer who asks "who is in charge Saturday?" gets the same blank stare the spreadsheet gave them.

Retire the old sheet's edit links. Old links keep circulating in text threads and bookmarks. Turn off editing on the old file so nobody keeps updating the wrong copy, and leave one line at the top pointing to where the club lives now.

Let the RSVPs replace the weekly tab. After a few weeks, the RSVP on each run tells you who plans to come without anyone rebuilding a tab by hand every Sunday night. If you want a deeper look at that piece, here is how to think about a running club RSVP system.

If the spreadsheet was only one of several tools you are juggling, this move is a good first step toward consolidating the rest of your club's tools. Start with the roster, because everything else reads from it.

RunLink gives a running club one place for the green and yellow columns: a public club page so new runners can find you, events with RSVP for each run, a member roster with roles (owner, moderator and member), and in-app group chat. Club admins and runners can invite contacts from their phone's address book into the club. Matching is by email address only, the contact list is not stored, and a person makes each ask and hits send, which fits the personal-invite approach above.

It is also worth being plain about what RunLink does not do. It does not import a spreadsheet, collect dues or store waivers, so your treasurer's ledger and your waiver files stay right where they are. That is the split this post recommends anyway: the people move, the paperwork stays locked.

If you want to see what a club home looks like before you commit, you can browse running club pages on RunLink. When you are ready to start your switch window, claim your club on RunLink. The iOS app is live on the App Store and free to download for your members.

Run your club in one app

RunLink gives a running club a public club page, events with a mapped route and RSVPs, a roster with roles, and club chat in one place. The iOS app is free to download.