Free golf trip scoring spreadsheet

What the template does

This is an individual net Stableford competition: add each golfer’s round totals and the highest total wins. It is a useful starting point if your group wants the same straightforward scoring system every day.

• Space for 12 players, with unused rows left without scores.
• A choice of one, two or three rounds.
• Automatic running totals and a count of completed rounds.
• A final rank only once a player has the selected number of round totals.
• Shared ranks for tied scores, plus a fictional example you can inspect.
• A scoring sheet laid out to print on one landscape page.

The sheet does not convert strokes into Stableford, calculate Course Handicaps, resolve ties by countback, or run a separate pairs or team match-play competition. It does not import into or synchronise with TourBoard.

How to use it

1. Download and save your own copy. Give it the trip’s name so the original stays available if you need to start again.
2. Open the Scores sheet. Set “Rounds to play” in cell B3 to 1, 2 or 3. Replace the Player labels with names. Leave unused rows without scores.
3. Enter completed round totals. Fill the blue Round 1 column after the first round, then Round 2 and Round 3 as needed. Enter points as numbers, not text.
4. Keep unplayed rounds blank. A zero means someone played and scored zero points. It counts towards the completed-round total.
5. Check every participant before declaring a winner. Final rank includes only golfers with exactly the selected round count. A player still waiting to enter their last card will not be ranked yet.

Edit the blue cells only. The other columns contain formulas; the hidden H column keeps incomplete totals out of the final ranking. Keep whole rows together if you rearrange players. If a formula is overwritten, take a fresh copy of the download.

Using Google Sheets

In a blank spreadsheet, choose File → Import → Upload and select the downloaded .xlsx file. Import the workbook, then check its Scores and Example tabs. Change one example score to confirm the totals and ranks update before entering your trip’s cards. The workbook uses standard COUNT, SUM, IF and RANK formulas.

Keep the workbook format when saving from Excel. Exporting as CSV loses the extra sheets and formatting. If you share it with the group, give editing access only to the people collecting scores.

A worked example

With three rounds selected, the Example sheet contains the following fictional results:

Blair and Casey share first place. Alex is third, not second: this is competition ranking, with a place skipped after a tie. Drew’s partial score does not push Ellis down the final ranking. Ellis has genuinely completed all three rounds and therefore receives a rank.

Where do the Stableford totals come from?

Agree the tees and competition allowance before playing, then calculate each golfer’s net points using their correct handicap strokes on each hole. The workbook takes the resulting round total. It does not decide anyone’s handicap or verify a scorecard.

For a refresher, the R&A explains Stableford in Rule 21. Use your course or national association’s guidance for the handicap allowance appropriate to your competition.

What if it rains, or we finish level?

Agree those decisions before the first tee. A sensible social-trip tie rule is a shared win; the template already displays shared ranks. If you choose a playoff or countback, record the agreed outcome separately.

If the group cancels a round, leave its entire column blank and reduce B3 so everyone is compared over the same number of rounds. If only some people miss a round, do not fill their cells with zero just to produce a rank: that records a result they did not play.

When to use a live leaderboard instead

Choose the spreadsheet when one person is happy to collect individual round totals and update the group afterwards. Choose TourBoard’s free golf trip leaderboard when you want two teams, different formats, standings as scores are entered, a fines ledger and a final trip report.

For a complete team competition, read the eight-person, three-round trip guide. Its whole-team match points are a different competition from this workbook’s individual totals; pick one structure before you start.