Sports Betting Spreadsheet Template — Free Download

Tracking bets is only useful if your numbers are right. A spreadsheet with wrong P&L formulas — or one where you've been forgetting to enter pushes — gives you a false picture of your edge. This template is built to get the maths right from the start, so you can focus on what the data is telling you instead of auditing your own formulas.

It works with Google Sheets (free) and can be downloaded as Excel in one click. No account required, no paywall. Just copy it and start.

What the Template Includes

The main bet log sheet has nine columns. Here's what goes in each one and why it matters:

• Column A — Date. The date you placed the bet. Useful for filtering by month, week, or season to spot performance trends over time.
• Column B — Sport. NFL, NBA, MLB, Soccer, Tennis, etc. Once you have enough data, breaking down ROI by sport is one of the most revealing analyses you can run.
• Column C — Book. The sportsbook where you placed the bet (DraftKings, FanDuel, Bovada, BetOnline, etc.). Tracking by book shows you where you're getting the best odds and whether any books are limiting your action.
• Column D — Selection. The team, player, or outcome you bet on. Keep this consistent — "Kansas City Chiefs" not "KC" one time and "Chiefs" the next.
• Column E — Market. Moneyline, spread, total (over/under), or prop. Your win rate and ROI will look very different across these market types.
• Column F — Odds. American format. Favourites are negative (e.g. -110, -180). Underdogs are positive (e.g. +145, +320). The P&L formula in column I uses this to calculate winnings automatically.
• Column G — Stake ($). The dollar amount wagered. If you're using a unit system, you can add a separate Units column and derive the dollar amount from it.
• Column H — Result. Enter W (win), L (loss), Push, or leave blank for Pending. The P&L formula in column I reads this to calculate the outcome.
• Column I — P&L ($). Auto-calculated. This column is the formula — you never type into it. Once a result is entered in column H, it updates immediately.

The template also includes a summary section at the top of the sheet with the following stats, all auto-updated as you add rows:

• Total Bets — count of all settled bets (W + L + Push)
• Wins / Losses / Pushes — broken out individually
• Win Rate % — wins divided by (wins + losses), pushes excluded
• Total Staked ($) — sum of all stakes
• Net P&L ($) — sum of all P&L values
• ROI % — net P&L divided by total staked, expressed as a percentage

The P&L Formula Explained

American odds have two formats and the calculation is different for each. Getting this right is important — a wrong formula will silently overstate or understate your returns.

If you win and the odds are positive (underdog bet):
Your winnings = Stake × (Odds ÷ 100)
Example: $50 at +145 → $50 × (145 ÷ 100) = $72.50 profit

If you win and the odds are negative (favourite bet):
Your winnings = Stake × (100 ÷ |Odds|)
Example: $100 at -110 → $100 × (100 ÷ 110) = $90.91 profit

If you lose:
P&L = −Stake (you lose the amount you wagered, nothing more)

If it's a push:
P&L = $0 (stake is returned, no profit or loss)

The Google Sheets formula that handles all four cases is:

Reading it from left to right: if the result is W, check whether the odds are positive or negative and apply the correct formula. If the result is L, return the negative stake. If the result is Push, return zero. If the cell is empty (Pending), return blank so it doesn't skew your totals.

This formula is already set up in the template across all rows. You don't need to enter or modify it.

The ROI Formula

Return on investment is the single most important number in your spreadsheet. It tells you how many cents you're making (or losing) for every dollar you bet — normalised so that bet size doesn't distort the picture.

The formula for your summary cell is:

This sums all P&L values in column I, divides by all stakes in column G, and multiplies by 100 to give a percentage. A result of +4.2 means you're returning $4.20 for every $100 wagered. A result of -3.1 means you're losing $3.10 per $100.

Recreational bettors typically run at -5% to -8% ROI (roughly the vig). Anything above break-even over a large sample is meaningful. Above +3% over 500+ bets suggests a genuine edge. For more on interpreting this number, see our guide on how to calculate betting ROI in a spreadsheet.

How to Use the Template

1. Click the template link below to open it in Google Sheets. The original is read-only — you won't be able to edit it directly.
2. File > Make a copy. This saves a personal copy to your Google Drive. Give it a name you'll recognise (e.g. "Bets 2026"). From this point on, it's fully yours.
3. Start entering bets in row 2. Fill in columns A through H. Column I calculates automatically the moment you type a result in column H.
4. Update the Result column (H) when bets settle. Change "Pending" to W, L, or Push and the P&L and all summary stats update instantly.

The Manual Entry Problem

For bettors placing 20 or more bets per month, typing each bet manually is a real obstacle. Each entry takes roughly 2–3 minutes when you account for opening the spreadsheet, finding the right row, entering all nine fields accurately, and double-checking the odds you typed. At 25 bets a month, that's over an hour of data entry — every month, indefinitely.

That's not a hypothetical. It's the main reason most bettors abandon tracking within six weeks. The habit breaks during a bad run — when entering losses feels like piling on — and it doesn't come back. A dataset with an eight-month gap in the middle is nearly useless for ROI analysis, because you have no idea whether the missing period was better or worse than what you can see.

This is the problem S2S Bets is built to solve. Instead of typing each bet, you screenshot your bet slip from any sportsbook — including offshore books — and S2S Bets parses it and fills in the row automatically. The spreadsheet stays yours. The data stays on your device. You just skip the typing.

If you're curious about whether screenshot parsing fits your workflow, the bet tracker showdown compares all three methods side by side. Or if you're already sold on Google Sheets and want the full setup walkthrough, see the complete guide to tracking bets in Google Sheets.

For bettors using Excel rather than Google Sheets, everything here applies — see our dedicated Excel bet tracker guide for the platform-specific steps.