The 2024 UEFA European Football Championship, or simply Euro 2024, is scheduled to be held in Germany. Start from 14 June 2024, only one country will become a host for this four yearly event. It means, qualified teams can focus their logistics to cities in one country. It should minimize the cost while moving between cities when particular teams advance to knock out rounds.
You can find official Euro 2024 schedule in UEFA.com official site. But, if you are looking for a schedule with Excel of Googlesheets format, you can get it below. There are formulas inside that spreadsheet that will help you automate group standing arrangement. You know, the tie breaker regulation for this Euro 2024 final tournament is very complicated. No fixed pairing matches can be set in Knock Out round matches until all group matches are completed.
It depends on top 4 of 3rd place team from each group.
As usual, there are 6 groups. Each group consists of 4 teams. 24 teams will fight for 16 places in knock out rounds. The tie breaker will regulate group standings. Two top teams from each group plus 4 best 3rd-placed teams will advance.
Who Has Qualified for Euro 2024?
There are 21 teams, including Germany as the host, have qualified before March 26, 2024. Other 3 teams are finally revealed by March 26 after Poland defeated Wales, Ukraine defeated Iceland and Georgia defeated Greece. Final 24 teams are: Albania, Austria, Belgium, Croatia, Czech Republic, Denmark, England, France, Germany, Hungary, Italy, Netherlands, Portugal, Romania, Scotland, Serbia, Slovakia, Slovenia, Spain, Switzerland, Turkey, Poland, Ukraine and Georgia.
Euro 2024 Final Tournament Scoresheet
Use this template as scoresheet. Update the score by typing scores inside respective score fields. You don’t have to worry about adjusting their ranks. It is automatic. Also, you can play with this spreadsheet before filling them with actual scores. Especially when there is one match left for each team in each group where final results does matter.
How to Use Euro 2024 Schedule Spreadsheet
This is a one page fixtures and scoresheet. There are two big parts as you can see in image above. The first part is group stages part. There are 36 matches. There are 6 groups. Group winners and runners will qualify automatically to the knock out rounds. Four best 3rd-placed will accompany them to round up 16 contestants in round of 16.
Tie-breaker regulation for either group standings or four best 3rd-placed is quite complicated. But, you don’t have to worry about that. This spreadsheet has been equipped with all formulas that will adjust group standings and place all knock out teams in correct bracket automatically.
To use this Euro 2024 is very simple. Type prediction (you can play around with your own scores) or actual scores in white boxes next to country names. Repeat above steps until you fill all group matches score fields. Group standings will be adjusted accordingly
Excel formulas will place 16 teams who will advance to the second round automatically.
In the knock out round, do similar steps. And do not forget to fill penalty shoot out results if some matches have to end in that way.
Euro 2024 champion, that should be crowned by 14th July, should be shown in Champion box.
Here is the file
If you are looking another schedule template where you can track top scorer of the tournament, you can also try this file below. It has different layout but similar engine with above template.
Have fun.
