Interactive Premier League Table in Excel Download

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)

Free Download Interactive Premier League Table in Excel

New Update: 2019/20 Interactive Premier Premier League Table in Excel for the remainder of 2020 season is released.  Scroll down for the download link!  Keep Calm, Stay Healthy!

I created an interactive Premier League Table in Excel.

(If you are looking for the Championship League Table in Excel, please follow this link.)

The spread sheet calculates the Win, Draw and Loss probabilities of each fixture.  Based on the calculated probabilities, the spread sheet will predict the score of each fixture.  Furthermore, it allows the user to run Monte Carlo simulations of the entire EPL season.  The Monte Carlo runs are then averaged to predict the final league table.

The spread sheet supports the following features.

  1. Generating the league table from manually entered scores.
  2. Generating the league table from automatically “guessed” scores.  The “guessed scores” are generated based on the Win/Draw/Loss probabilities.
  3. Predicting the final league table by running Monte Carlo simulations.  The user can specify the number of Monte Carlo runs. 

The math behind predicting EPL games is documented in detail in the this post.  I use the SPI (Soccer Power Index) published by to predict the outcome of the games. 

The spread sheet also offers a couple of unique features.

  1. SPI Adjustment Factor (SAF).  “SAF” allows the user to tweak the SPI values from  You can strengthen or weaken a club by using a positive or negative SAF value.  This comes in handy when the user happens to disagree with the SPI values.  It also allows the user to analyze other possible scenarios and see how they play into the final league standings.
  2. The user can enter “imagined” scores for future games.  This allows the user see how the outcome of a future game changes the standings of the team. 

The spread sheet also contains tabs that lists every fixture sorted by clubs and date.  There is a chart where the points of three clubs are plotted.  The user can select any three clubs to plot.  

It works with MS Excel 2010 or later. You need to enable macro in Excel to run it. 

If you have questions or suggestions, please leave a comment at the bottom of this post. Enjoy!

2019/20 Season: Current Revision is Rev 5.1.  (Updated on 06/14/2020):  Verify Captcha first. Download will start automatically.

Follow this link to download Interactive 2019/20 EFL Championship League Table in Excel

You may also like...

16 Responses

  1. Johnny says:

    Hi Tang family
    I love you spreadsheets
    do you have one for the english league 1, league 2 and the national league
    just the fixtures will be good for those leagues pls

  2. HVK says:

    Hi Tangfamily, will it be possible to share password to unprotect the sheet. Would be helpful to try out scenarios?


    • jtang says:

      Hi HVK,

      There are a few different ways to try various scenarios:
      1. You can enter the score of a particular fixture per your own prediction. You can then run the Monte Carlo simulation to see how the table changes.
      2. You can enter the “SAF” factors of a particular club. The “SAF” values basically overrides the SPI values.
      3. You still can manually enter the “SPI” values of each club, if you do not agree with “SPI” values.


  3. Darren says:

    HI, would it be possible to get the password to unlock the worksheet that has the premier league table on it i am happy to pay a modest amount for the password but i want to know how the table auto updates itself

    • jtang says:

      Thanks for your interest in the spread sheet. The tables are updated via Excel macro. We don’t provide password. Sorry!

  4. Daniel says:

    Are you updating this now that the December fixtures have changed for all clubs?

    • jtang says:

      Just uploaded a new version (3.1) for the Premier League with updated fixtures.

      • Daniel says:

        Thank you very much!

        Do you have one, or are considering implementing, where it includes all other domestic and European fixtures such as Carabao Cup, FA Cup, Champions League and Europa League etc?

  5. Dan says:

    Will you be updating this for the second half of the season and fixtures that have been rearranged?

    The games now all say 00:00 as kick off time.

  6. Craig Jones says:

    Hi, I really love your work, when is the next update?

  7. RS says:

    Hi, thanks for this, will you be updating this anytime soon?

  8. Daniel says:

    Are you still updating this as of 2020 fixtures?

Leave a Reply

Your email address will not be published.