# Basketball player game stats (free Excel template)

> Log every game and get FG%, eFG%, TS% and points per 36 minutes, plus averages, best game, last 5 games, home vs away and each competition.

Source: https://softwiro.com/templates/basketball-player-game-stats
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Basketball player game stats

A free Excel sheet for tracking a basketball player's stats. Log each game in one row (score, minutes, points, rebounds, assists, field goals and free throws) and the sheet works out FG%, eFG%, TS% and points per 36 minutes. You then see per-game averages, the best game, the form of the last 5 games, a home vs away comparison, and a table for each competition.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-basketball-player-game-stats.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-basketball-player-game-stats-blank.xlsx)

Excel file (.xlsx) · 78 KB · 5 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

## Example from the sheet

| الإجماليات |  |
| --- | --- |
| مباريات مسجلة | 14 |
| فوز | 9 |
| خسارة | 5 |
| نسبة الفوز | 64.3% |
| نقاط فريقك | 1,112 |
| نقاط المنافسين | 1,058 |
| مجموع الدقائق | 409 |
| نقاط اللاعب | 237 |
| ريباوند | 58 |
| أسيست | 92 |
| سرقات | 27 |
| بلوك | 6 |
| فقدان كرة | 47 |
| أخطاء شخصية | 35 |
|  |  |
| المتوسط في المباراة |  |
| نقاط / مباراة | 16.93 |
| ريباوند / مباراة | 4.14 |
| أسيست / مباراة | 6.57 |
| سرقات / مباراة | 1.93 |
| بلوك / مباراة | 0.43 |
| فقدان كرة / مباراة | 3.36 |
| أخطاء / مباراة | 2.50 |
| دقائق / مباراة | 29.2 |
| متوسط تقييمي | 6.93 |

Example from the “الملخص” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- «الإعدادات» (Settings): The player's name, position, team and season, and the list of competitions the team plays in (up to 8).
- «المباريات» (Games): For each game: date, competition from the list, opponent and venue, your team's points and the opponent's points. Then the player's numbers: minutes, points, rebounds, assists, steals, blocks, turnovers and fouls, field goals, threes and free throws, and your rating from 1 to 10. For each row it calculates the result, the percentages and points per 36 minutes, and it warns you if a number does not add up. It holds 300 games.
- «الملخص» (Summary): Totals, averages and per-36-minute figures, shooting percentages, the best game, the form of the last 5 games, a home vs away comparison, and a table for each competition.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

## What makes it different

Record each game once and get averages, percentages and recent form out of it, so you can see whether a player's shooting is really improving and where they play best, instead of relying on how a game felt afterwards.

## How to use it

1. In the «الإعدادات» (Settings) sheet, enter the player's name, position, team and season, then list the competitions the team plays in (up to 8).
2. In the «المباريات» (Games) sheet, log each game in one row: the date, the competition from the list, the opponent and whether you played 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 field goals (made and attempted), threes and free throws, and your rating of your performance from 1 to 10. The result and the percentages are calculated automatically.
5. Open the «الملخص» (Summary) sheet for averages, per-36-minute figures, shooting percentages, the best game and the form of the last 5 games.
6. Check the "تنبيه" (Alert) column in «المباريات»: it appears if you enter a number that does not add up, such as points that do not match shots or more threes than field goals.

**Before you start:**

- Field goals (FGM/FGA) include threes. Expected points = 2 x field goals made + threes made + free throws made.
- eFG% = (FGM + 0.5 x 3PM) / FGA, TS% = points / (2 x (FGA + 0.44 x FTA)), and points per 36 minutes = points / minutes x 36.
- The form of the last 5 games is calculated by game date; if two dates are the same, the lower row is treated as later. There are no ties in basketball, so a game with equal scores counts as neither a win nor a loss.
- A game whose competition is not in «الإعدادات» (Settings) is included in the totals and appears in an "unregistered competition" row in the competitions table.
- The rating is your own opinion of your performance, not an official rating. The numbers are tracking tools, not technical or medical advice, and do not replace the coach's view.
- The sheet holds 300 games and eight competitions, and is for one player; for a whole team you need a sheet per player or a custom program.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-basketball-player-game-stats.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-basketball-player-game-stats-blank.xlsx)

Excel file (.xlsx) · 78 KB · 5 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## 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

## Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

| In this sheet | In Custom Software from Softwiro |
| --- | --- |
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |

[See Custom Software from Softwiro](https://softwiro.com/contact) · [Ask for a demo](https://softwiro.com/contact)

## 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)

## Frequently asked questions

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

FG% is the share of shot attempts that go in, and counts a three like any other shot. eFG% = (FGM + 0.5 x 3PM) / FGA, which gives threes their extra value. TS% = points / (2 x (FGA + 0.44 x FTA)) also takes free throws into account. The higher the percentage, the more efficient the scoring.

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

It is points / minutes x 36, and it puts a game where the player played 18 minutes on the same footing as one where they played 35. It is a calculated estimate of what would happen at the same pace over 36 minutes, not a number the player will necessarily reach.

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

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

### Can the sheet replace a coach?

No. The sheet only tracks your numbers. It is not a technical assessment or medical or fitness advice, and your rating is your own opinion. Show your numbers to your coach and ask where to improve, and see a doctor for any injury.

### Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

### Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

### What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

### Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL [https://softwiro.com/api/mcp](https://softwiro.com/api/mcp), no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: [https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

More free templates for: Gyms and fitness

## More free templates

- Gym memberships tracker (Excel)
- Strength workout log
- Running, cycling and swimming log
- Training load sheet for any sport (session-RPE)
- Athlete nutrition and macros sheet
- Football player match stats sheet
- Swimming times and personal bests
- Martial arts and boxing training log
- Tennis and padel match log
- Athletics results and personal bests log
- Padel and 5-a-side court booking sheet (hourly)
- Ad budget media plan across platforms
- Ad campaign performance tracker
- Ads A/B test log
- Ads break-even and unit economics sheet
- Ad agency client management and reports
- UTM link builder and campaign naming
- Ad account audit checklist
- Ads creative production calendar

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
