Golf Handicap Tracker (Free Excel Spreadsheet)
A free Excel spreadsheet that keeps your last 20 rounds, works out the Score Differential for each one, and gives you a Handicap Index using the World Handicap System method. It also has a Stableford scorecard that turns that handicap into points, hole by hole. No sign-up, no email, nothing to install beyond a spreadsheet program you already have.
It opens in Microsoft Excel, Google Sheets, LibreOffice Calc, Numbers, and the Excel app on a phone. Every figure is a live formula, so it keeps working as you type your own rounds in.
What Is Inside
- Read me — a short page telling you which cells are yours to fill in.
- My Rounds — 20 rows for your most recent rounds. You enter the date, course, tees, Course Rating, Slope Rating, par, Adjusted Gross Score and PCC. The Score Differential works itself out.
- Handicap Index — your Index, with every step shown: how many rounds you have, how many differentials the WHS uses, the adjustment, and the differentials sorted lowest first.
- WHS Table — the table that decides how many differentials count. It is a plain table you can read and, if your association differs, edit.
- Course Handicap — turns your Index into a Course Handicap and then a Playing Handicap for whatever allowance the competition uses.
- Stableford — an 18-hole scorecard. Enter par, Stroke Index and your gross score for each hole and it works out the strokes you receive, your net score and your points.
It arrives with 20 example rounds in place so you can see it working straight away. Delete them and type your own.
How the Handicap Index Is Worked Out
Step 1 — a Score Differential for every round
Score Differential = (113 ÷ Slope Rating) × (Adjusted Gross Score − Course Rating − PCC)
Take the first example round: a Course Rating of 71.9, a Slope Rating of 125, and an Adjusted Gross Score of 91.
(113 ÷ 125) × (91 − 71.9) = 0.904 × 19.1 = 17.2664, rounded to one decimal = 17.3
The 113 is not arbitrary. It is the Slope Rating of a course of average difficulty, so dividing by your course’s Slope puts every round on the same footing however hard the course was.
Step 2 — average the best of them
With a full 20 rounds, the Index is the average of the lowest 8 differentials, rounded to one decimal. Not all twenty, and not your best ever — the best eight of the last twenty. That is why the Index measures what you are capable of rather than what you usually shoot.
In the example data the lowest eight are 10.9, 11.8, 12.7, 13.7, 13.7, 13.7, 14.6 and 15.4. They average 13.31, so the Handicap Index is 13.3.
What Happens With Fewer Than 20 Rounds
This is the part most free spreadsheets get wrong. They average the best eight whatever you have entered, or divide by twenty regardless. The World Handicap System uses a different count below twenty rounds, and at three, four and six rounds it applies an adjustment as well:
| Rounds entered | Differentials used | Adjustment |
|---|---|---|
| 3 | lowest 1 | −2.0 |
| 4 | lowest 1 | −1.0 |
| 5 | lowest 1 | 0 |
| 6 | lowest 2 | −1.0 |
| 7 – 8 | lowest 2 | 0 |
| 9 – 11 | lowest 3 | 0 |
| 12 – 14 | lowest 4 | 0 |
| 15 – 16 | lowest 5 | 0 |
| 17 – 18 | lowest 6 | 0 |
| 19 | lowest 7 | 0 |
| 20 | lowest 8 | 0 |
The spreadsheet reads this table, so it is right at every stage from your third round onwards. Below three rounds it says so rather than showing a number that would mean nothing.
Adjusted Gross Score, Not Your Raw Score
The score that goes into the calculation is your Adjusted Gross Score. On any hole where you scored worse than net double bogey, you write down net double bogey instead.
Net double bogey is par, plus two, plus any handicap strokes you receive on that hole. On a par 4 where you get one stroke, that is 4 + 2 + 1 = 7. So a 9 on that hole is entered as a 7.
This is what stops one disastrous hole from moving your handicap, and it is also why picking up in a Stableford does not hurt your record — a hole you picked up on is recorded as net double bogey anyway.
Turning the Index Into Strokes
A Handicap Index is portable; it is not the number of strokes you get. The Course Handicap sheet converts it:
Course Handicap = (Handicap Index × Slope Rating ÷ 113) + (Course Rating − Par)
Then the competition’s allowance is applied to give a Playing Handicap — 95% for an individual Stableford, 85% for Four-Ball stroke play, 50% for Foursomes, and so on. The sheet takes the allowance off the exact, unrounded Course Handicap and rounds once at the end, which is the order the WHS specifies. Taking a percentage of the rounded figure printed on your card can leave you a stroke out.
The Stableford Scorecard
The last sheet is a full Stableford calculator. Enter the par, the Stroke Index and your gross score for each of the 18 holes, and it works out the strokes you receive on that hole, your net score, and your points. It takes the Playing Handicap from the Course Handicap sheet, so set the allowance there — 95% is the usual figure for an individual Stableford.
Where the strokes land
Strokes follow the Stroke Index printed on the card, not the par. A par 3 with Stroke Index 2 receives a stroke before a par 5 with Stroke Index 14.
Above 18, they go round the card a second time. A Playing Handicap of 21 gives one stroke on every hole and a second on Stroke Index 1, 2 and 3. At 26 the first eight holes take two. The sheet does this for you, and the strokes it hands out always add up to exactly your Playing Handicap — which is the check worth making on any scorecard you fill in by hand.
The points
Net score against par: net bogey scores 1, net par 2, net birdie 3, net eagle 4, and anything worse than a net bogey scores nothing. 36 points is the benchmark, because that is net par on every hole. Above 36 means you played better than your handicap that day.
Once a hole can no longer score, pick the ball up and walk on — the extra strokes change nothing on the card, and for handicap purposes that hole counts as a net double bogey anyway.
Prefer to do it in the browser? The Stableford handicap calculator does the same thing without a download, and the gross Stableford calculator scores your raw figures straight against par.
Frequently Asked Questions
Is this an official Handicap Index?
No. Only your club or an authorised golf association can issue an official Handicap Index. This spreadsheet does the same arithmetic, so you can follow your own progress between official revisions and see exactly how the number is arrived at. Use it to understand and to track; use your club’s record when it counts.
Do I need Microsoft Excel?
No. It is a standard .xlsx file and opens in Google Sheets, LibreOffice Calc and Apple Numbers, all of which are free. To use it in Google Sheets, upload it to Google Drive and open it there.
Where do I find the Course Rating and Slope Rating?
On the scorecard, usually near the tee tables, and on most clubs’ websites. Both are specific to the tees you played, so a round from the whites and a round from the yellows use different figures. Enter the ones for the tees you actually played.
What do I put for PCC?
Zero, on almost every round. The Playing Conditions Calculation is an adjustment your club applies when weather or course setup made scoring unusually hard or easy that day. If nobody has told you a PCC applied, it was 0.
What do I do after 20 rounds?
Delete the oldest round and add the new one at the bottom. The Index is always built from your most recent 20 rounds, so the sheet holds exactly twenty. If you want to keep older rounds, copy them onto a new sheet before deleting.
Can I share it or change it?
Yes to both. Send it to your playing partners, put it on your club’s noticeboard, edit the formulas if you want to. Nothing in it is locked.
I would rather not download anything
Then use the calculators on this site instead. The Handicap Index calculator does the same job in your browser, and the Course Handicap calculator converts an Index into strokes. The spreadsheet exists for people who want to keep a record over a season.