A spreadsheet is where most people start tracking their bets, and for good reason: it is free, it runs on any computer, and it does exactly what you tell it to. The catch is the blank page. Which columns do you need? How do you calculate ROI? What do you do with a cash-out or a five-leg parlay?
This guide answers all of that and gives you a ready-made sports betting spreadsheet to start from: a free bet tracker template for Excel and Google Sheets with the formulas already in place. Below, you will find what each column means, how the summary is calculated, how to handle the awkward cases, and an honest look at where a spreadsheet stops being the easiest tool.
In this guide
Download the free betting spreadsheet template
The template is a single .xlsx file. Bets is where you log each bet, one per row. Summary holds your starting bankroll, the only cell you need to edit there, and every total worked out from your bets, with the net result highlighted. Charts draws your balance after each bet, your net result over the last 12 months and by sport, and how your bets split between won, lost, void and cashed out. Each chart reads its own table on a sheet of its own (Months, Sports, Statuses, Balance), filled in from your bets, sports included.
Free bet tracker spreadsheet (.xlsx)
Formulas and charts built in. Works in Excel, Google Sheets, Numbers and LibreOffice. No sign-up, no macros.
A few things to know before you start:
- Google Sheets: upload the file to Google Drive, then open it with Google Sheets (or use File › Import in a blank sheet). The formulas and the status dropdown carry over.
- Example rows: the first six rows show the expected format, with wins, losses, a parlay, a cash-out and a pending bet. Delete them once you have read them.
- Currency: amounts are formatted in dollars. If you bet in another currency, select the money columns and change the number format; the formulas do not care.
- Size: the formulas cover the first 999 bets. Beyond that, copy the last row down and extend the ranges in the summary.
What each column means
The Bets sheet has fourteen columns. You type the first twelve; the last two are calculated. Every bet goes on its own row, in the order you place them.
| Column | What to enter | Example |
|---|---|---|
| Date | The day you placed the bet | 2026-10-04 |
| Bookmaker | Where you placed it | Bookmaker A |
| Sport | The sport | Football |
| Event | The match or competition | Arsenal v Chelsea |
| Selection | What you backed | Arsenal |
| Market | The type of market | Match result |
| Bet type | Single, parlay or system | Single |
| Legs | Number of selections (1 for a single) | 1 |
| Odds | Decimal odds of the whole bet | 1.85 |
| Stake | The amount you put on it | $10.00 |
| Status | Won, Lost, Void, Cash out or Pending (dropdown) | Won |
| Return | What you got back, stake included | $18.50 |
| Profit | Calculated: return minus stake | $8.50 |
| Running balance | Calculated: bankroll plus all profits so far | $208.50 |
Two columns trip people up. Odds are decimal, because that is the format the sums work with; if your bookmaker shows fractional or American odds, our guide to implied probability shows how to convert them. Return includes the stake: a $10 bet at 1.85 that wins returns $18.50, not $8.50. For a lost bet, enter 0 or leave it empty; the sheet counts the full stake as lost either way.
Not sure which fields matter most? Our guide on how to track your sports bets explains why each one earns its place.
The formulas behind the summary
You never have to type a formula, but knowing what they do lets you trust the numbers, or adapt them. Pending bets are left out of every total until you settle them, and so are void bets, since their stake came back.
Profit and running balance
Each row works out its own profit, and the running balance adds it to everything before it.
Profit = Return − Stake (left blank while the bet is pending)
Running balance = Starting bankroll + sum of profits up to this row
Total staked and net result
The summary adds up the stakes and returns of settled bets, with SUMIFS skipping the pending and void ones. The difference is your net result, the number that says whether you are up or down.
Net result = Total returns − Total staked
ROI, win rate and average odds
ROI = Net result ÷ Total staked
Win rate = Bets won ÷ (Bets won + Bets lost)
Win rate only counts bets that were clearly won or lost, so cash-outs and void bets do not distort it. Average odds are the plain average of the odds of your settled bets. Every division is wrapped in IFERROR, so an empty sheet shows blanks instead of error messages.
Parlays, cash-outs, void bets and other special cases
Parlays (accumulators)
A parlay is one bet, so it takes one row: the combined odds, your stake, and the number of legs in the Legs column. Describe the selections briefly in the Selection column. Splitting a parlay over one row per leg would count your stake several times and wreck every total. Keeping the number of legs lets you compare singles with 2-, 3- and 4-leg parlays later, which our article on parlays and singles shows is well worth doing.
Cash-outs
Choose Cash out as the status and enter the amount the bookmaker paid as the return. The bet counts in your total staked and net result like any other, but not in your win rate.
Void bets
When a bet is voided, a postponed match or a non-runner, the stake comes back. Set the status to Void and the return to the stake: profit is zero, and the summary leaves the bet out of its totals.
Free bets
A free bet costs you nothing, so enter a stake of 0 and what the bookmaker credited as the return. That way, your total staked only counts your own money.
Several bookmakers, one currency
Log every bookmaker in the same sheet and use the Bookmaker column to filter. Keep one currency per file: if you bet in two currencies, convert at the time of the bet or keep two files, because a sum of dollars and euros means nothing.
How to use it week to week
A bet tracker spreadsheet is only as good as its last update. A light routine keeps it accurate:
- When you place a bet, add the row, or at least take a screenshot of the slip to enter later.
- When the result is in, set the status and the return. Pending bets left open hide part of your stakes from the totals.
- Once a week, look at the summary: total staked, net result, balance. Turn on filters (Data › Filter) to look at one sport or one bookmaker.
- Once a month, compare your total staked with the budget you set. Our guide to bankroll management covers how to set one and stick to it.
The Charts sheet already gives your net result by month and by sport. For anything else, such as markets or bookmakers, a pivot table does the job: Insert › PivotTable, the column you want in rows, then the sum of Stake and Profit in values. Divide one by the other and you have an ROI for each. Just keep the sample size in mind: a dozen bets in one sport say very little.
And never delete a bad week. A record that only keeps the good stretches tells you what you want to hear, not what happened.
The limits of a spreadsheet
A spreadsheet is a fine bet tracker, and it is honest to say where it gets in the way.
- Typing time. Twelve fields per bet is one to two minutes each time. At ten bets a week, that is a quarter of an hour of data entry, every week, for as long as you keep it.
- Silent errors. A stake typed as 100 instead of 10.0, a return in the wrong row, a status left on Pending: the formulas keep working and the totals are quietly wrong.
- Breakdowns take work. Beyond the month and sport charts of the template, results by market, odds range or number of legs all need pivot tables or extra columns you build and maintain yourself.
- Clumsy on a phone. You place bets on your phone, but editing a fourteen-column sheet on a small screen is tedious, so entries pile up until the weekend, and some never get in.
- No reminders. Nothing tells you a bet is still pending three days later.
None of this is a reason to give up. It is the reason most spreadsheets are abandoned after a few weeks, and worth knowing before you commit.
Spreadsheet or app: you do not have to choose
A bet tracking app does the same calculations without the typing. With BetTrack, you take a screenshot of your bet slip in your bookmaker’s app and share it: every bet fully visible on the image is read, with its sport, market, selection, odds, stake, status and return, and bets you already logged are skipped. It works with any bookmaker because it reads the screenshot, not your account, and it never asks for your bookmaker login. A reminder nudges you when bets are still unsettled.
Your net result, total staked and win rate are worked out as you go, along with breakdowns by sport, market, singles versus parlays and number of legs that would take a stack of pivot tables in a spreadsheet. The free plan includes 10 AI imports, then one a day, plus manual entry and the main statistics.
If you like having your own file, the two work together: BetTrack Pro exports every bet and every selection as a CSV or Excel file, for any period, so you can keep running your own analyses in a spreadsheet without typing a single bet.
Frequently asked questions
Does the template work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets, or import it into a blank sheet. The formulas, number formats and status dropdown all carry over.
Why are my ROI and win rate empty?
Because no bet is settled yet. The summary only counts bets with a status other than Pending or Void, and shows a blank instead of an error while there is nothing to divide by.
How do I enter a parlay?
On a single row: the combined odds, your stake, the status of the whole bet and its number of legs. Never one row per leg, or your stake would be counted several times.
Can I use the spreadsheet on my phone?
Yes, in the Excel or Google Sheets apps, but typing fourteen columns on a small screen is slow. Many people take a screenshot of the slip and enter it later, or use an app that reads the screenshot directly.
Betting involves risks, including losing the money you stake. BetTrack makes no promise of winnings. 18+ only. Responsible gambling and where to find help
