Softwiro
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.

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

Example from the “الملخص” tab (Arabic), with the numbers and formulas that are in the file.
الإجماليات
مباريات مسجلة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.

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)Cheat sheet: basketball stats (2/3)Cheat sheet: basketball stats (3/3)
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 sheetIn 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 · Ask for a demo

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

More free templates for: Gyms and fitness

More free templates

All templates · Free tools