Euro 2020 Stats Tracker
Includes match statistics from Sky Sports
--
Euro 2020 reached its finale on Sunday, with Italy crowned winners after defeating England (my nation!) in a penalty shootout. It meant the Three Lions’ 55 barren years without a major international trophy continues.
Yesterday was a sombre day, as we mourned, reflected and regretted what might have been the night before. Now though, it’s time to look back on—what still was—a wonderful tournament.
Allegiances aside — perhaps you’re a football statistical anorak who is curious about the numbers behind the tournament, or a spreadsheet fanatic who is interested in seeing the inner workings of a stats-based system.
Or maybe you’re both of those things — like me.
In any case, I wanted to show you my interactive stats tracker I created in Google Sheets.
Not only does it allow you to view the match results in a convenient layout, but it also aggregates the statistics so you can see which countries performed well in different areas.
Almost all the match data has been extracted from Sky Sports match reports. Given the tournament is over, it doesn’t matter so much now, but it does update automatically. I must caveat that though by saying almost, and you’ll find out why in a minute.
I am also giving you unfettered access to the workbook, so you can faff about with it as much as you wish. You can even make a few customisations of your own if you desire. All I would ask is you use it for personal use only.
Sheets Workbook
Download a copy of the Sheets workbook from the following link:
Worksheets
The backstage worksheets are colour-coded red. These are responsible for housing data and carrying out the nitty-gritty work. On the other hand, the green ones are the stage sheets so are visibly easier on the eye.
Let’s go through each one:
