How-To Tools Hockey Stats

Hockey Stats Keeper · July 16, 2026 · 8 min read

If you manage a youth, rec, or beer league hockey team, someone eventually asks: "Hey, who's leading the team in points?" And if your answer lives in a notebook, a group chat, or your memory, you need a hockey stats spreadsheet.

This page gives you a free one — built the way team managers actually use it — plus an honest look at what a spreadsheet does well, where it breaks down, and what to do when it does.

What's in the template

The template has five tabs, and they're all connected — enter data in two of them and everything else calculates automatically.

• Roster — player names, jersey numbers, positions. Enter this once. Every other tab pulls from it, so you never retype a name.
• Game Log — one row per player per game: goals, assists, shots, penalty minutes, plus/minus. This is the only tab you touch after each game.
• Leaderboard — auto-calculated season totals, ranked by points. Goals, assists, points, PIM, and games played, sorted so your top scorer is always row one.
• Goalie Stats — shots against, goals against, and minutes per game, with save percentage and goals-against average calculated for you. (Not sure how those formulas work? See our guide to tracking stats and goalie metrics.)
• Team Record — wins, losses, ties, overtime losses, and goal differential by game, with a running season record at the top.

How to use it

1. Make a copy (Google Sheets) or download the .xlsx (Excel).
2. Fill in the Roster tab before your first game.
3. After each game, add one row per player who recorded a stat in the Game Log.
4. Check the Leaderboard tab — it's already up to date.

That's the whole workflow. Ten minutes after each game, give or take.

What a spreadsheet does well

Let's be fair to the spreadsheet: it's free, it's flexible, and you own it forever. For a team that just wants season point totals, it genuinely works. Plenty of teams run a whole season this way — that's exactly why we built this template instead of pretending spreadsheets don't exist.

The six places a spreadsheet breaks down

We talk to a lot of team managers, and the story is always the same. The spreadsheet works great in October. By January, it's a problem. Here's where it cracks:

1. Live entry at the rink doesn't work

Editing a spreadsheet on your phone, on a bench, with gloves nearby, between shifts — it's miserable. So stats get scribbled on paper and retyped later. Sometimes. Eventually.

2. Only one person can really maintain it

Sharing edit access with a co-manager usually ends with a broken formula and a leaderboard that says #REF!.

3. Players and parents can't see it

You end up screenshotting the leaderboard into the team chat every week. The screenshot is out of date by the next game.

4. Goalie stats are fragile

SV% and GAA formulas are exactly the kind of thing that silently breaks when someone inserts a row.

5. No history

New season, new spreadsheet. Comparing this season to last season means two files open side by side and a lot of squinting.

6. No game-level detail

Power play goals, shorthanded goals, penalty types, who assisted whom — a flat game log can't hold it without becoming unmanageable.

When you've outgrown it: the upgrade path

If any of those six sound familiar, the fix isn't a better spreadsheet — it's purpose-built software. Hockey Stats Keeper gives your team its own private stats website at yourteam.hockeystatskeeper.com: live goal/assist/penalty entry from your phone during games, automatic leaderboards, goalie SV% and GAA, season-over-season comparisons, and a page every player and parent can check themselves — so you never screenshot a leaderboard again.

There's a 14-day free trial, so you can enter a real game before paying anything.

Not ready? Keep the spreadsheet — it's yours. When it breaks in January, you know where we are. For a full comparison of your options, see the best hockey stat tracker apps compared, or start with our complete guide to tracking stats for a youth team.

Frequently Asked Questions

Does the template work in both Google Sheets and Excel?

Yes. The download is a native .xlsx file that works in Excel and can be uploaded to Google Drive and opened in Google Sheets. Once it's in Sheets, go to File → Make a copy to save your own editable version. Formulas are identical in both.

What stats does the template track?

Goals, assists, points, shots, penalty minutes, and plus/minus per player per game; save percentage, GAA, and minutes for goalies; and the team's W-L-T-OTL record with goal differential.

Can I track multiple seasons in one spreadsheet?

Not cleanly — that's one of the spreadsheet's real limits. You'd duplicate the file each season. If you want season-over-season player comparisons, that's a job for a dedicated hockey stats tracker.

Is the template really free?

Yes. We ask for an email so we can send occasional tips for team managers. No credit card, no catch.

How is this different from a hockey stats app?

The spreadsheet is manual and lives with one person. An app like Hockey Stats Keeper is live during games, updates leaderboards automatically, and gives every player their own profile page. The template is the right start; the app is the upgrade.

Share this article

Ready to track your team’s hockey stats?

Hockey Stats Keeper gives your team a private website at yourteam.hockeystatskeeper.com with live goal tracking, leaderboards, player profiles, and more.

Start your free trial →