Free Excel template · Excel for coaches and sports teams

Free league standings template for Excel

For league organizers and team parents who post the table each week. List every fixture once with the home and away team; when a game is played, type the two scores. The standings work out games played, wins, draws, losses, goals for and against, goal difference, points and rank for every team. Unplayed games are ignored until they have a score. Points for a win, draw and loss are input cells, so the sheet fits soccer (3-1-0), hockey or any league with its own rules.

cellwise-league-standings-template.xlsxExcel workbook · 5.0 KB · works in Excel, Google Sheets, Numbers and LibreOffice · no signup

Download free template

Preview and try it

This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.

	A	B	C	D	E	G	H	I	J	K	L
1	Date	Home	Away	Home score	Away score	Team	Played	Won	Drawn	Lost	Goals for
2	Sep 12, 2026	Hawks	Lions	3	1	Hawks	4	3	1	0	8
3	Sep 12, 2026	Comets	Rangers	2	2	Lions	4	2	0	2	6
4	Sep 12, 2026	Storm	Wolves	0	1	Comets	4	1	1	2	5
5	Sep 19, 2026	Lions	Comets	1	0	Rangers	4	1	2	1	8
6	Sep 19, 2026	Rangers	Storm	4	2	Storm	4	1	0	3	6
7	Sep 19, 2026	Wolves	Hawks	2	2	Wolves	4	1	2	1	4
8	Sep 26, 2026	Hawks	Comets	1	0
9	Sep 26, 2026	Lions	Storm	2	3
10	Sep 26, 2026	Rangers	Wolves	1	1	Leader	Hawks
11	Oct 3, 2026	Comets	Storm	3	1	Games left to play	3
12	Oct 3, 2026	Wolves	Lions	0	2	Goals per game	3.08
13	Oct 3, 2026	Hawks	Rangers	2	1
14	Oct 10, 2026	Storm	Hawks
15	Oct 10, 2026	Lions	Rangers
16	Oct 10, 2026	Comets	Wolves

How the formulas work

Games played, counting only games with a score

H2=COUNTIFS($B$2:$B$41,G2,$D$2:$D$41,"<>")+COUNTIFS($C$2:$C$41,G2,$E$2:$E$41,"<>")

A team plays at home or away, so count both columns. The "<>" condition means "not empty", which skips fixtures that are scheduled but have no score yet. That is why the Hawks show 4 played even though their game on October 10 is already listed.

Wins from home and away games

=SUMPRODUCT(($B$2:$B$41=G2)*($D$2:$D$41<>"")*($D$2:$D$41>$E$2:$E$41))+SUMPRODUCT(($C$2:$C$41=G2)*($E$2:$E$41<>"")*($E$2:$E$41>$D$2:$D$41))

Each test is 1 or 0 for every row. The first SUMPRODUCT counts rows where the team is at home, the game has a score and the home score is higher; the second does the same for away games. Draws (J2) use the same idea with an equal score, and losses are simply played minus won minus drawn.

Goals for and against

L2=SUMIF($B$2:$B$41,G2,$D$2:$D$41)+SUMIF($C$2:$C$41,G2,$E$2:$E$41)

Goals for are the home score when the team is at home plus the away score when it is away. Goals against (M2) swap the score columns. Goal difference is for minus against.

Points from your league's rules

O2=I2*$S$1+J2*$S$2+K2*$S$3

Wins, draws and losses multiplied by the points in S1:S3. Change those three cells if your league gives 2 points for a win, or a point for a loss.

Rank with tiebreakers

=COUNTIF($O$2:$O$7,">"&O2)+COUNTIFS($O$2:$O$7,O2,$N$2:$N$7,">"&N2)+COUNTIFS($O$2:$O$7,O2,$N$2:$N$7,N2,$L$2:$L$7,">"&L2)+1

A team's rank is one more than the number of teams ahead of it. The three parts count teams with more points, teams level on points with a better goal difference, and teams level on both with more goals scored. In the sample the Rangers and Wolves both have 5 points; the Rangers rank 3rd on goal difference (+1 against -1). Teams level on all three share a rank. Leagues use different tiebreakers, so check your rules and swap the columns to match.

Make it yours

Spell team names exactly the same in the fixtures and the standings. "Lions" and "Lions " (with a trailing space) are different teams to COUNTIFS; a Data Validation list on columns B and C prevents it.
Add the whole season's fixtures at the start and leave the scores empty. Games played, Games left to play and the table all stay right as scores come in.
To show the table in rank order, copy the standings and paste values, then sort by Rank. In Excel 365, =SORT(G2:P7,10,1) shows a live sorted copy elsewhere on the sheet.
The ranges run to row 41, room for 40 games. For a longer season, insert rows above row 41 and every formula grows with them.
For a league with more teams, insert rows inside the standings (above row 7) and fill the formulas down so the Rank ranges include the new teams.

FAQ

How do I make a league table in Excel?

Keep one row per game with Home, Away, Home score and Away score. For each team, count wins with SUMPRODUCT over both the home and away columns, add goals with SUMIF, work out points from wins and draws, and rank with COUNTIF. This template has all of it built in.

How do I rank teams with a tiebreaker in Excel?

Add up the teams that are ahead: COUNTIF for more points, plus COUNTIFS for equal points and a better goal difference, plus 1. Add another COUNTIFS for each extra tiebreaker your league uses.

Why does a scheduled game not count in the table?

Every formula checks that the score cell is not empty, so a game only counts once both scores are typed. Type 0 for a team that did not score; leaving it empty means the game has not been played.

Functions used

Related guides

More free templates

Updated November 2, 2026