Free Excel template

Free basketball team stats template

Q: How do I calculate points per game in Excel?

Divide total points by games played: =C5/B5. Use the games each player actually played, not the team's games, or anyone who missed games will look worse than they are. Wrap it in IF(B5>0,...,0) for players who have not played yet.

Q: How do I find the top scorer in Excel?

Use =INDEX(names,MATCH(MAX(points),points,0)). MAX finds the highest value, MATCH finds its position and INDEX returns the name in that position. In Excel 365 you can also use XLOOKUP(MAX(points),points,names).

For youth, school and rec league coaches (and team parents) who keep season stats in a spreadsheet. Enter each player's games played and season totals; the template works out per-game averages, field goal percentage with a minimum-attempts rule so a 3-for-4 bench player does not top the list, each player's share of team scoring and the team leaders.

cellwise-basketball-stats-template.xlsxExcel workbook · 5.6 KB · works in Excel, Google Sheets, Numbers and LibreOffice · no signup

Download free template

Preview and try it

This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.

	A	B	C	D	E	F	G	H	I
1	Season stats: Westfield varsity basketball
2	Minimum field goal attempts for FG% leader					40
3
4	Player	Games	Points	Rebounds	Assists	FG made	FG attempts	FG%	FG% (qualified)
5	Jordan Ellis	14	238	62	41	92	201	0.45771144279	0.45771144279
6	Marcus Hill	9	171	38	55	64	139	0.46043165468	0.46043165468
7	Tyler Brooks	14	156	118	22	63	122	0.51639344262	0.51639344262
8	Andre Wallace	13	132	49	70	50	128	0.390625	0.390625
9	Kevin Osei	14	104	96	15	44	81	0.54320987654	0.54320987654
10	Luis Romero	12	88	31	26	33	85	0.38823529412	0.38823529412
11	Sam Whitaker	14	76	57	18	30	66	0.45454545455	0.45454545455
12	Devin Shaw	11	51	22	30	19	52	0.36538461538	0.36538461538
13	Chris Nolan	10	34	41	6	15	27	0.55555555556	0
14	Eli Turner	8	22	9	11	8	24	0.33333333333	0
15	Ryan Cole	6	12	14	2	5	9	0.55555555556	0
16	Nate Price	5	8	3	4	3	11	0.27272727273	0
17	Team total		1092	540	300	426	945	0.45079365079
18
19	Player	Points/game	Rebounds/game	Assists/game	Share of team points
20	Jordan Ellis	17	4.4	2.9	0.21794871795

How the formulas work

Per-game averages that ignore games missed

B20=IF($B5>0,ROUND(C5/$B5,1),0)

Season points divided by games that player actually played, rounded to one decimal. This is why Marcus Hill leads in points per game (19.0) even though Jordan Ellis scored more in total: Marcus missed five games. The IF returns 0 for a player with no games yet instead of #DIV/0!. The $ on column B lets the same formula copy across for rebounds and assists.

Field goal percentage

H5=IF(G5>0,F5/G5,0)

Shots made divided by shots attempted, shown as a percentage. The team row (H17) divides total makes by total attempts, which is the correct team figure. Averaging the players' percentages instead would give a bench player who took 9 shots the same weight as a starter who took 200.

A minimum-attempts rule for the FG% leader

I5=IF(G5>=$F$2,H5,0)

Leagues only rank shooting percentage for players with enough attempts. This column copies a player's FG% if they have at least the minimum in F2 (40 here) and shows 0 otherwise, so the leader formula only sees qualified shooters. Without it, Chris Nolan (15 of 27) and Ryan Cole (5 of 9), both at 56%, would rank above Kevin Osei, who has made 54% of 81 attempts.

Find the leader in each category

C34=INDEX($A$20:$A$31,MATCH(MAX(B20:B31),B20:B31,0))

MAX finds the highest points per game, MATCH finds which row it is in, and INDEX returns the player name from that row. The value next to it in E34 is the same MAX on its own. If two players tie, MATCH returns the first one in the list.

Make it yours

Update totals after each game, or keep a game-by-game sheet (date, opponent, player, points, rebounds, assists) and total each player here with SUMIF.
Add three-point and free-throw columns the same way: makes, attempts and a percentage with IF(attempts>0,makes/attempts,0). Insert them after column G so the per-game block below does not move.
Color the top scorers: select B20:B31, then Home > Conditional Formatting > Top/Bottom Rules > Top 10 Items, and change 10 to 3.
Share stats with care in youth leagues. Many coaches only share team totals or each family's own player's numbers.

FAQ

How do I calculate points per game in Excel?

Divide total points by games played: =C5/B5. Use the games each player actually played, not the team's games, or anyone who missed games will look worse than they are. Wrap it in IF(B5>0,...,0) for players who have not played yet.

How do I find the top scorer in Excel?

Use =INDEX(names,MATCH(MAX(points),points,0)). MAX finds the highest value, MATCH finds its position and INDEX returns the name in that position. In Excel 365 you can also use XLOOKUP(MAX(points),points,names).

Can I use this for other sports?

Yes. Rename the columns (goals, assists and shots for soccer or hockey; hits and at-bats for baseball) and keep the same per-game and leader formulas. A batting average, for example, is hits divided by at-bats, the same pattern as FG%.

Functions used

Related guides

More free templates

Updated November 2, 2026