Forum Discussion
Football Fixture list generator
Hi,
I have been looking on Internet last few days to try to find an Excel Fixture List Generator for football teams, i found several but none of them actually worked properly or you had to pay a fee to make any changes to amount of teams or playing more than once.
I only have a basic knowledge of using Excel so please could you bear this in mind for any replies.
I look forward to any help you can provide.
Regards
Rick
rick8651 No apologies needed! See attached. I created a fixture list from the website I mentioned earlier and dumped it into column L on the Fixtures sheet, just for your reference. Then I used Power Query to re-shape the list to something more useful. Now, I didn't include the PQ part, but the end result is copied into columns O to Q. Then I added a column to the Dummy Table and assigned a number to each team so that you can use a lookup formula to pick-up the team names based on the numbers in the fixtures table (Home and Away) in columns P and Q.
The best way to learn Excel is to look at the formulae I used, read about how they work and practice, practice.
Attaching your own file with some extras. I hope you'll find it helpful. Good luck!
15 Replies
- Hello,
There is an excel file related to the subject you mentioned while browsing by chance, please try it. Organized only for the Turkish league, you can arrange it as you wish.
https://www.mediafire.com/file/k01x7mlgxc388ob/S%25C3%25BCper_Lig_2010-2011.xls/file rick8651 Now, I know nothing about football, but googled for the exact subject in your question.
Found this link:
https://www.fixturelist.com/createlist
It allows up to 32 teams, home and away. For free. What more do you need?
i THINK YOU ignored the part that related to forum IE that he wants an excel option
Hi,
Many Thanks for your reply, I need fixture list generator to be an Excel one as I have a league table connected to fixture results- I did try this website but cant paste fixtures into Excel sheet as layout completely different.
Thanks again
Regards
Rick
rick8651 Nevertheless, I created a list for 8 teams, Home and Away. Copied the "table" from the website and dumped it into Excel. As you mentioned, it's not very useful. But, with some Power Query (PQ) steps, I could fairly easily create a table that has fixture number (1 through 14) and Home and Away team for the four matched in every fixture. I didn't attempt to optimise or even clean-up the query, but just wanted to demonstrate that PQ can transform seemingly useless data sets to something very useful.
Would this be a starting point for your match schedule?
