Get ready for EURO 2024 with our interactive and user-friendly Excel schedule! Effortlessly track all the matches, results, and standings of the European Championship Finals with this meticulously crafted spreadsheet. No advanced Excel skills are needed to enjoy a seamless tournament experience.
Your All-in-One EURO 2024 Tracking Tool
EURO 2024 has concluded, but our Excel schedule remains a valuable resource for reviewing the tournament and planning for future events.
Website last updated: February 12, 2025
Interactive EURO 2024 Schedule
Completely free of charge and ad-free, this Excel schedule is designed with attention to detail for the ultimate EURO 2024 experience.
Last Update: 2025-01-20 (Version 1.8.16) Download
Effortless Updates: Simply Enter Match Results
Enjoy automatic updates throughout the tournament! Just input the match scores, and the Excel sheet handles everything else, from group standings to knockout stage progression.
★ NO EXCEL SKILLS REQUIRED ★
Compatibility Across Platforms:
This Euro 2024 Excel Sheet is compatible with a wide range of software, including:
- Microsoft Excel (Office 2007 and later versions)
- LibreOffice
- WPS Office on Android Tablets
- Free Office for the web (formerly Office Online)
- EXCEL on Apple MAC
Note for OpenOffice Users:
OpenOffice may encounter performance issues with the prediction worksheets due to complex formulas. For a smoother experience in OpenOffice, download a streamlined version without these prediction features: EURO 2024 schedule for OpenOffice
Explore “What If” Scenarios:
This Excel file allows you to delve into tournament simulations. Immediately see the impact of each result on group tables and the subsequent pairings in the Round of 16 as you enter match scores during the group stage.
Key Features of the EURO 2024 Excel Sheet
This Excel schedule is designed for ease of use and comprehensive tournament tracking:
- Automatic Group Standings Calculation: The sheet automatically calculates group tables, adhering to all official UEFA rules, including fair play rankings and UEFA European Qualifiers rankings.
- Qualified Third-Place Teams Determination: Effortlessly identifies and ranks qualified third-place teams based on UEFA criteria.
- Knockout Stage Placement: Automatically places qualified teams in the Round of 16, Semi-Finals, and Finals, following the UEFA assignment table for group third-placed teams.
- Direct Comparison Tables: Provides tables for direct comparisons between teams in case of ties.
- Language and Time Zone Customization: Choose your preferred language and adjust for your time zone for a personalized experience.
- Daily Schedule Overview: Offers a daily schedule for each tournament day, keeping you organized throughout EURO 2024.
- Visual Result Tracking: Games awaiting results are highlighted with a colored background for easy identification.
- Tie-breaker Indicators: Groups with unclear standings due to match results, requiring fair play or European Qualifiers rankings, are marked with a red dot •.
- Fair Play Rating Input: Option to manually input fair play ratings for precise tie-breaking.
- Qualified Teams Highlighting: Teams advancing to the Round of 16 are visually highlighted for quick recognition.
- Penalty Shoot-out Special Case: Handles the special case of a penalty shoot-out in the last group match if teams are tied on all criteria.
- Print-Optimized Match Plan: The ‘Print’ sheet offers a printer-friendly match plan formatted for two A4 pages in landscape orientation. The ‘Daily schedule’ worksheet is also print-ready.
Enhance the Experience: Betting Match Results
For friendly competitions with family or friends, reveal the hidden worksheets ‘Predictions_1’, ‘Predictions_2’, ‘Predictions_Ranking_1’, ‘Predictions_Ranking_2’, and ‘PrSettings’ to incorporate match result betting features.
Learn more about setting up betting pools: ▸Betting match results.
Download 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 list was set. Download the schedule in PDF format for easy viewing and sharing. EURO_2024_Schedule.pdf EURO_2024_Schedule_A3.pdf
Additional Downloadable Resources
Tutorial: Create Your Own EURO Schedule in Excel EURO_Tutorial_1.5_en.pdf (Last updated: 2025-02-12)
Excel Files for the Tutorial EURO_Tut_1.5_en.zip (Last updated: 2025-01-18)
This tutorial includes ten Excel files representing project milestones across ten chapters, allowing you to start at any point or skip sections as needed.
Download the EURO 2020/2021 Schedule: EURO 2020/2021 schedule
Explore the Women’s EURO 2025 Schedule: Women’s EURO 2025
Discover More Tournament Schedules: More
EURO 2024 Champion: Spain
EURO 2024 culminated on July 14, 2024, with Spain’s victory over England (2-1) in the final held at Berlin’s Olympic Stadium. Spain emerged as the new European Champion.
EURO 2024 Qualification Information
Host nation Germany automatically qualified for EURO 2024. Russia was excluded from the tournament. Qualification group matches took place from March 23rd to November 21st, 2023. Play-offs on March 21st and 26th, 2024, determined the final three participants: Poland, Ukraine, and Georgia.
The group draw on December 2nd finalized the group stage composition:
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
Understanding the Rules for Round of 16 Qualification
The qualification rules for the Round of 16 are detailed. Typically, the top two teams from each group, along with the four best third-placed teams, advance. Tie-breakers include fair play ratings (penalties for yellow and red cards) and UEFA European Qualifiers rankings.
The UEFA overall European Qualifiers rankings and even a drawing of lots are considered in specific tie situations, especially since host nation Germany isn’t included in the European Qualifiers rankings. Penalty shoot-outs in the final group match are also possible under certain tie conditions. See Example penalty shoot-out
Crucially, direct comparison results take precedence over goal difference and total goals scored in group matches when teams are tied. A team can rank higher despite a worse goal difference due to head-to-head results. See Example direct comparison
Group Ranking Criteria (UEFA Regulations Article 20):
- Higher points in all group matches.
- Higher points in direct encounters.
- Superior goal difference in direct encounters.
- More goals scored in direct encounters.
- Repeat criteria 2-4 for teams still tied.
- Superior goal difference in all group matches.
- More goals scored in all group matches.
- Higher number of wins in all group matches (third-placed teams only).
- Lower disciplinary points (red card = 3 points, yellow card = 1 point, expulsion = 3 points).
- Position in UEFA European Qualifiers rankings.
Additional Rule: If two teams are tied after criteria 1-7 in the last group match, and no other team has the same points, a penalty shoot-out determines their rank, overriding criteria 9 and 10.
Note: Criterion 8 only applies when comparing third-placed teams. Criteria 3, 4, and 5 are relevant when more than two teams are tied.
To determine the best four third-placed teams, criteria 1 and 6-10 are used. Criteria 2-5 are not applicable for third-placed teams.
The opponents for the winners of Groups B, C, E, and F in the Round of 16 depend on the groups from which the third-placed teams qualify. UEFA has defined 15 possible scenarios to ensure teams from the same group don’t face each other in the Round of 16. View allocation table
This Excel schedule automatically incorporates all these UEFA criteria and regulations.
Enjoy using the EURO 2024 Excel schedule!
For questions or suggestions: [email protected]
Further Information
More Excel Solutions
Excel functions SORT, SORTBY, FILTER, and UNIQUE for older Excel versions (2007-2019): Functions for Excel 2007 – Excel 2019
Detailed Tutorial on Array Formulas: Tutorial “Array formulas”
Privacy Policy
This website respects your privacy, does not collect personal data, and does not use cookies.
If you wish to support our work, you can donate here: