Basketball coaches and players know that "I played well" is not enough: did my shooting really improve, or do I just remember my best game? Do I score more at home than away? The free basketball player game stats sheet records each game in one row and works out shooting percentages, points per 36 minutes and the form over the latest games, so you see your performance on one page.
The problem it solves
When you keep game numbers on paper or in a notes app, you know what happened last night but not the direction of the season: is the scoring average rising or falling, is the shooting better from three or from the free-throw line, and does performance differ at home and away. Here you enter each game once and the sheet works out the rest and summarises it.
Steps from opening the file to the summary
- Settings: write the player's name, position, team and season, then the competitions his team plays in (up to 8).
- Games: log each game in a row: the date, the competition from the list, the opponent and whether you played at home or away.
- Enter your team's points and the opponent's points, then the player's numbers: minutes, points, rebounds, assists, steals, blocks, turnovers and fouls.
- Enter the field goals (made and attempted), the threes and the free throws, and your own rating of your performance from 1 to 10. The result (win or loss) and the percentages appear on their own.
- Open Summary for the averages, the per-36-minute numbers, the shooting percentages, the best game and the form over the last 5 games.
- Check the Alert column on the Games sheet: it shows if you typed a number that does not add up, such as points that do not match the shots, or more threes than field goals.
Worked example (sample data)
The name and figures below are sample data for an example player in the point guard position. 14 games were logged between 11 September and 11 November 2026, and his team won 9 and lost 5:
- One game in detail (11 September against Al-Shorouk Club, at home): 32 minutes, 7 field goals made out of 15, including 2 threes out of 6, and 4 free throws out of 5. Points = 2 × 7 + 2 + 4 = 20, field goal percentage 46.7%, eFG% 53.3%, and points per 36 minutes 22.5. The game ended 82-74, a win.
- Totals: 409 minutes, 237 points, 58 rebounds, 92 assists, 27 steals, 6 blocks and 47 turnovers.
- Per-game average: 16.93 points, 4.14 rebounds, 6.57 assists, and an average self-rating of 6.93 out of 10.
- Per 36 minutes: 20.86 points, 5.11 rebounds and 8.10 assists.
- Shooting percentages: field goals 44.4% (83 of 187), threes 33.3% (27 of 81), free throws 77.2% (44 of 57), eFG% 51.6%, TS% 55.9%, and an assist-to-turnover ratio of 1.96.
- Best game by points: 25 points in a 95-81 win over Al-Salam Club on 23 October. He also scored 25 against Al-Manar Club on 3 November, and the sheet shows the first of the two.
- Last 5 games: 3 wins and 2 losses, averaging 16.4 points, 3.8 rebounds and 5.8 assists, with an average rating of 6.8.
- Home and away: 7 home games, all won by the team, with an average of 20.86 points; and 7 away games, of which only 2 were won, with an average of 13 points.
- By competition: the league 10 games, 7 wins and an average of 16.1 points; the Egypt Cup 2 games, 1 win and an average of 21 points; the friendly 1 game, lost, with 9 points. There is also one game in a "summer tournament" that is not in the competition list (25 points); it counts in the totals and shows in the "competition not registered in Settings" row so you can correct its name or add it.
How the numbers are worked out
- Logical points = 2 × field goals made + threes made + free throws made, and field goals (FGM and FGA) include the threes.
- eFG% = (FGM + 0.5 × 3PM) ÷ FGA.
- TS% = points ÷ (2 × (FGA + 0.44 × FTA)).
- Points per 36 minutes = points ÷ minutes × 36.
- Form over the last 5 games is worked out by game date, and if two dates are the same the upper row comes first.
Limits you should know
- The sheet is for one player; for a whole team you need a sheet per player or a custom program. It holds 300 games and eight competitions.
- There is no tie in basketball, so a game with equal scores counts as neither a win nor a loss.
- A game whose competition is not in Settings counts in the totals and shows in the "competition not registered" row.
- My rating is your own opinion of your performance, not an official rating. The numbers are tracking tools, not technical or medical advice, and they do not replace the opinion of the coach or a doctor.
- The sheet does not log events live, does not draw a shot chart, sends no alerts and does not show your numbers to your coach unless you send him the file.
Try it
Open the sheet and try it online, or download it for Excel. If you want a program for a basketball team with each player's stats and reports for the coach and parents, ask for it here.





