top of page

Simple Sports Bet Tracking Spreadsheet 2022 (Google Sheets)

Updated: Nov 26, 2022

A free bet tracking spreadsheet template for Google Sheets to help you track your sports bets and learn where you can improve.

  • Learn how to use this simple spreadsheet

  • Tips for helping yourself improve by tracking your bets

  • Download the Google Sheets template

To become a more seasoned sports bettor you need to be able to know your strengths and weakness. This way you can capitalize on what you're good at, and modify your strategy in areas you struggle.

The only way you can do this is by tracking your sports bets in a bet tracking spreadsheet or bet tracking app.

Your sportsbook provides very little information beyond a list of bets you've won and lost so it's important to separately track your bets to help you learn more.

Get access to the Bet Tracking Spreadsheet here 👇

How to use this bet tracking spreadsheet

Step #1 - Make a Copy and Save

This document is currently view only. Click File > Make A Copy, or File > Download to your own computer to make edits.

Step #2 - Enter Begining Bankroll and Unit Size

Add up your bankroll across all your books and enter it in. Also, enter your unit size.

Step #3 - Fill out the game information for each bet

Enter in the Game Date, Away Team, Home Team, and select the Bet Type.

Step #4 - Fill out the bet information for each bet

Enter in the amount you wagered, the odds, the result, the category, and which sportsbook you bet on.

Step #5 - The spreadsheet does the rest for you!

The spreadsheet automatically fills in all the other relevant columns for you and gives you a summary of your strengths and weaknesses.

Get access to the Bet Tracking Spreadsheet here 👇

How can I improve by tracking my sports bets?

Tip #1 - Log all of your bets 👨‍💻

There is a lot you can learn from looking over your bets, especially the losses. This template makes it easy for you to simply enter in the date, teams playing, wager amount odds, and bet type, and the spreadsheet will fill out the rest.

Tip #2 - Stay consistent 🏈

Any pro bettor will tell you that consistency is the name of the game. This means staying consistent with your wager size to keep yourself from large losses. It also means staying consistent with leagues you follow more closely. That means late-night Russian ping pong betting may not be the best move (surprise)!

Tip #3 - Keep an eye on what leagues and bet types you're best at 🥇

Once you have a good number of bets tracked (50-100+) you can begin looking for areas in which you excel. Maybe it's NHL spreads or NFL underdog moneyline bets. Whatever it is, use this information to capitalize and win more!

Tip #4 - Learn what sportsbooks give you an edge 🤑

One of the ways sportsbooks compete against each other is by having better lines and odds. You can benefit from their competition by finding what sportsbooks give you the best odds, and consequently which ones provide you the best ROI.

Tip #5 - It's worth the hassle 😓

Ask any pro or semi-pro bettor, and they'll tell you they track their bets. Although it takes a lot of time and can be a hassle, the value it provides to help you improve is priceless.

Is there an easier way to track your sports bets?

It takes discipline and a decent amount of time each week to track your bets manually. And this only gets harder during March Madness or during the NFL playoffs when you bet 10+ times a day.

Vault is an app that makes tracking your bets easy. It syncs directly with your sportsbooks, like DraftKings and BetMGM, so that your bets are automatically tracked - no more manually tracking!

Download Vault now!

Download Vault the best bet tracking app for iphone


bottom of page