GUIDES
Free Golf League Handicap Spreadsheet Template
Most weekly golf groups run on a spreadsheet — and most of those spreadsheets were built at 11pm the night before the first round, with handicap math that nobody has trusted since. This one is built properly, and it's free: roster, course handicap calculator, weekly availability grid, pairings sheet, and a results log with a season money race, formulas included.
Download the template
Excel (.xlsx) · works in Google Sheets and LibreOffice too · sample data included · no email address required.
Download the free templateWhat's inside
Six working tabs (plus a Read Me), pre-loaded with sample data so you can see how everything connects before you clear it and enter your own group. Blue cells are yours to type in; black cells calculate themselves.
1 · Roster
One row per member — name, contact info, GHIN number, handicap index, and an Active flag. Supports up to 40 members, and every other tab pulls names from here so you only ever type them once.
2 · Courses & Tees
One row per course/tee combination with its course rating, slope rating, and par, straight off the scorecard. Enter each course once; the handicap math everywhere else references this table.
3 · Course Handicap Calculator
Pick a member and a tee from dropdowns and get their playing course handicap instantly — plus a whole-roster table that converts everyone at once for the tee you're playing this week.
4 · Weekly Availability
Members down the side, play dates across the top, an Available / Out / Maybe dropdown in every cell. Your at-a-glance answer to "how many do we have Saturday?"
5 · Pairings
Four tee-time groups of four. Pick the date and tee, choose players from dropdowns, and each player's course handicap — and each group's average, for checking balance — fills in automatically.
6 · Results Log
One row per playing day: game, place finishes, payouts. A Season Wins table tallies each member's wins and total money automatically — your season race, maintained for free.
The course handicap formula, explained
The template's math follows the World Handicap System conversion:
Why not just use the index? Because a 15.1 index isn't 15 strokes everywhere. Slope measures how much harder a course plays for a bogey golfer than a scratch golfer (113 is the neutral baseline), and the rating-minus-par term corrects for courses that play easier or harder than their par suggests. On a slope-126 track, that 15.1 becomes a 17; on a friendly slope-105 muni it's a 13. Getting this right is most of what makes your weekly game feel fair.
Running your week with it
- Set up Roster and Courses & Tees once.
- Early each week, fill the Availability column as replies come in.
- Once the field is set, build groups on the Pairings tab — aim for close group averages (see our guide to balanced foursomes).
- Email everyone the details — steal our email templates.
- After the round, add a row to the Results Log. The season race updates itself.
New to running a group? Start with the full playbook: how to organize a weekly golf group.
Where the spreadsheet stops helping
The template handles the math. What it can't do is the chasing — and chasing is where a commissioner's hours actually go:
- It can't email your roster or collect the In/Out replies — you're still copy-pasting addresses and transcribing texts into the grid.
- It can't update GHIN indexes — somebody re-types 16 numbers every revision, or the handicaps quietly go stale.
- It can't build the groupings, remember who rode with whom, or email the pro shop a tee sheet.
- And only one person can really own it — when the commissioner is on vacation, the group is too.
That gap is exactly what GolfCommish is: the same roster → availability → pairings → results loop, but the emails send themselves, members answer with one tap, GHIN indexes sync automatically, and the groupings build with drag and drop. The spreadsheet is a great way to start; the app is what it grows into.
Frequently asked questions
How do you calculate a course handicap in a spreadsheet?
Course Handicap = Handicap Index × (Slope ÷ 113) + (Course Rating − Par), rounded to the nearest whole number. The template's calculator tab applies this automatically once you've entered each course's rating, slope, and par.
Is the template really free?
Yes — direct download, no email address required. It works in Excel, Google Sheets (upload it to Drive), and LibreOffice, and you're welcome to share it with your group.
How often should handicaps be updated?
With official GHIN indexes, sync the roster at least weekly (the WHS revises daily). With self-maintained league handicaps, recalculate after each round from a rolling window like the best 4 of the last 8 scores.
KEEP READING
Or skip the spreadsheet
GolfCommish replaces every tab in this template — and does the emailing, syncing, and chasing for you. Every plan starts with a free 30-day trial. No credit card.