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.

Running this every week? GolfCommish sends the emails, syncs GHIN, and builds the groups for you. Try it free for 30 days or explore the live demo.

What'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.

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.

The same formula in Excel

With the handicap index in B2, slope in C2, course rating in D2, and par in E2:

Fill it down the column and you've converted the whole roster. Enter a plus handicap (+1.2) as a negative number (-1.2). The formula works unchanged in Google Sheets and LibreOffice.

Calculating a handicap index from scores in Excel

The formula above converts an index a golfer already has. If your league keeps its own handicaps from posted scores instead, it's two steps. First, a score differential for each round — adjusted gross score in A2, course rating in B2, slope in C2:

Then the index: with a player's 20 most recent differentials in F2:F21, average the best 8:

Smaller league, fewer rounds? Best 4 of the last 8 works the same way: =ROUND(SUMPRODUCT(SMALL(F2:F9,{1,2,3,4}))/4,1).

This is the simplified version of the World Handicap System math. The official calculation also caps each hole at net double bogey, adjusts for players with fewer than 20 scores and for the day's playing conditions, and limits how fast an index can climb. For a casual league it's close enough; if your members have GHIN numbers, use their official index instead.

Running your week with it

1. Set up Roster and Courses & Tees once.
2. Early each week, fill the Availability column as replies come in.
3. Once the field is set, build groups on the Pairings tab — aim for close group averages (see our guide to balanced foursomes).
4. Email everyone the details — steal our email templates.
5. 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