Chess Club Membership Management Without a Spreadsheet

Every chess club ends up with the same problem. Somebody keeps a member list in a spreadsheet, somebody else keeps subs in a notebook, and the person running Tuesday night retypes the same twenty names into the pairing software every week. Then the spreadsheet owner moves away and the club starts over. This guide covers what chess club membership management actually needs, and how to run the whole thing free in ChessHost's new Members page.

Why the Club Spreadsheet Stops Working

A spreadsheet is a fine place to start and a bad place to stay. Four things go wrong, and they go wrong in every club:

• It lives on one person's laptop. When they are away, nobody can add a member or check who has paid.
• Nothing reminds you about renewals. Expiry dates sit in a column that nobody sorts, so people lapse quietly and are never asked back.
• It is not connected to your tournaments. The names get retyped by hand every club night, with a new spelling of "Katarzyna" each time.
• It goes stale. A list nobody uses during club night is a list nobody updates after club night.

The fix is not a fancier spreadsheet. It is one member list that you actually touch every week, because the same list is what you build your tournaments from.

What the Members Page Does

ChessHost is free chess club manager software, and the Members tab of My Club is your club's register. It opens as a plain list of everyone in the club with a live count, and it holds six things per person:

• Name (the only required field), and legal names are welcome: up to six words with periods and commas, so "Maria del Carmen Rodriguez Gomez" and "J. R. Kavanagh" both save fine.
• Email and phone, for when you need to reach somebody about a rescheduled night.
• Membership expires, the one date that runs everything else. Leave it blank and the membership never lapses.
• Rating, if your club uses one for seeding.
• Notes, a free-text field for the things software never has a column for: "plays Thursdays only", "junior, parent collects at 8", "brings the clocks".

That is deliberately short. The register tracks no dates of birth, no addresses and no payment history, because most clubs never use those and every extra field is personal data you then have to look after. Adding somebody is one path: press Add member, type a name, save. You can fill the rest in later or never.

Membership Status Calculates Itself

Nobody wants to hand-set a status field, and any status you have to update by hand is wrong within a month. So the status is never typed, it is read from the expiry date:

• Active (green): more than 30 days left, or no expiry date at all.
• Expiring soon (amber): inside 30 days, shown as a live countdown like "12d left".
• Expired (red): the date has passed.

At the top of the page sit four tiles: Members, Active, Expiring soon, Expired. They are not decoration, they are the filter. Tap Expiring soon and the list becomes exactly the people to message this month. Tap Expired and you have your win-back list. Members always equals the other three added together, so the numbers never disagree with each other.

Chasing Renewals Without Nagging Everyone

Renewal chasing is the job clubs quietly stop doing, and it is the reason membership numbers drift down. Two features exist purely for it. The first is the Expiring soon filter above. The second is the Recently expired sort, which puts whoever lapsed most recently at the top and pushes everyone still current to the bottom. Somebody who lapsed last week will usually rejoin. Somebody who lapsed two years ago has moved on. Sorting by "who just fell off" tells you where the easy wins are.

The other sorts cover the rest of club life: Newest first, Name A to Z, Expiring first, and Highest rating for when you are seeding a championship.

Search That Explains Itself

Search matches name, email, phone and notes. Since the list shows names rather than contact details, a result whose match was hidden says so, with a small "matches email" or "matches notes" line under the name. You never get a search result that looks like it arrived by accident. In practice this makes the notes field far more useful than it sounds: type "clocks" and you find whoever brings them.

Bulk Actions: Renew Twenty Members in One Tap

Subs usually get collected in a lump: a club night in September where fifteen people pay for the year. Doing that one member at a time is the sort of admin that makes people give up on software, so members are selectable with row checkboxes (or Select all), and then:

• Set expiry to 3, 6, 12 or 24 months from today, or to no expiry, for everyone selected at once.
• Export selected as CSV, for a treasurer's report or a mail merge.
• Remove the selected members, behind a confirm.

