Are you looking for UEFA EURO 2024 football final tournament schedule with scoresheet feature in Microsoft Excel format? If the answer is yes, then you can download and use this Excel spreadsheet that will show full schedule of the tournament.
It has score boxes inside the spreadsheet where you can fill scores from match results. You can use it as your prediction spreadsheet as well. You can type your own score and see how the standings will be adjusted before you type the actual scores.
UEFA Euro 2024 will be held in Germany from June 14 to July 14, 2024. Hosted in one nation only this time.
Tournament Participants
There are 24 countries that will participate after they qualified from their respective qualification groups and playoff matches. UEFA divided this teams into 6 groups. Here is the list.
| Group A | Group B | Group C |
| Germany | Spain | England |
| Hungary | Albania | Denmark |
| Scotland | Croatia | Slovenia |
| Switzerland | Italy | Serbia |
| Group D | Group E | Group F |
| France | Belgium | Portugal |
| Netherlands | Romania | Turkey |
| Austria | Slovakia | Czech Republic |
| Poland | Ukraine | Georgia |
Tournament Format
In this new tournament format (the third format after 2016), 24 teams will be divided into 6 groups where top 2 of each groups will advance automatically plus best 4 third-placed teams ranked from all groups. With this new rule, knock out matches are becoming more unpredictable because 4 group winners will face 4 third-placed teams which could come from 3 different groups. After all group matches are completed and some qualified teams have to be decided (it is very.. very.. rare) until the end of tie-breaker rule, you can switch team order in group standing manually by typing it directly in group standing table.
Using this Microsoft Excel spreadsheet will eliminate your confusion on this complicated tie-breaker regulation. There are built-in formulas inside this spreadsheet that will compute them automatically.
Setting Up Euro 2024 Schedule and Scoresheet
Menu
Excel Euro 2024 Schedule and Scoresheet template has a menu in front to help you see latest and next schedule quickly. Also, you can change timezone and language in this front panel. To update scores, you can click on Update Scores button to bring you to score worksheet.
Set Time Zone
Set time zone to suit your own timezone. Date and time in this spreadsheet will follow accordingly. Default is London. You can set it by adding or subtracting time from London time.
Set Language
Set language to your own language. There are only 4 languages available. Use language translation tool to translate all the English words.
You might be aware as well that different groups are having different colors. It is used in knock out round as well. Knock out brackets will be filled with qualified teams and those teams will have respective group colors as its background. It will ease you track from which groups that the teams are qualified from.
How to Use Euro 2024 Schedule and Scoresheet
Update Scores in Group Matches
This Microsoft Excel spreadsheet has score fields to update score results. Input them into respective score fields in Group Matches and Knock Out Round worksheets.
There are formulas inside this spreadsheet that will adjust group ranks anytime you update particular scores. By the end of group matches, 16 teams will be placed in Knock Out brackets automatically where you can continue to update the scores.
Update Scores in Knock Out Rounds
Score fields are arranged similar with group stages. You shouldn’t have problem to continue typing actual scores, including penalty shoot out boxes that will be shown automatically if full time match ended draw.
Available Models
There are two spreadsheet models with schedule and scoresheet and one model with top scorer feature that you can download. Schedule and scoresheet model 1 has automated flag arrangement in Knock Out rounds while model 2 doesn’t have that feature.
We also prepare other spreadsheets that should accompany you to watch this Euro 2024 final tournament. Also, there will be Google Sheets and Excel versions.
These are spreadsheets for Euro 2024 tournament. All teams have been set by March 26, 2024.
Euro 2024 Schedule - Model 1 V2.49 (updated 6/27) (474.2 KiB, 5,124 hits)
Euro 2024 Schedule - Model 2 V2.5 (updated 6/27) (196.7 KiB, 2,589 hits)
If you want to see schedule, updating scoresheet as well as updating its goal scorers to track top scorer of the tournament, you can download Euro 2024 schedule with top scorer tracker below. It contains not official squads yet from all 24 teams. You can update the squads by yourself or redownload it again after official squads are released by all 24 teams.
Euro 2024 Schedule with Top Scorer V2.57 (420.1 KiB, 1,461 hits)
It should be fun playing prediction game with your friends and relatives. You can use the Euro 2024 Predictor Game spreadsheet for that purpose. There are plenty of options in that spreadsheet that will allow you to set your preferred regulation to make the game more attractive.
