Sports betting Excel template (free)
A simple sheet for recording your bets, with the profit, yield and win rate formulas already done. Download it, fill in the columns and you are set.
Download the template
Download the betting template (.xlsx)
It is free and needs no signup. It works in Excel and should also open in LibreOffice and Google Sheets, although some formatting details may vary there.
What it includes
“Bets” sheet, one row per bet:
| Column | What to enter |
|---|---|
| Date | Date of the bet |
| Event | Match or event |
| Market | 1X2, handicap, over/under… |
| Bookmaker | The bookmaker |
| Tipster | If you follow someone; otherwise leave it empty |
| Odds | Decimal odds |
| Stake | Amount staked |
| Result | Won, Lost, Void or Cashout (dropdown list) |
| Cash-out collected | Only if you closed the bet: what you collected |
| Profit | Calculated automatically |
“Summary” sheet, which updates itself: number of bets, total staked, profit, yield, win rate and average odds.
The formulas it uses
Profit on each row, depending on the result:
- Won: stake × (odds − 1)
- Lost: −stake
- Void: 0
- Cashout: collected − stake
And in the summary:
- Yield = total profit ÷ total staked, excluding voids
- Win rate = won ÷ settled bets, excluding voids
It is the same approach as the yield calculator. To understand why voids stay out, read what yield is.
How to use it
- Delete the example row. The data is made up, just to show you the format.
- Fill in one row per bet when you place it. If you leave it for later, you will end up forgetting the bad ones.
- Fill in the result when the event ends. Until then, the row does not count towards the summary.
- Check the summary once a month, not after each bet. With few bets, the figures swing a lot.
How to get more out of it
- Break it down with a pivot table. Select the data and create a pivot table by bookmaker, tipster or market.
- Add a closing odds column. It lets you measure your CLV, one of the best signs of whether you are betting with an edge.
- Add your stake as a percentage of the bank. It will help you follow your bankroll management method.
When a spreadsheet falls short
A template works very well while you have few bets and are consistent. Its limits appear as you grow:
- You have to type everything by hand, and any forgotten bet distorts the result.
- If you bet with several bookmakers, you have to visit each one to copy the data over.
- Breakdowns and charts have to be built and maintained by you.
- Formula errors give no warning: one badly copied row can spoil the summary without you noticing.
BetTracker Pro does the same as this template automatically: you paste your bookmaker’s history and get profit, yield and win rate, by bookmaker, sport and tipster, without typing bets by hand. If you prefer the spreadsheet, go ahead: what matters is measuring, with whatever tool.
Recording your bets will not make you money, but it will give you an honest picture of what is happening, and that is a good reason to do it.
Frequently asked questions
Does the template work in Google Sheets?
The formulas are standard, so they should work when you upload it to Google Drive and open it with Sheets. Some formatting details may vary.
What do I do with parlays?
Record them as a single row, with the parlay’s total odds. The parlay calculator gives you them if you do not have them.
How many bets can it hold?
The formulas are set up for 1,000 bets. If you need more, copy the last row down and extend the summary ranges.