Basketball field goal percentage calculator spreadsheet
A basketball field goal percentage calculator spreadsheet gives coaches, teachers, players, and analysts a quick way to measure shooting efficiency. By entering field goals made and field goals attempted, the sheet calculates the percentage of shots converted during a game, training session, tournament, or full season.
Field goal percentage, often written as FG% or FGP, includes successful two-point and three-point shots. It does not include free throws. This makes it different from effective field goal percentage, which gives extra value to three-pointers, and true shooting percentage, which also considers free throws.
A reusable spreadsheet is useful for community clubs, school teams, NBL supporters, and individual players. A coach in Melbourne might track several junior teams across a weekend, while a basketball program in Brisbane could use the same workbook for training records and player development.
The calculator can work in Microsoft Excel, Google Sheets, or another compatible spreadsheet program. With a clear layout and reliable formulas, it can turn basic box-score figures into useful information without requiring specialist statistics software.
How field goal percentage is calculated
The standard formula is:
Field goal percentage = Field goals made ÷ Field goals attempted × 100
For example, if a player makes 8 shots from 20 attempts, the calculation is 8 ÷ 20 × 100 = 40%. The spreadsheet should store the result as a percentage so it displays as 40.00% rather than a decimal such as 0.4.
A field goal attempt includes a shot from the floor that is made or missed. Two-pointers and three-pointers both count as one field goal attempt, and each successful shot counts as one field goal made. Free throws should be recorded in separate columns because they belong to a different part of a player’s shooting profile.
A simple Excel or Google Sheets formula might be:
=IF(D2=0,"",C2/D2)
In this example, C2 contains field goals made and D2 contains field goals attempted. The IF function keeps the cell blank when no shot attempts have been entered, avoiding a divide-by-zero error. Format the formula cell as a percentage and choose one or two decimal places.
Building a practical spreadsheet
Start with columns for player name, team, game date, opponent, field goals made, field goals attempted, and FG%. Adding competition, venue, season, and notes can make the file more useful for ongoing analysis. A date format such as dd/mm/yyyy suits Australian records and avoids confusion when files are shared with overseas users.
For a team sheet, place one player on each row and use a separate row for totals. The team formula should add all field goals made and all field goals attempted before calculating the overall percentage. Averaging individual player percentages can give a misleading result because it treats a player with two attempts the same as a player with twenty attempts.
A useful structure might look like this:
| Player | FGM | FGA | FG% | 2PM | 3PM | Notes |
|---|---|---|---|---|---|---|
| Alex Brown | 8 | 20 | 40.00% | 5 | 3 | Strong second half |
| Mia Taylor | 6 | 12 | 50.00% | 6 | 0 | Efficient inside |
| Team total | 14 | 32 | 43.75% | 11 | 3 | Game total |
The two-point and three-point columns are optional, but they help explain the result. Someone who makes five of ten three-point attempts has the same FG% as someone who makes five of ten layups, although the scoring impact is different. Keeping shot type information beside the basic percentage prevents the statistic from being interpreted in isolation.
Using the calculator for player and team analysis
A single game percentage can be informative, but several games provide a more dependable performance picture. Add a season summary sheet that totals made shots and attempts across every fixture, then calculates the cumulative FG%. This method gives high-volume games the correct weighting.
For example, a player who shoots 2 from 4 in one game and 8 from 24 in another has made 10 of 28 attempts, producing 35.71%. Simply averaging 50% and 33.33% would produce 41.67%, which does not represent the player’s actual total shooting record.
Coaches can use the spreadsheet to compare home and away games, first and second halves, or different shot locations. A club in Sydney may record matches at several courts, while a regional Western Australian team may want to compare long travel weekends with local fixtures. Adding filters makes it easier to identify patterns without changing the underlying calculations.
For teaching, the workbook can support lessons in percentages, ratios, averages, and data interpretation. Students can enter figures from a school match, a basketball statistics exercise, or a selected NBL game and explain why a high FG% does not automatically mean a player scored the most points. The exercise connects arithmetic with a familiar sporting context.
Avoiding common spreadsheet errors
The most frequent mistake is entering points scored instead of field goals made. If a player scores 18 points, that figure cannot be used as FGM because the points may include three-pointers and free throws. The correct made-shot count must come from the box score or shot record.
Another error is adding free throws to field goal attempts. A player who makes 6 of 15 field goals and 4 of 5 free throws has an FG% of 40%, calculated from 6 ÷ 15. The free throws belong in separate free-throw columns and may be used later for true shooting percentage.
Data validation can reduce incorrect entries. Set the FGM and FGA cells to accept whole numbers greater than or equal to zero, and use a rule that prevents made shots from exceeding attempts. Conditional formatting can highlight unusually low percentages, missing values, or rows where the inputs do not make sense.
Protecting formula cells is useful when a workbook is shared with volunteers or students. Lock the calculation columns while leaving the input cells editable. Keep a backup copy in a secure location and use clear file names such as junior_women_fg_stats_2025.xlsx.
Australian organisations should also consider privacy when recording identifiable player information. The Privacy Act 1988 and the Australian Privacy Principles may apply to organisations covered by the legislation, while schools and clubs can have additional internal policies. Collect only information needed for the sporting purpose, limit public sharing of names and results, and obtain appropriate permission for junior participants.
Adapting the workbook to Australian basketball
The spreadsheet can be tailored to Basketball Australia programs, NBL or WNBL discussions, local associations, school competitions, and social leagues. Australian basketball operates across very different settings, from metropolitan competitions in Melbourne and Adelaide to regional clubs in Queensland, New South Wales, and Western Australia. A flexible template should work for a single game as well as a full competition schedule.
Use Australian date formats, Australian dollars only where budgeting is added, and local competition labels rather than assuming United States terminology. A club purchasing a paid statistics platform should also check Australian Consumer Law protections, subscription terms, automatic renewal conditions, and whether advertised features are available for the intended number of users.
The workbook can include a dashboard with games played, total attempts, total makes, average attempts per game, and cumulative FG%. Charts may show a player’s percentage across the season or compare team shooting with opponents. Keep visual elements simple so the file remains practical on a laptop at a Perth stadium, a tablet courtside in Brisbane, or a shared computer at a community club.
For everyday use, one person can record box-score figures immediately after each match, then review the summary during weekly training. In competitions where volunteers rotate between duties, instructions on the first sheet can explain where to enter data and which cells should not be edited. This reduces inconsistency when several scorers contribute to the same workbook.
A well-designed basketball field goal percentage spreadsheet turns a basic formula into a dependable record-keeping tool. Download or create a template with separate input and calculation areas, test it with sample figures, and adapt the columns to suit your team, classroom, club, or season. Use it consistently after each game to build a clearer picture of shooting efficiency and make every set of statistics easier to understand.