Champions League 2023-2024 Scoresheet
We present to our English users the spreadsheet “Excel Champions League Schedule Template”. The past years we have published spanish version of National Teams competitions such as: Excel World Cup template, Euro 2024 Excel Schedule or America Cup template (in spanish). And we continue this season with the Champions League 2023-2024 in excel, and Excel Premier League Table for 2nd time. Last year we were surprised for the success of this template. This year we will have also the Europa League Excel Schecule and Conference League (soon).
The template has different ways of use: you can use as an Excel fixture of the Champions League for your own use, or you can use the files as a pool, sweepstake champions, excel Champions schedule with your friends, your workmates, with the bar clients or whoever you want to play.
As always I want to thank SandruskDesign for helping us with some aspects of the template design. What an artist she is!
Once the standings draw has been celebrated on we’ll publish the Excel template of Champions League.
We are great fans of the Champions but we’ve never playe a pool of this tournament, and this season is the first time we’re going to play the pool with our friends.
This Excel Champions League sweepstake is a bit different from other national teams tournaments. The National team tournaments, such as the Euro or the World cup, are played during a few weeks and the draws are closed before the start, however the Champions is played along the whole soccer season. Also there are some draws during the tournament: for the group standings, the round of 16 and the round o quarterfinals. So you have to be aware not to miss any game. But there are also advantages, because if you don’t hit results in the first rounds, you can have the same new opportunities in the following rounds.
In the Champions you have 1st and 2nd leg in all the rounds except in the final, that is a unique game. This excel is adapted the Champions rules. This file is only based in formulas, ther aren’t any macros.
How to use Champions League Excel Schedule 2023-2024
It’s very easy to use this template and when you download the template you can see also the instructions. In the group stage you only have to fill in the grey cells with your results predicition. You can fill in all at one time or you can go round by round. The group standings will be based on your predictions. In case of equality you can choose the order of the drawings clubs.
When the groups stage has finished, there will be the Round of 16 draw. When you open the file after the draw, you should allow to refresh content, but if don’t ask you will have to refresh data (press F9) and you will see the Round of 16 matches-up.
Then you can fill in your predictions of every game, and in case of draw at the end of the 2nd leg 2 extra grey cells will open to undo the draw.
For the next rounds: quarterfinals, semifinals and final you have to repeat te following steps in each round: update data in excel to see de Draw matches-up, fill in your predictions and send it to the pool administrator
Download Excel file Champions League 2023-2024
BONUS TRACK
Some comments to Excel Champions League:
- Last update: 02/09/2023
- This file can be used as fixture or for player prediction for the Champions sweeptake. It also contains a PDF file with the instructions
- Spanish version here
- We include a video about how the file works. (in spanish with subtitles)
Also, for those who want to admin an Sweepstake of the Champions League 2023-2024, you can download at the bottom the file to manage the pool with the instructions.
Download ADMINISTRATOR file for Excel Champions League Sweepstake
BONUS TRACK
Some comments to Administrator file
- Last update: 02/09/2023
- There are several versions depending on the number of participants you need. The version of this post includes up to 5 players. If you need a version for more than 5 participants click on the image to access different options.
We include a video about how the file works. (in spanish)
- You can see the explanation of the scoring system here.
- The downloadable file has the excel file to manage the game pool (Champions 2023-24 sweepstake) with your mates, friends and family.
As always, if you find some bugs, or you want to leave a comment, they are welcome. You can explain to us your pool rules, so other users can be able to get ideas of how to manage. You can also tell us were are you from, how many people play… Thank you very much in advance.
ENJOY YOURSELVES!
If it has been of your interest you can collaborate with a small donation.
Hello friend, I wanted to know if you can do the same as this images?? (Note: I’m not saying to do it, but just explain to me if in excel you can make one like this image?)
Hi Jose,
Of course! I appreciate your interest. Yes, it’s possible to create something similar using Excel. I’d like to mention that we also have versions available for the World Cup. Feel free to explore more options on our platform.
Best