The 2019/20 football season is now underway in England and my team Newcastle Utd play their first match tomorrow. As a long suffering toon fan, it has been 50 years since we last won a trophy and I am not expecting that drought to end this season. For supporters of other teams, your life will have been more fortunate but if you can’t remember the last time your team won a trophy then why not download my spreadsheet listing all trophy winners since 1889 to find out.
My spreadsheet English Club Records – Football v2.0 is up to date as of July 2019 and all data has been sourced from wikipedia. If you think there is an error then please do contact me or reply to this twitter feed to let me know.
The spreadsheet has a number of sheets which I will now explain in more detail. Please note that all sheets are protected but there is no password if you want to unprotect a sheet.
This sheet lists all winners of the 3 main domestic trophies in England i.e. Premier League (League Championship until 1992), FA Cup and League Cup. It starts in 1889 which is the year the League Championship started. The FA Cup began before that date but I have ignored that data. I have also shown the runner ups in all competitions as I think that can be useful in identifying the good teams of the past.
The sheet also shows any English club that won a European trophy or was a losing finalist in one of those competitions. Finally winners of various doubles are shown. Note Treble winners are not shown but can be spotted if they appear as multiple double winners in the same year e.g. Man City in 2019.
This sheet allows you to see which teams were the best in any time period. To do this, change the years shown in cells B1 (From year) and B2 (To year). You can then sort by any of the columns to find out which team was top.
For each team, I have counted how many times the team won the relevant trophy or was a runner up. Columns D to T should be obvious but I have added some further statistics in columns V to Z. These are explained below:
- Number of SUMMITS reached i.e. number of League Titles and European Cups/Champion Leagues won. For any club, these two competitions represent the summit of achievement that a club can reach and history generally looks at these when describing great teams of the past.
- Number of TROPHIES won. Silverware is what all fans crave but I am only considering the 6 trophies recorded in Data1889-2019England. Other minor & one-off trophies are not counted.
- Number of POINTS won. Not all trophies are equally regarded. At the same time, when considering GOATs, I do think consideration should be given to runner up spots. After all, in an FA Cup final between two equally matched teams, anything can happen and luck does play a part. For non-Summit trophies, I give 3 points to a winner and 1 point to a runner up. For summit trophies I double these points i.e. 6 points to a winner and 2 points to a runner up. However, you can change these points by editing the relevant yellow cells in row 1.
- Number of Wins & Runner ups which I denote as ALL.
- RECORD which is a summary of a team’s record using the format “Sw – Tw | Sr – Tr“. Sw is the number of summits reached and Tw is the number of other trophies won (excluding summits). Sr is the number of runner ups to summits and Tr is the number of runner ups to other trophies (excluding summits). So my team Newcastle Utd has an overall record of 4-7 | 2-8 since they’ve won 4 league titles, 6 FA Cups and a UEFA cup, were twice runner up in the league and have lost 8 cup finals.
This is a summary of the top teams for 3 different eras as below. All data comes from the RankingsEngland sheet but this sheet is not updated automatically.
- 1889-today (All Time): The football league was created in 1888 with Preston NE winning the first title in 1889.
- 1956-today (European Era): This is when European club football started with the European Cup in 1956 and the Cup Winners Cup & UEFA Cup (known as Fairs Cup then) in 1960. 1960 also saw the introduction of the League Cup.
- 1993-today (Modern Era): The Premier League era started in the 1992/93 season whilst at the same time, the European Cup morphed into the Champions League. In particular, the strongest leagues were allowed more than one entrant. Around the same time, the UEFA cup final switched to a straight final instead of a 2-legged affair in 1998 and the Cup Winners Cup was abolished in 1999.
By the way, you may find this earlier post of mine about GOATs (Greatest Of All Time) of interest.
This sheet lists the winners and runner ups from all countries to the 3 main trophies offered by UEFA i.e.
- Champions League – Started in 1956 and was known as the European Cup until 1993
- Europa League – Started in 1958 as the Fairs Cup, became the UEFA cup in 1972, switched a straight final instead of a 2-legged final in 1998 and then became the Europa League in 2010.
- Cup Winners Cup – Started in 1961 and was last played in 1999.
Like the RankingsEngland sheet, this sheet allows you to summarise European performance by club. The format of this sheet is slightly different to RankingsEngland but you should be able to figure out the differences. This sheet also summarises European performance by country as well. Note there are a lot of flags which are a legacy of a copy and paste from Wikipedia and are tiresome to delete!
This sheet is exactly the same as DATA1956-2019UEFAclubs except only countries are shown rather than clubs. As far as possible, I’ve used today’s countries rather than historical countries so it is Germany rather than East & West Germany and its Croatia, Serbia, etc rather than Yugoslavia.