Softwiro
Free Excel template

Football player match stats in Excel (free): goals and assists per 90, last-5 form, home vs away

Log each match and see totals, per-90 figures, shooting and passing accuracy and recent form.

6 min read

A youth coach, or a player who wants to know his level, usually asks: am I scoring more? Is my form better over the last few matches? Do I play better at home? The free football player match stats sheet collects every match's numbers in one file and works out these answers for you.

The problem it solves

Raw numbers mislead. Two goals in a whole season mean nothing until you know how many minutes the player played, and a big win can hide a lot of lost passes. When the numbers sit on paper or in scattered messages you cannot see the trend. Here there is one row per match and the sheet works out the rest: figures per 90 minutes, shooting and passing accuracy, and the form of the last 5 matches.

Steps from opening the file to the summary

  1. Settings: the player's name, position, team and season, then the competitions his team plays in (up to 8).
  2. Matches: one row per match: date, competition from the list, opponent, and whether you played at home or away.
  3. Enter your team's goals and the opponent's goals, then the player's numbers: minutes, goals, assists, shots (and those on target), completed and attempted passes, and cards.
  4. Enter your own rating of your performance from 1 to 10. The result (win, draw or loss) and the passing accuracy work themselves out.
  5. Open Summary for the totals, the per-90 figures, the form of the last 5 matches and the home vs away and per-competition comparisons.
  6. Check the Alert column in Matches: it flags a number that cannot be right, such as more shots on target than total shots.

Worked example (sample data in the sheet)

The player, club and opponents in the example are sample names, not real ones: "Sample Player", a right winger at "Stars FC (sample)", from 14 August to 8 November 2026.

  • Matches: 14 matches; the team won 7, drew 4 and lost 3, a win rate of 50%. The team scored 23 goals and conceded 14.
  • Minutes and output: the player played 1,140 minutes (81.4 per match), scored 9 goals and made 6 assists, so 15 goal contributions.
  • Per 90 minutes: 9 ÷ 1,140 × 90 = 0.71 goals, 0.47 assists, 1.18 contributions and 3.32 shots.
  • Accuracy: of 42 shots, 20 were on target, so shooting accuracy is 47.6% and shot-to-goal conversion 21.4%. He completed 313 of 398 passes, so passing accuracy is 78.6%.
  • Rating and discipline: his self-rating averages 6.93 out of 10, with 4 yellow cards and one red (in the match he rated 4 against "Sun FC").
  • Last 5 matches: 3 wins, a draw and a loss, that is 10 points out of 15, with 3 goals by the player and an average rating of 6.8, close to his season average.
  • Home and away: at home, 7 matches, the team won 6 and lost none, and the player scored 7 goals, made 4 assists and averaged 7.86. Away, 7 matches, his team won once and lost 3, and he scored 2 goals, made 2 assists and averaged 6.0.
  • Competitions: in the league, 10 matches, 7 goals and an average rating of 7.0; in the cup, 2 matches and 1 goal; in the friendly, 1 match and no goals. A "summer tournament" match (1 goal) was not written in Settings, so it counts in the totals and shows on the "competition not in Settings" row.

The reading: this player has far more impact at home than away, which is worth discussing with his coach. It comes from only 14 matches, so do not treat it as a final verdict.

How the numbers are worked out

  • Figure per 90 minutes = the figure ÷ total minutes played × 90.
  • Shooting accuracy = shots on target ÷ all shots. Passing accuracy = completed passes ÷ attempted passes.
  • Form of the last 5 matches goes by match date: three points for a win, one for a draw, none for a loss; if two dates are the same the higher row comes first.

Tips and limits

  • Log the match on the day; shots and passes are forgotten quickly.
  • Pick the competition from the list instead of typing it, or it will show under "competition not in Settings".
  • The rating is your own opinion of your performance, not an official rating. The sheet does not assess the player technically or medically and does not replace the coach, nor the sports doctor or dietitian in their fields.
  • The sheet is for one player and holds 300 matches and eight competitions. For a whole team you need a sheet per player or a custom system.
  • The numbers are tracking tools, not technical or medical advice, and a small sample of matches does not prove a trend.

Try it

Open the sheet and try it online, or download it for Excel. If you want a custom system for your team or academy with every player's stats and reports for the coach and parents, ask for it here.

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: football stats (1/3)Cheat sheet: football stats (2/3)Cheat sheet: football stats (3/3)
0 downloads · 3 pages

Questions this raises

What does "per 90 minutes" mean and why use it?

It is the figure ÷ total minutes played × 90. It is fair to a player who comes on as a substitute or plays fewer minutes; one goal in 45 minutes and one in 90 cannot be compared in raw numbers.

How do I know if a player's form is improving or dropping?

Open the Summary and look at "form of the last 5 matches": three points for a win and one for a draw, with the player's goals and average rating in them, and compare it with the season average.

Does the sheet replace a coach, a sports doctor or a dietitian?

No. The sheet counts the numbers you enter and does not assess the player technically or medically. The rating is your opinion of your performance; training, injury and nutrition decisions belong to the coach, the doctor and the dietitian.

Does it work for a whole team?

It is for one player. For a whole team you need a sheet per player, or a custom system that holds players and coaches in one place with permissions and reports.

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