Greetings. I have also created my own database, copy and paste match data and statistics to the main table.
Regarding forecasts, I use the Averages method, what it does is calculate with those numbers. and I do it by dates, periods also to see possible events or scenarios.
by General Conditions
I use excel mainly and now I found a way to apply it in Google Sheets as well (so I’ll use this when using just my phone)
My great project or added value is now wanting to keep track of the players, since these are the chess pieces in the team.
I want to refine and specify the impact they have when playing. It would be to cross-check more information that such players are present or play, how the numbers or statistics vary….
Because based on the alignment of the matches, the players will greatly influence the final result or development of the events.
i have download the euro 2024 score chart. its perfect,but the home score on group stage, the sheets are protected. can i have te password or can you please edit it. thanks
Will there be a Copa America & Euro 2024 Excel? Could you upload a tutorial on youtube on how to make these type of excels maybe? Like how did you get all the images perfectly the same size, or what formula did you use to link editable cells to the group stage leaderboard. How did you make the excel frozen (uneditable unless I had a password)
Hi,
I would like to know if is any chance to update the excel file daily ?
I downloaded the Soccer stats premier league but excel file is only on 13 MP but they played 20 games already.
You do a great great job
Thank you
Hi,
I would like to express my compliment of your job. It is really interesting and fantastic.
About excels with macros , how can we find the type of macro for prediction , how they work?
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)
Hey
Great site just wanted to say thanks for providing , is there anyway you can add refs onto premier league data ??
would it be possible to make one for copa america 2024?
Greetings. I have also created my own database, copy and paste match data and statistics to the main table.
Regarding forecasts, I use the Averages method, what it does is calculate with those numbers. and I do it by dates, periods also to see possible events or scenarios.
by General Conditions
I use excel mainly and now I found a way to apply it in Google Sheets as well (so I’ll use this when using just my phone)
My great project or added value is now wanting to keep track of the players, since these are the chess pieces in the team.
I want to refine and specify the impact they have when playing. It would be to cross-check more information that such players are present or play, how the numbers or statistics vary….
Because based on the alignment of the matches, the players will greatly influence the final result or development of the events.
i have download the euro 2024 score chart. its perfect,but the home score on group stage, the sheets are protected. can i have te password or can you please edit it. thanks
Hi Jtang,
do you have the data for the last 2 Bundesliga season as well, so season 21/22 and 22/23?
Will there be a Copa America & Euro 2024 Excel? Could you upload a tutorial on youtube on how to make these type of excels maybe? Like how did you get all the images perfectly the same size, or what formula did you use to link editable cells to the group stage leaderboard. How did you make the excel frozen (uneditable unless I had a password)
Hi,
I would like to know if is any chance to update the excel file daily ?
I downloaded the Soccer stats premier league but excel file is only on 13 MP but they played 20 games already.
You do a great great job
Thank you
Any chance we can get a League Two Excel ?
Hi,
I would like to express my compliment of your job. It is really interesting and fantastic.
About excels with macros , how can we find the type of macro for prediction , how they work?
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.