Two details matter here. First, every bulk action and every removal is undoable for six seconds from the toast, so a mis-tap on Remove is not a disaster. Second, if some of your selection is hidden by the filter you switched to, the bar warns you with an amber "N not shown" chip and the delete confirm repeats it, so you can never quietly delete people you are not looking at.

On a phone, selecting is a mode you enter on purpose with a Select button, because on mobile a row tap opens that member. That way you are never forced to Select all just to act on three people.

Bring Your Existing Member List With You (CSV)

You are not retyping your club spreadsheet. Export it to CSV and use Import from CSV. The import is built to accept the messy files real clubs have:

• Columns Name, Email, Phone, Expiry date, Rating, Notes in any order, matched by header name, with common aliases accepted (expires, renewal date, elo and so on).
• Comma and semicolon files both work, which covers European spreadsheet exports.
• Columns the app does not track are simply ignored rather than rejecting the file.
• An empty cell leaves that field alone, it never wipes what is already there, so re-importing an updated file is safe.
• Dates must be written as YYYY-MM-DD. Anything else is reported as ignored rather than guessed at, so no locale ever swaps your days and months.
• Rows that would change nothing are reported as "Already up to date", so the counts you see are real writes.

Export CSV takes the whole register back out as club-members.csv with every column, and it round-trips exactly through the importer. Your member list is yours, and it can leave whenever you want it to.

Your Members Are Also Your Player List

This is the part that keeps the register current, and it is the reason it beats a spreadsheet outright. The same members are your saved players. On the Add Players screen, a Your Members panel lists everyone not yet in this tournament, with tap-to-add, a search box and an Add all button. Setting up your weekly club night becomes: create the event, tap Add all, start.

It works in the other direction too:

• A new face turns up and plays as a guest? Tap Save to Members on their row during or after the event and they are on the register.
• Players who signed up themselves through your invite link or QR code arrive with the email they registered with, so saving them fills that in for you.
• Followers of your free club page can be added to Members individually or all at once.
• Fix a spelling once and it follows that person everywhere: a name or email edit updates their copy in every active tournament, so the same player is never two slightly different people.

Membership details stay put, though. Rating, expiry date and notes live on the Members page only and never leak into a tournament, which is exactly what you want when the TV display is showing the standings to the room.

Your Member List Is Private, Permanently

Worth being blunt about, because clubs handle other people's contact details. The register is visible only to you, the signed-in organizer. It is never shown on your public club page, never in the club directory, and never in any public link or API. Emails, phone numbers, notes and membership dates are yours alone. The public side of ChessHost shows your club, your upcoming events and your results, and nothing about who is on your list.

Members also do not need accounts. They are records you keep, not users who log in, so nobody has to sign up, install anything or remember a password. That is one less reason for a casual player to say no.

Members Page vs the Club Spreadsheet

To be fair to the spreadsheet: if your club tracks things ChessHost deliberately does not, like detailed subs accounting or a committee's meeting minutes, keep it for that. Plenty of clubs keep the register in ChessHost, where it is used weekly, and a separate sheet for the treasurer's numbers.

Setting Yours Up in Five Minutes

1. Create a free account and open My Club, then the Members tab.
2. Import your CSV, or press Add member and type in your regulars. Names only is a perfectly good start.
3. Add expiry dates if your club charges subs. Select everyone who paid in September and Set expiry to 12 months. Skip this entirely if your club is free to attend.
4. Run your next club night from the list. Create the tournament, open Add Players, tap Add all.
5. Once a month, tap the Expiring soon tile and message the handful of people on it.

The One-Minute Recap

• Chess club membership management needs one list, in one place, that you use every week.
• The ChessHost Members page is free: name, email, phone, expiry, rating, notes, nothing you do not need.
• Status is automatic from the expiry date: Active, Expiring soon with a countdown, Expired.
• The four summary tiles are the filter, and Recently expired is the renewal chase list.
• Bulk Set expiry, export and remove, with undo on everything.
• CSV import and export means you bring your spreadsheet in and can take your data back out.
• Members double as your saved players, so the list stays current by being used.
• The register is private to you, and members never need accounts.