skip to Main Content

EURO 2020 Qualifiers Template

4.75 (8 reviews)

Euro 2020 Qualifiers Template to track fixtures, playoffs and groups! Just put the scores and UEFA teams will be ranked automatically!

Learn more about License Types

Buy Modifiable Version Buy Modifiable Version



The UEFA Euro 2020 will start on June 12, 2020 and the matches to qualify the teams have already started. The qualification started on March 2019 and will end in March 2020 to determine the 24 teams which will have the right to join Euro 2020 Qualifiers. UEFA’s 55 nations have been split into 10 groups which the first five groups (A to E) consist of 5 teams and the second five groups consist of 6 teams in each group. The best two teams in each group will have the right to join the UEFA’s Euro 2020 Championship.


Finally it will end up with the twenty teams from the group matches and the four teams from playoff matches on 31 March 2020.

EURO 2020 Qualifiers Template Features:

Euro 2020 Qualifiers Template is a tool to track the details of the past UEFA European Championships, all fixture and the group matches. Once you enter the match scores, champions of each group and the teams will be ranked according to their points. If both teams have same points, the toll will rank based on their average. Even if their average will be same again the result will be depending on their Goal Scores and Away Goals.

The template consists of 5 sections:

  • Dashboard
  • All Fixtures
  • Groups
  • Play-Offs
  • History

Now, let’s dive into each of them!

Dashboard: You can switch between sheets with the navigation buttons.

All Fixtures: contains the match details. Who is playing, which group they are in and when are playing. If you would like to see other days fixtures, just click on the drop-down and select the Match Day of Groups.


Groups: Put the scores of each team. Once you put in the data of goals, the table above will adjust itself automatically and will rank according to the Point, Average, Goals For and Away Goals and UEFA Euro2020 Championship Standards.

You may reach other groups by clicking on the buttons above. After that apply the same procedure for the other groups to display the qualifiers.


Play-offs: shows you the champions of each group and play-off winners.

If two teams reach the same scores in two separate matches (2-1,2-1), the result of the match will be determined by penalties. You can increase the number of goals of the winning team in the penalties by one unit so that the correct team can reach the “Winner” cell by formulation.

History: This section gives details about UEFA European Championship Host Country, Final, Team of the Tournament and Top Scorers of previous years.

Features Summary:

  • Easy to fill European Soccer Template
  • Includes: Fixtures, Groups, Play-Offs, History
  • Full Print Ready
  • Informational notes included
  • No installation needed. Ready to use.
  • Works both on Mac and Windows
  • Compatible with Excel 2007 and later versions
  • Does not include any VBA macros

**This EURO 2020 Qualifiers Excel Template compiles the information which is officially available at You can check all the soccer news, fixtures, scores & results there. Someka is not associated with Union of European Football Associations.

This is ready-to-use Excel Template and provided as is. If you need customization on your reports or need more complex templates, please refer to our custom services.


Watch the video below to see the template in action! Presentantation also includes usage notes, explanations and tips & tricks about the template.



8 reviews for EURO 2020 Qualifiers Template

  1. franci

    Not bad, but I Wish it were EURO 2020 template…

  2. Tahir

    My question is, how to change the names of teams, that is, national teams, and whether the problem or requirement is knowledge of excel programming, a tournament with 4 teams in a group, the rest is not a problem.
    Thank you

    • Someka

      Hi Tahir,

      When you unlock the template with the password you received via download email, you can modify/edit the template according to your needs. You don’t need to have professional Excel knowledge to do that. We recommend just be careful to not delete cells that contain formulas.

      Hope that helps!

  3. Donald T Pidgeon Jr

    I have downloaded the updated template and it is perfect. Thank you very much.


  4. dan hritac

    Thank for this product, very good.

  5. Donald Pidgeon Jr

    Good Day.

    I don’t know if you received my previous e-mail regarding this spreadsheet, but it looks like there is a change to the playoff format for EURO 2020. The playoffs consist of four groups of four teams each. The winners of the two semi-final games in each of the four groups will meet and the winners of those games will qualify for EURO 2020.

    Please let me know if you have any questions or need any more information. Thank you very much for your assistance in this matter.


    • Someka

      Hi Donald,

      First of all, we really appreciate that you’ve taken your time to write this review and share it with us!
      We already get contact with you via e-mail regarding your suggestion. Thanks to you Don, we have update the template!

  6. Mark

    Excellent Template it shows everything you need to know about the competition and easy to use.


    Good and easy to use

  8. Antoine

    Thank for this product

Leave a customer review

Your email address will not be published. Required fields are marked *