Questions? Comments? Please leave a comment below.
e-mail: excel4soccer@gmail.com
56 comments
Is there an error with league one? The teams don’t seem to be in correct league order just alphabetical. Tried on couple of devices just incase it was my end.
Cool spreadsheets though well done and they saved me a bit of time tonight trying scrape some data together.
Really like the spreadsheet, but there is an error in a couple of cells that is screwing the whole thing up
1. Missing ref in Man U cell on Fixtures_by_Date, so doesn’t pull through from fixtures.
2. Chelsea Ref is $k13, when it should be $K12
I could easily fix for myself if you could release me your password ?
Really brilliant page not to mention the detail in the spreadsheets. Major thanks for all the hard work and effort into this and to make it available is just ….. well way more than fantastic!
Hi
English league 1 & Championship league has a fault in the table, Leeds have drawn at the weekend but in the table they’ve won & got 3 points. Same fault on League 1
Premier League fans are waiting patiently for the interactive League Table. Please can you release it for us. Thanks for your hard work and kindness for sharing such a powerful tool.
Please please let us have it.
Hi, with 538 no longer updating their SPI rankings, are you still planning to release Monte Carlo sims for the top 5 Euro leagues this year? Thank you!
The Monte Carlo sims use the SPI data from 538. Since 538 is no longer updating their SPI rankings, it does not make sense for me to publish the Monte Carlo sims anymore.
I will still post the non-macro score league tables. The new tables will be posted in the next few days.
Hello. I appreciate your commitment to soccer for Excel. If you have some spare times, could you make the “Eredivisie” fixture file beginning 23-24 season? Thank you for your help.
Can I have the password to allow me to manually put in scores for the Premier League, please? Is it the same for all leagues as I like the French and German set ups too.
Thanks
David
You can manually type in scores. You do it on the “fixtures” tab. Once the scores are entered on the “fixtures” tab, the scores in the tabs will update automatically.
Hi, do you have the 20/21 Premier league stats for download. Looking at what’s available on your site, the match stats are for 21/22 and 22/23. Thanking you in advance
Hi, i would like to ask if you can provide excel tables (like the big5 ones) for other leagues such as Eredivisie, Jupiler Pro League, Austria Bundesliga, Denmark Superligaen, Primeira Liga, Switzerland – Syper league.
Hi, why cant the ‘likey home/away goals’ columns not be manually inputted for the remaining fixtures and also the result percentage not correct itself?
Hi my friend would you make it for me Monte Carlo simulation Prediction excel which is not VBA excel if no otherwise for example slover . I pay for it if you do $36,00 i pay you please write back and don’t and don’t delete it comment.
Thank you for sharing the simulation tool and the forecasts for the 2022 Qatar world cup!
I have a question for you. Are the FPI’s for all teams updated as for july, 2022? If not, what is the last update you’ve worked with?
Many thanks again!
As far as I can tell, the SPI numbers change from time to time. It’s hard to tell how frequently they update the SPI values for the international teams. I don’t they are updated in July 2022.
On the other hand, the SPI values of the club teams are updated daily by fivethirtyeight.com.
This is superb. I done something similar (nowhere as near as fantastic as this) for my local lcub (Sunderland, Lg 1), and our nearest 6 rivials. Hopefully, we’ll get promoted. Any idea when you will release 2022-23 Fixtures – I will need to make some additions like this year. Cant wait to see it.. WONDERFUL WONDERFUL work!
Hello! I really appreciated your job! I’m writing to ask if you have the spreadsheet for others European Leagues such as Eredivisie, Belgian Pro League and Austrian Bundesliga…thanks in advance 🙂
Thanks! If there are enough interest from the community, I can expand the spreadsheets to cover more European Leagues. Please check back in a few months.
Hi, thank you for posting UCL and UEL monte carlo sims! I had a question on the UCL MC sim, particularly with Group B. The model seems to dislike Atletico Madrid disproportionately than it should even after I adjust their SPI ratings higher and their opponents lower. Usually they are one of two teams in the group to finish w/ a positive goal differential but they still don’t finish in the top 2. Is there a calculation error going on with them? Thank you
I assume you are referring to the interactive league tables.
The past scores are stored in a hidden tab “fixtures_tmp”. “fixtures_tmp” is not password protected. You can either delete or change the “home goal” and “away goal” columns to change the results of past games.
Hello, I am interested in your file from the other website “Premier League Soccer Data In Excel”, but the download is no longer available, would you be so kind as to send me the file to my e-mail address? If any payment is required, just let me know.
At this point, the plan is to support the same leagues as last season: Bundesliga, Serie A, French Ligue 1 and La Liga. The league tables will be published after Euro2020.
Do you have the Free Download Interactive Premier League Table in Excel for 21-22 league period? if I have the files from last season , how can I change the 3 new teams in this season (Watford, Brenford, Norwich City)
Is there an error with league one? The teams don’t seem to be in correct league order just alphabetical. Tried on couple of devices just incase it was my end.
Cool spreadsheets though well done and they saved me a bit of time tonight trying scrape some data together.
Hi Dave,
This is indeed an error. Thank you for reporting it. Please download the latest League One Table (2023-09-11 version).
Hey,
Thanks and no worries
Hi!
Just curious, have you thought about making MLS tables for next years season?
Hi,
My previous comment was removed.
When can we expect the next premier league player stat update?
Love the excel!
Can we expect weekly updates for the premier league excel and when do you upload it to the page?
Really like the spreadsheet, but there is an error in a couple of cells that is screwing the whole thing up
1. Missing ref in Man U cell on Fixtures_by_Date, so doesn’t pull through from fixtures.
2. Chelsea Ref is $k13, when it should be $K12
I could easily fix for myself if you could release me your password ?
I checked. My version doesn’t have this problem. Please download a fresh version from the website
Really brilliant page not to mention the detail in the spreadsheets. Major thanks for all the hard work and effort into this and to make it available is just ….. well way more than fantastic!
Hi
English league 1 & Championship league has a fault in the table, Leeds have drawn at the weekend but in the table they’ve won & got 3 points. Same fault on League 1
This problem was fixed. Please download the latest version.
Thanks!
Premier League fans are waiting patiently for the interactive League Table. Please can you release it for us. Thanks for your hard work and kindness for sharing such a powerful tool.
Please please let us have it.
Do you plan on creating a Premier League interactive table for the upcoming 2023/24 season?
Please when is it coming out?
Sorry for the delay. The league tables are published.
Hi, with 538 no longer updating their SPI rankings, are you still planning to release Monte Carlo sims for the top 5 Euro leagues this year? Thank you!
Hi Vishal,
The Monte Carlo sims use the SPI data from 538. Since 538 is no longer updating their SPI rankings, it does not make sense for me to publish the Monte Carlo sims anymore.
I will still post the non-macro score league tables. The new tables will be posted in the next few days.
Do you plan on creating a Premier League interactive table for the upcoming 2023/24 season?
Please when are you releasing the 2023 2024 Premier League interactive table.
Hello. I appreciate your commitment to soccer for Excel. If you have some spare times, could you make the “Eredivisie” fixture file beginning 23-24 season? Thank you for your help.
Hello! Your Excel sheets have been really helpful to me. I am truly grateful for your dedication and assistance.
If you have some spare time, could you please create an Excel file for the 2023-2024 Eredivisie match schedule? I kindly request this from you.
Thank you always, and may you always be filled with good things.
Can I have the password to allow me to manually put in scores for the Premier League, please? Is it the same for all leagues as I like the French and German set ups too.
Thanks
David
You can manually type in scores. You do it on the “fixtures” tab. Once the scores are entered on the “fixtures” tab, the scores in the tabs will update automatically.
Hi, do you have the 20/21 Premier league stats for download. Looking at what’s available on your site, the match stats are for 21/22 and 22/23. Thanking you in advance
Hi, i would like to ask if you can provide excel tables (like the big5 ones) for other leagues such as Eredivisie, Jupiler Pro League, Austria Bundesliga, Denmark Superligaen, Primeira Liga, Switzerland – Syper league.
Is there a spreadsheet available for the 2022-23 UEFA Champions League
Yes! We just published the 22-23 Champions League score chart on a few days ago!
https://www.excel4soccer.com/2022/09/05/uefa-champions-league-score-chart-in-excel/
Hi, are you publishing an updated UCL and UEL model? Thanks as always!
Yes, the UCL and UEL score charts are published today!
Hi, why cant the ‘likey home/away goals’ columns not be manually inputted for the remaining fixtures and also the result percentage not correct itself?
Thanks
I have the same question?
Hi my friend would you make it for me Monte Carlo simulation Prediction excel which is not VBA excel if no otherwise for example slover . I pay for it if you do $36,00 i pay you please write back and don’t and don’t delete it comment.
Thank you for sharing the simulation tool and the forecasts for the 2022 Qatar world cup!
I have a question for you. Are the FPI’s for all teams updated as for july, 2022? If not, what is the last update you’ve worked with?
Many thanks again!
The SPI values of the international teams are maintained by fivethirtyeight.com.
https://projects.fivethirtyeight.com/soccer-api/international/spi_global_rankings_intl.csv
As far as I can tell, the SPI numbers change from time to time. It’s hard to tell how frequently they update the SPI values for the international teams. I don’t they are updated in July 2022.
On the other hand, the SPI values of the club teams are updated daily by fivethirtyeight.com.
Hi my friend
Congrats on another amazing and successful season, thoroughly enjoyed it.
Amazing work done as always, and very much looking forward to next season.
Ramy
This is superb. I done something similar (nowhere as near as fantastic as this) for my local lcub (Sunderland, Lg 1), and our nearest 6 rivials. Hopefully, we’ll get promoted. Any idea when you will release 2022-23 Fixtures – I will need to make some additions like this year. Cant wait to see it.. WONDERFUL WONDERFUL work!
Thanks! I release the Excel Tables after the leagues announce the fixture calendar. This is usually in June. Good luck to Sunderland!
Do you have an interactive table for Pages? I have recently switched to Mac and used to love this.
I meant Numbers, which is the Apple version of Excel. Sorry.
I don’t think the macros will run in Numbers. I have tried to run the Interactive Score Tables in Microsoft Excel 365 for Mac. They work fine.
Hello! I really appreciated your job! I’m writing to ask if you have the spreadsheet for others European Leagues such as Eredivisie, Belgian Pro League and Austrian Bundesliga…thanks in advance 🙂
Thanks! If there are enough interest from the community, I can expand the spreadsheets to cover more European Leagues. Please check back in a few months.
Hi, thank you for posting UCL and UEL monte carlo sims! I had a question on the UCL MC sim, particularly with Group B. The model seems to dislike Atletico Madrid disproportionately than it should even after I adjust their SPI ratings higher and their opponents lower. Usually they are one of two teams in the group to finish w/ a positive goal differential but they still don’t finish in the top 2. Is there a calculation error going on with them? Thank you
Looks like it’s due the random number generator in Excel. Please try the new version (09-14-2021).
Thanks!
How can i get the password to change some result? Or no chance to do that?
I assume you are referring to the interactive league tables.
The past scores are stored in a hidden tab “fixtures_tmp”. “fixtures_tmp” is not password protected. You can either delete or change the “home goal” and “away goal” columns to change the results of past games.
Hello, I am interested in your file from the other website “Premier League Soccer Data In Excel”, but the download is no longer available, would you be so kind as to send me the file to my e-mail address? If any payment is required, just let me know.
Thank you and best regards.
Hi
Soccer Data in Excel for 2021-22 Premier League has been added to the site.
https://www.excel4soccer.com/2021/08/25/soccer-data-in-excel/
Thank you very much.
Love your work. Keep it up. How do I donate?
Thanks! To donate, you can go to the Download page or the About page and click the “Donate” button.
Any chance for a UCL interactive table? Thank you for your hard work!
Hola soy GERARDO de Peru, me gusto su trabajo y los felicito pero no logro entender como usar la tabla de la euro. me ayudan ?
Are there going to be more interactive tables of european leagues?
If yes, which ones?
At this point, the plan is to support the same leagues as last season: Bundesliga, Serie A, French Ligue 1 and La Liga. The league tables will be published after Euro2020.
Good afternoon
Do you have the Free Download Interactive Premier League Table in Excel for 21-22 league period? if I have the files from last season , how can I change the 3 new teams in this season (Watford, Brenford, Norwich City)
Not yet. Will have one before the 21 season starts.