# Basketball player stats Excel (free) + online

> Free Excel basketball stats sheet: log each game and get FG%, eFG%, TS%, points per 36 minutes, averages, best game, last 5 games and home vs away.

Source: https://softwiro.com/blog/basketball-player-game-stats-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Basketball player game stats in Excel (free): FG%, eFG%, TS% and points per 36 minutes

Log each game once and see shooting percentages, averages, your best game and your form over the last 5 games.

13 November 2026 6 min read

## In short

- Log each game once: score, minutes, points, rebounds and assists.
- FG%, eFG%, TS% and points per 36 minutes are worked out for every game.
- Summary: averages, best game, form over the last 5 games, home vs away and each competition.
- A tracking tool, not technical or medical advice, and it does not replace a coach.

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](https://softwiro.com/templates/basketball-player-game-stats) 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

1. Settings: write the player's name, position, team and season, then the competitions his team plays in (up to 8).
2. Games: log each game in a row: the date, the competition from the list, the opponent and whether you played at home or away.
3. Enter your team's points and the opponent's points, then the player's numbers: minutes, points, rebounds, assists, steals, blocks, turnovers and fouls.
4. 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.
5. Open Summary for the averages, the per-36-minute numbers, the shooting percentages, the best game and the form over the last 5 games.
6. 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](https://softwiro.com/templates/basketball-player-game-stats). 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](https://softwiro.com/request-sheet).

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: basketball stats (1/3)](https://softwiro.com/uploads/cheatsheets/basketball-player-game-stats/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/basketball-player-game-stats/en-1.jpg)[![Cheat sheet: basketball stats (2/3)](https://softwiro.com/uploads/cheatsheets/basketball-player-game-stats/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/basketball-player-game-stats/en-2.jpg)[![Cheat sheet: basketball stats (3/3)](https://softwiro.com/uploads/cheatsheets/basketball-player-game-stats/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/basketball-player-game-stats/en-3.jpg)

0 downloads · 3 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### What is the difference between FG%, eFG% and TS%?

FG% is the share of shots made out of those attempted, and it treats a three like any other shot. eFG% = (FGM + 0.5 × 3PM) ÷ FGA and gives the three its extra value. TS% = points ÷ (2 × (FGA + 0.44 × FTA)) adds the free throws. The higher the percentage, the more efficient the player's scoring.

### What does points per 36 minutes mean and why use it?

It is points ÷ minutes × 36, and it puts a game where the player played 18 minutes and one where he played 35 on the same footing. It is an arithmetic estimate if he played at the same pace, not a number he will actually reach.

### What does the alert "points do not match the shots" mean?

Logical points = 2 × field goals made + threes made + free throws made. If what you typed does not match this formula, the alert appears at the end of the row, so check the wrong number.

### Does the sheet replace a coach?

No. The sheet is only a tool for tracking your numbers, not a technical assessment or medical or fitness advice, and your rating of yourself is your own opinion. Show your numbers to your coach and ask him where to improve, and consult a doctor for any injury.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
