How to Track Batting Stats by Hand or Spreadsheet

July 18, 2026

A single game’s batting line is easy to calculate — the batting average calculator does it instantly. Tracking a full season correctly takes one more habit: keeping running totals instead of averaging individual game averages.

The One Rule: Never Average Your Averages

This is the single most common season-tracking error. If a player goes 2-for-4 (.500) in Game 1 and 1-for-4 (.250) in Game 2, the season average is not (.500 + .250) ÷ 2 = .375. The correct method adds up the raw totals first:

Season AVG = Total Hits ÷ Total At-Bats
           = (2 + 1) ÷ (4 + 4)
           = 3 ÷ 8
           = .375

In this particular example the two methods happen to land on the same number only because both games had exactly 4 at-bats — as soon as at-bat counts differ between games, averaging the individual game averages produces the wrong season number. Always sum the raw counting stats (hits, at-bats, walks, HBP, sacrifice flies, total bases) across every game first, then divide once at the end. See common batting stat mistakes for a worked example of exactly how far off “averaging averages” can get.

Tracking by Hand: A Simple Running Tally

A basic paper or notebook tracker only needs one row per game and seven running-total columns:

Game | AB | H | 2B | 3B | HR | BB | HBP | SF

After each game, add that game’s numbers to a season-total row at the bottom, then plug the season totals into the batting average calculator to get updated AVG, OBP, SLG, and OPS. This takes under a minute per game and avoids any manual division error creeping into a running average.

Building a Spreadsheet Formula Sheet

A spreadsheet (Google Sheets or Excel) automates the math so it recalculates instantly every time a new game’s row is added. Set up one row per game with columns for AB, H, 2B, 3B, HR, BB, HBP, and SF, then add a totals row at the bottom using SUM() for each column. From the totals row, four formulas cover everything:

AVG  = Hits ÷ At-Bats
OBP  = (Hits + Walks + HBP) ÷ (At-Bats + Walks + HBP + Sac Flies)
SLG  = Total Bases ÷ At-Bats
Total Bases = Singles + (2 × Doubles) + (3 × Triples) + (4 × Home Runs)

Since singles aren’t usually logged directly, calculate them as Hits − Doubles − Triples − Home Runs in their own column first, then feed that into the Total Bases formula. Format all four result cells to three decimal places to match standard box-score notation.

Recalculating After Each Game vs. End of Season

Recalculating after every game (rather than waiting until the season ends) has a real advantage: it makes it obvious exactly how much a single game can swing a season-long rate stat early on, and how little it moves that same stat once the season total gets large. A 3-for-4 game in April can swing a 10-at-bat season average by well over 50 points; the same 3-for-4 game barely moves a 150-at-bat season average. Tracking incrementally builds an intuitive sense of when a hot or cold week is statistically meaningful and when it’s still just noise.

What to Log Every At-Bat

For AVG alone, only at-bats and hits are required. To unlock OBP and SLG too, log these seven things for every plate appearance:

At-bat or not — walks, HBP, and sacrifice flies are plate appearances but not at-bats
Hit type — single, double, triple, or home run (needed for total bases)
Walk (BB)
Hit-by-pitch (HBP)
Sacrifice fly (SF) — specifically a fly out that scores a runner, not a sacrifice bunt

Getting these seven categories right at the point of scoring — rather than trying to reconstruct them from memory later — is what keeps a season-long spreadsheet accurate. See the baseball hitting stats glossary for exact definitions of each term if a specific play is unclear in the moment.

Try It

Once a season’s running totals are added up, drop them straight into the batting average calculator for the season’s AVG, OBP, SLG, and OPS in one step — no manual division required.