Euro 2024 Tabellone: Download Your Free Excel Schedule for the Tournament

Interactive EURO 2024 schedule. Free of charge – no annoying advertising – created with attention to detail.

Last Update: 2025-01-20 (Version 1.8.16) Download

Just enter game results – everything else is automatic!

★ NO EXCEL SKILLS REQUIRED ★

Click to view full picture

This comprehensive Excel schedule is compatible with:

  • Microsoft Excel (all versions from Office 2007 onwards)
  • LibreOffice
  • WPS Office on Android Tablets
  • Free Office for the web (formerly Office Online)
  • EXCEL on Apple MAC

For OpenOffice users, please note that due to the complexity of formulas in the ‘Predictions_1’ and ‘Predictions_2’ worksheets, OpenOffice may experience loading issues. If you prefer to use OpenOffice, a streamlined version without prediction worksheets is available: EURO 2024 schedule for OpenOffice

Utilize this Excel file to explore “What if…” scenarios and delve into tournament possibilities. Immediately observe the impact of each match result on group standings and the knockout stage pairings as you input scores during the group phase.

Usage Instructions

This Excel schedule is fully unlocked and requires no password. Feel free to use it without limitations, modify it to suit your needs, and reveal any hidden tables for complete customization.

Key Features of the Excel Spreadsheet

  • Automated Group Standings: Calculates group tables automatically, adhering to all official UEFA regulations, including fair play rankings and UEFA European Qualifiers overall rankings.
  • Automatic Qualification for Third-Place Teams: Intelligently determines which third-placed teams qualify for the knockout stage.
  • Knockout Stage Automation: Automatically populates the Round of 16, Quarter-Finals, Semi-Finals, and Final brackets based on group results and UEFA’s predefined pairings for third-placed teams.
  • Direct Comparison Tables: Provides tables specifically for direct comparison scenarios between tied teams, crucial for understanding tie-breaker rules.
  • Language Customization: Offers national language selection and the option to incorporate your own language for a personalized experience.
  • Time Zone Adjustment: Features time zone selection to ensure all match times are displayed in your local time.
  • Daily Match Schedule: Presents a clear daily schedule for each day of the tournament for easy planning.
  • Visual Result Tracking: Uses color-coded backgrounds to highlight matches that have been played but are missing results, making it easy to spot incomplete data.
  • Tie-breaker Indicators: Groups with unresolved rankings due to match outcomes, relying on fair play or European Qualifiers rankings, are clearly marked with a red dot •.
  • Fair Play Input: Allows manual entry of fair play ratings, enabling precise tie-breaker calculations.
  • Qualified Teams Highlighting: Teams that have secured a spot in the Round of 16 are visually highlighted for quick identification.
  • Penalty Shoot-out Special Case: Handles the specific scenario of a penalty shoot-out in the final group match to resolve a tie between two teams ranked equally.
  • Print-Optimized Match Plan: Includes a ‘Print’ sheet with a printer-friendly match plan, formatted for two A4 pages in landscape orientation, alongside a printable ‘Daily schedule’ worksheet.

Betting on Match Results

Enhance your EURO 2024 experience by engaging in friendly match result betting competitions with family or friends. Simply unhide the worksheets ‘Predictions_1’, ‘Predictions_2’, ‘Predictions_Ranking_1’, ‘Predictions_Ranking_2’, and ‘PrSettings’ to activate betting features.

For more detailed instructions, please visit: ▸Betting match results.

EURO 2024 Schedule in PDF Format: Following the group draw on December 2, 2023, and the play-offs in March 2024, the final EURO 2024 participant lineup is complete. EURO_2024_Schedule.pdf EURO_2024_Schedule_A3.pdf

Additional Downloads

Tutorial: Create Your Own EURO Schedule in Excel EURO_Tutorial_1.5_en.pdf (Last updated: 2025-02-12)

Excel Files for Tutorial EURO_Tut_1.5_en.zip (Last updated: 2025-01-18)

This tutorial is supported by ten Excel files, each representing a stage in the tutorial, allowing you to begin at any chapter or skip sections as needed.

