UPDATE: 8/20: Scores Will Now Update Periodically
Are you looking for a free English Premier League Prediction Template to track matches, make weekly predictions, and see how your forecasts stack up against your friends’? This all-in-one spreadsheet is perfect for EPL fans who want an easy way to manage the 2025–26 season.
What’s Included in the EPL Template?
This English Premier League prediction spreadsheet has five tabs:
- Master.Schedule
- Team.Schedule
- Weekly.Schedule
- Weekly.Predictions
- Leaderboard
Master.Schedule: The Core of the EPL Template
This is the main tab where you manage all fixtures and results. Update scores in columns J and L, and adjust for your time zone using the fields in column A if you want the time and date to update in column G for the schedule.
Want to follow your favorite clubs? Use the watchlist starting at cell A12 to highlight one or more teams. This affects other tabs like Weekly.Schedule, helping you quickly spot the matches that matter most to you.
As you update the results, the standings update automatically in columns AF:AI. If necessary, you can manually set tiebreaker positions in column AK, should the tiebreakers get to that point.
Team.Schedule: View Fixtures for a Single Team
In this tab, pick your team from the dropdown in cell A3, and their schedule auto-populates in columns B:N. It’s a clean, filtered view for tracking just one EPL team. The team is highlighted in grey, and no manual editing is required—this tab pulls directly from the master schedule tab.
Weekly.Schedule: Focus on One Week at a Time
In this tab, enter a week number in cell A3, and the tab displays all fixtures for that week. Matches involving any teams in your watchlist are highlighted for quick reference. Again, no need to manually enter anything—scores flow from the master tab.
Weekly.Predictions: Compete with Friends
Want to run a weekly EPL prediction game? This tab lets up to 10 players make predictions and earn points. And with this, you can specify the week you want to make predictions for — there’s no worry if you start late or haven’t been making predictions since the start.
- Enter the week number in cell A3.
- Customize the scoring system (e.g., 1 point for the correct result, 2 for correct goals, 3 for exact score).
- Add player names in row 2 and enter predictions starting in column P. There is room for 25 players. If you don’t need them, just delete the names, and they won’t populate on the leaderboard tab.
- Scores will auto-update based on the scores from Master.Schedule – do not make changes and enter actual results on this sheet.
Leaderboard: Track Your Prediction Results
The current week’s results will populate on the leaderboard, in row 72:
When the week is complete, copy the values to the table above, which is where you can update the points per week, in the actuals section.
In the above example, I’ve filled in values 1 through 25 for each of the players. You will override this with your own prediction results for week 1. And then as the following week completes, copy the scores (from row 72) to the correct section on the actuals.
The data will then populate above, giving you a cumulative score for each player, along with a chart, showing the results visually.
On the Google Sheets version, the chart will automatically update. However, on Excel, since a pivot table is used to show only the active players, you will need to Refresh the data (from the Data tab). Otherwise, the chart will not update. There is a reminder on the Excel workbook to do this refresh.
Updated scores will now update via Power Query and Google Sheets
8/20 Update: With the latest file, you no longer have to manually input the scores anymore. I have a file that will update with the latest scores, and that will flow through to the Google Sheets and Excel files. For Excel, you will need to refresh the query to get the latest data, it will not pull in automatically. To do this, go to the Data tab and click on Refresh Data. By doing this, the file will download the scores.
Please note the scores are not live or up to the minute. I’m using AI to periodically update the data, and while I will attempt to update it by at least the end of each day that there is a game, I cannot guarantee that will always be the case. If you prefer not to wait, you can still update the scores and override the formulas within the file. But at the very least, you won’t have to input all the scores anymore.
Download the English Premier League Prediction Template
If you’re ready to go and want to give the template a try, you can get started right now:
- Excel: Download the template here
- Google Sheets: Download the template here
When you click on the link, you’ll be prompted to make a copy of the file. This is to ensure that you have your own unique version of the file to work with.
This Premier League Prediction Template for Excel and Google Sheets is completely free to use and customize.
If you have any comments, questions, or suggestions about the template, please contact me!
If you liked this English Premier League Prediction Template for Excel and Google Sheets, please give this site a like on Facebook and also be sure to check out some of the many other templates that we have available for download. You can also follow me on Twitter and YouTube. Also, please consider buying me a coffee if you find my website helpful and would like to support it.