Are you looking for UEFA EURO 2020 football final tournament schedule in Microsoft Excel format? Then you can download and use this spreadsheet that will show full schedule of the tournament. There are also score boxes inside the spreadsheet where you can fill scores from match results.
Original Euro 2020 tournament will be held in 12 cities in 12 European countries from 12 June to 12 July 2020. Due to pandemic situation, it is postponed to be held on 2021, from 11 June to 11 July.
Also, for the first time, VAR or Video Assistant referee system will be implemented to analyze any questionable incidents.
There are 24 countries that will participate after they qualified from their respective qualification groups. There are several rules applied to distribute teams in their respective groups since matches will be played in 12 European countries where hosts that advanced to the final tournament will play their matches in their homes.
|Group A||Group B||Group C|
|Group D||Group E||Group F|
In this new tournament format (the second 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 2020 Schedule and Scoresheet
Excel Euro 2020/2021 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 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 2020 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.
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 2020 final tournament. Also, there will be Google Sheets and Excel versions.
Euro 2020 Fixtures V2.43 - Model 1 - Free Version (524.7 KiB, 26,092 hits)
Euro 2020 Fixtures V2.43 - Model 2 - Free Version (246.3 KiB, 11,114 hits)
Euro 2020 Fixtures with Top Scorer V2.49 - Free Version (484.2 KiB, 5,915 hits)
It should be fun playing prediction game with your friends and relatives. You can use the Euro 2020 Predictor Game spreadsheet for that purpose. There are plenty of options in that spreadsheet that will allow you set your preferred regulation to make the game more attractive.