Running a golf league without a spreadsheet
The spreadsheet is not free — it is paid for in one volunteer’s evenings. Here is the honest accounting, and the migration path if you decide to stop.
Updated 6 August 2026 · 5 min read · Flagstick team
Every golf league starts with a spreadsheet, and the spreadsheet is genuinely good. It is free, it does exactly what you want, and nobody has to be persuaded to adopt it. Most leagues should start there.
The problem is not that spreadsheets are bad. It is that they concentrate the entire operation into one person’s file on one person’s laptop, and that person eventually gets tired.
The honest accounting
Here is what one round actually costs, in a well-run spreadsheet league.
| Task | Time | Who |
|---|---|---|
| Build the draw and groups | 20–40 min | Organiser, the night before |
| Print or message the draw | 10 min | Organiser |
| Collect cards or totals after play | 20–60 min across two days | Organiser, by chasing |
| Enter and check totals | 20–30 min | Organiser |
| Recompute the season table | 15–30 min | Organiser |
| Publish results | 10 min | Organiser |
| Answer “why am I not on the list” | Unbounded | Organiser |
That is roughly two hours per round, all of it after the golf, all of it on one person. Across a 25-round season it is 50 hours. If your league lasts five years on one organiser, that person has given you a working month.
The thing that finally breaks it is rarely the time. It is the chasing. Scores arriving by chase means results appear on Tuesday, which means nobody looks at the standings on Saturday, which means the season table stops being interesting.
What software actually replaces
Be precise about this, because “software fixes it” is a claim that deserves scrutiny.
It replaces the chasing. Scores arrive during the round because players enter them as they play. There is no collection step and no Sunday-night reminder message.
It replaces the recomputation. The season table is derived from completed rounds rather than maintained. Correcting a score three weeks late fixes the standings automatically instead of requiring you to rebuild them.
It replaces the publication step. The board is live; there is nothing to publish.
It does not replace judgement. Who plays with whom, what the tie-break rule is, whether a guest counts, what to do when a group didn’t finish — these are still decisions, and they should be. Software that makes them for you is worse, not better.
It does not replace the setup work. Loading pars and stroke indexes for your courses is a real job. It is a one-off job, but be ready for it.
The formulas people get wrong in spreadsheets
If you stay on a spreadsheet — a perfectly reasonable choice — these are the three things to check, because they are wrong in a lot of league workbooks.
Playing handicap is recomputed, not stored
If your sheet computes points from the member’s current handicap, then updating someone’s handicap in January silently rewrites October’s results. Store the playing handicap the round was played off as a value in the row. See snapshot the handicap.
Season points accumulate over every round
=SUM(...) across the row is the most natural formula in the world and it makes attendance a scoring term. A member who plays nine ordinary rounds beats one who plays four excellent ones, permanently. If your league has irregular attendance — and every league does — count each member’s best N rounds instead. =SUMPRODUCT(LARGE(range, {1;2;3;4;5})) is the fix.
Rounds of different lengths are added together
A 10-hole round and an 18-hole round produce different point totals for the same standard of golf. Adding them raw means the 18-hole round counts roughly twice. If your league mixes lengths, scale to an 18-hole equivalent before comparing. We wrote about this at length in comparing Stableford scores across 9, 10 and 18 holes.
When to move, and when not to
Stay on the spreadsheet if: the organiser enjoys it, the league is under about 20 players, you play a handful of times a year, and nobody is complaining about how long results take.
Move if: any of these are true.
- Results routinely appear more than 24 hours after the round.
- The same person has run the sheet for three years and there is no successor.
- You have had a dispute about the season table that took more than an email to resolve.
- Members ask “who’s winning?” during the round and nobody can answer.
- You have started keeping a second sheet to track the first sheet.
That last one is the reliable signal.
The migration, in order
- Freeze the spreadsheet at a season boundary. Do not migrate mid-season unless the new system imports prior results.
- Clean the member list. Full names, emails, handicap indexes. Duplicates and nicknames are the main cause of a bad first week.
- Gather course data. Pars and stroke indexes for every course you play, from the actual scorecard, not from memory.
- Decide the two rules explicitly: the tie-break and how many rounds count toward the season. Write them down; you are about to encode them.
- Run round one live, with the sheet as backup. Keep the sheet for three rounds and then stop.
- Publish the season rules to members before round one. Every complaint you will get in month three is really a complaint about a rule nobody announced.
Frequently asked questions
- Is a spreadsheet good enough to run a golf league?
- For a small, stable league with a willing organiser, yes. Spreadsheets are accurate and flexible, and the maths involved is not hard. The failure mode is organisational, not technical: everything depends on one volunteer, scores arrive by chasing, and results are too slow to keep the season interesting during the round.
- How do I calculate an Order of Merit in Excel?
- Assign points by finishing position from a fixed schedule, one row per member per round. To cap the season at a member’s best five rounds, use SUMPRODUCT with LARGE over their round points rather than SUM. Store the playing handicap used for each round as a value in the row so later handicap changes do not rewrite past results.
- What is the biggest mistake in golf league spreadsheets?
- Summing every round into the season total. It makes attendance itself a scoring term, so a member who plays twice as often wins even if they score worse every time. Counting each member’s best N rounds fixes it, and it means an extra round can only replace a worse one, never simply add.
- Can we move a season of spreadsheet history into software?
- Usually yes, as a CSV of members, rounds, and points or finishing positions per round. Hole-by-hole detail rarely transfers. Ask any vendor whether they will import a prior season for you — it is the difference between starting with a live standings table and starting from zero in March.