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 My Players 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.
• Nobody can tell who has paid. The subs column is half filled in, so people drift away 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 My Players Page Does

ChessHost is free chess club manager software, and its My Players page is your club's register. It opens as a plain list of everyone in the club with a live count, and it holds five 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.
• Rating, if your club uses one for seeding.
• Notes, a free-text field for the things software never has a column for: "Paid 2026-27", "plays Thursdays only", "junior, parent collects at 8", "brings the clocks".

That is deliberately short. The register tracks no dates of birth, no addresses, no expiry dates 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.

Keeping Track of Who Has Paid

ChessHost does not track expiry dates or calculate a membership status, and it never sends reminders. For most clubs that is fine, because subs are collected once a season and the only question is "who has paid this year?". A note answers it:

• Pick one label per season, like Paid 2026-27, and type it into each paying member's notes as the money comes in.
• To see who has paid, search Paid 2026-27. Search reads the notes field, so the list narrows to exactly those members.
• To see who has not, clear the search and look for the names that were missing. On a club of 30 that takes a minute.

The list sorts three ways: Newest first, Name A to Z, and Highest rating for when you are seeding a championship. If your club needs dated renewals, reminders or payment records, keep a treasurer's spreadsheet for that and let ChessHost hold the register you use on club night.

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, type "Paid 2026-27" and you have this season's paid-up members.

Bulk Actions: Export or Remove Many Members at Once

Doing admin one member at a time is the sort of thing that makes people give up on software, so members are selectable with row checkboxes (or Select all), and then:

• 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 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 search you typed, 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, Rating, Notes in any order, matched by header name, with common aliases accepted (e-mail, mobile, 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.
• 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 my-players.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 them all on the Add Players screen, or add them on the My Players page after the event, and they are on the register for good.
• Players who signed up themselves through your invite link or QR code arrive with the email they registered with, so you have their contact details to hand when you add them.
• 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. Phone, rating and notes live on the My Players 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 in any public link or API. Emails, phone numbers, ratings and notes are yours alone. The public side of ChessHost shows an event's players and 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.

My Players vs the Club Spreadsheet

To be fair to the spreadsheet: if your club tracks things ChessHost deliberately does not, like renewal dates, 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 Players from the menu.
2. Import your CSV, or press Add member and type in your regulars. Names only is a perfectly good start.
3. Note who has paid if your club charges subs, with one label like Paid 2026-27. 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. At the start of each season, search last season's label to see who to ask about subs.

The One-Minute Recap

• Chess club membership management needs one list, in one place, that you use every week.
• The ChessHost My Players page is free: name, email, phone, rating, notes, nothing you do not need.
• Search reads notes too, so a label like Paid 2026-27 tells you who has paid.
• Bulk export and remove, with undo on removals.
• 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.