Interested in past tournaments? Download the complete EURO 2020/2021 schedule here: EURO 2020/2021 schedule

Explore information and an EXCEL schedule for the upcoming Women’s EURO 2025. Looking for a top-tier tournament schedule for indoor events? More

Spain Crowned European Champions

EURO 2024 culminated on July 14, 2024, with a final match in Berlin’s Olympic Stadium between Spain and England.

Spain emerged victorious, securing the European Championship title by defeating England 2-1 in the final.

EURO 2024 Qualification Insights

Host nation Germany qualified automatically. Russia was barred from participating in the tournament.

Qualifying group matches took place from March 23 to November 21, 2023. The final three participants—Poland, Ukraine, and Georgia—were determined through play-offs on March 21 and 26, 2024.

The group stage draw on December 2, allocated teams as follows:

Group A: Germany, Scotland, Hungary, Switzerland
Group B: Spain, Croatia, Italy, Albania
Group C: Slovenia, Denmark, Serbia, England
Group D: Poland, Netherlands, Austria, France
Group E: Belgium, Slovakia, Romania, Ukraine
Group F: Türkiye, Georgia, Portugal, Czechia

More information on qualification

Decoding the Round of 16 Qualification Rules

The qualification process for the Round of 16 maintains its complexity. Group winners, runners-up, and the top four third-placed teams advance. Tie-breakers include fair play points (Yellow card = -1 point, Yellow/Red card = -3 points, Red card = -3 points) and the UEFA European Qualifiers overall rankings. As host nation Germany isn’t part of the qualifiers ranking, a drawing of lots is possible if a tie persists across all criteria, including fair play. Penalty shoot-outs in the last group match are also a potential tie-breaker in specific scenarios. See Penalty shoot-out example

Crucially, direct head-to-head results take precedence over goal difference and goals scored in all group matches in tie-breaking. A team can rank higher despite a poorer overall goal difference due to head-to-head performance. – See Direct comparison example

In summary, group rankings are determined by Article 20 of the UEFA regulations using these criteria in order:

  1. Higher points in all group matches
  2. Higher points in head-to-head matches
  3. Superior goal difference in head-to-head matches
  4. Higher number of goals scored in head-to-head matches
  5. Repeat criteria 2-4 for teams still tied
  6. Superior goal difference in all group matches
  7. Higher number of goals scored in all group matches
  8. Higher number of wins in all group matches (third-placed teams comparison only)
  9. Lower disciplinary points in all group matches (Red card = 3 points, Yellow card = 1 point, expulsion for two yellow cards = 3 points)
  10. Position in the UEFA European Qualifiers overall rankings

Additional tie-breaker: If two teams are tied after criteria 1-7 at the end of their last group match, and no other team in the group has the same points, a penalty shoot-out, not criteria 9 and 10, will decide their rank.

Note: Criterion 8 (number of wins) only applies when comparing third-placed teams because if teams are tied on points within a group after criteria 1-7, they will also have the same number of wins.

Criteria 3, 4, and 5 are relevant when more than two teams are tied on points. Direct comparisons (criteria 2-4) are then used amongst the tied teams. If teams remain indistinguishable after this direct comparison, criteria 6-10 are applied.

To rank the four best third-placed teams, criteria 1 and 6-10 are used across all six groups. Criteria 2-5 are not applicable as there are no head-to-head matches between third-placed teams from different groups.

The winners of Groups B, C, E, and F will face a third-placed team in the Round of 16. The specific third-placed team opponent depends on which groups the four qualifying third-placed teams come from. UEFA has defined 15 possible scenarios to ensure Round of 16 opponents are not from the same group. View allocation table

This Excel schedule automatically manages all UEFA criteria and regulations.

Enjoy using the Excel schedule!

For questions or suggestions, please contact: [email protected]

Further Information

More Excel Solutions

Excel functions SORT, SORTBY, FILTER, and UNIQUE are now available for Excel 2007-Excel 2019 Functions for Excel 2007-Excel 2019

Detailed guide to array formulas: Tutorial “Array formulas”

Privacy Policy

This website does not collect personal data and does not use cookies.

Imprint

If you wish to support this work, donations are appreciated:

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

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