Free Scorecard Excel Template (Team Season Record)
What's in the scorecard template
The template is a single Season sheet with one row per game: date, opponent, home or away, your score, their score, and the result.
With 40 rows, it covers a full season for most team sports — enough to log every game and still have room for playoffs or a rematch schedule.
What calculates automatically
The Result column fills in win, loss, or tie automatically the moment you enter both scores for a game — no need to mark it yourself and risk a mismatch with the numbers.
The summary rolls those results into wins, losses, and ties for the season, plus average points scored per game, so you get a season record without tallying anything by hand.
Why this beats a blank spreadsheet
A blank spreadsheet means building the game log and then writing an IF formula to decide win/loss/tie and separate COUNTIF formulas to tally the season record — small things that are easy to get wrong across a full season.
This template already has the result logic and the season tally built in. You enter the score for each game, and the result and the running record update themselves.
How to use it
- Log one row per game: opponent, home or away, and both teams' scores.
- Result (win/loss/tie) calculates automatically once both scores are entered.
- Check the summary for your season's wins, losses, ties, and average points per game.
Download the free Free Scorecard Excel Template (Team Season Record)
No spam — template updates and new free templates only. Unsubscribe anytime.
Frequently asked questions
Can I use this scorecard template in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. The result column and season tally keep working.
Is this template really free?
Yes. You give an email address to download it, and then it's yours to use with no further cost.
What sports does this scorecard work for?
Any team sport where the result comes down to a final score for each side — soccer, basketball, hockey, volleyball, and similar. It's not sport-specific beyond the score and result.
What's the usage license?
Personal use or use within one business. It's not meant to be resold or redistributed as a template product.
Can I track more than 40 games?
Yes, it's a standard Excel/Google Sheets file. Add rows below the existing table and extend the Result formula and the season summary to cover the new rows.