Can you run a golf league with Excel or Google Sheets? Of course. One league ran on a workbook for years before Golf Mafia existed, and the app is that workbook's shape moved onto twelve phones. This guide is what the sheet needs if you build one, and the exact places it breaks, so you know when to stop.
What the workbook needs
A league spreadsheet is four tabs pretending to be one.
| Tab | What it holds | The formula that does the work |
|---|---|---|
| Roster & handicaps | Every player, their team, their number, their current handicap, and the history of changes with dates. | None, which is the problem: the history is typed by hand, and it is the sheet nobody updates. |
| Rounds (one block or sheet per round) | Who played, gross by hole, the handicap used, net total, each team's Best-4, each team's skins by hole, the money. | =SUM(SMALL(nets,{1,2,3,4})) for the Best-4; per hole, MIN of each team's gross and an IF that awards a skin only when one is strictly lower. |
| Standings | Average net over full rounds, rounds played, skins, birdies, money to date, and the hardest holes. | AVERAGEIF over the round sheets, which breaks the day someone inserts a column. |
| Schedule & RSVP | The dates, tee times, who said yes, the groups. | None. It lives in the text thread anyway. |
If you build it, build it well: lock the formula cells, keep one row per player per round, and never type a net by hand. The Best-4 formula wants the four lowest nets among players with a full round only, so a player who stopped at the turn needs a blank, not a zero.
Where it breaks
Not on day one. The sheet works beautifully for the first month. It breaks in these six places, in roughly this order.
- Tuesday night. Somebody types twelve scorecards, 216 numbers, into the sheet after dinner, every league day. That person is the commissioner, and that is the hour that ends commissioners.
- The parking lot. The bets are settled before the sheet is updated, from memory and a paper card. When the sheet disagrees two days later, the money has already changed hands.
- The missing card. One group's card goes home in a bag. The round is half a round until Thursday.
- The handicap argument. "I was a 12 that day, not a 10." Nobody wrote down which handicap each round used, so nobody can prove it.
- The one keeper. Only the commissioner can open the book. Everyone else asks, or waits for the Wednesday email. If the commissioner is away, the league is dark.
- The second season. Last year's workbook is a file on a laptop. Records across seasons, head-to-head over the years, the longest winning run: nobody keeps them, because the sheet never did.
The test
If your league's standings live somewhere only one person can open, you have a spreadsheet problem, however good the spreadsheet is.
What replaces each tab
Golf Mafia keeps the same four tabs, on every member's phone, and fills the two that the sheet never could.
- Roster & handicaps becomes the League tab: every player, their team and number, their handicap, and a history of every change with its date. A player can change their own handicap; the commissioner can change anyone's. The lineup shows "WAS 12" when a round's handicap differs from the last one played.
- Rounds become the Play tab: scores go in hole by hole from whichever phone in the group is nearest, as you play. Each team's Best-4 and the skins update live, provisional in amber until every score is in. When the commissioner closes the round, the result is frozen: who won, by how much, who pays whom. No typing that night, and the parking lot and the book agree because they are the same thing.
- Standings become the Season tab: average net over full rounds with the gap to the player above you, rounds, skins, birdies, the hardest holes and the money round by round, plus personal bests, league records across every season and head-to-head against any player. Every past season stays open to everyone.
- Schedule & RSVP become the round itself: "are you in?" goes to every phone, players answer in the app, subs take the open spots, and a reminder goes out two hours before the tee time.

Moving a league off the spreadsheet
You do not import the old workbook; you start the new season clean and keep the old file for the record. Create the league with the same teams and numbers, enter each player's current handicap, and schedule the first round. The first thirty days are free from that first scheduled round, so the league has a month to decide before the commissioner keeps the book. The old sheet retires with its last season intact, which is where it belongs.