moneyentrancement

FIFA world cup 2018 is around the corner. I love soccer, I love Excel, Let’s marry them. Here is an awesome, free FIFA world cup Excel Tracker to help you follow this year’s games in Russia.

Click here to download the FIFA world cup 2018 tracker.

What you can do with this FIFA world cup Tracker Excel?

You can use this tracker to,

• View schedules in your local time for group and knockout stages
• View summary and detailed points table
• Refresh live points table. When you refresh, the tracker show updated points based on latest results (You need Excel 2016, Office 365 or older versions of Excel with Power Query)
• View knockout stage matches as a bracket
• See timeline of the matches
• NEW – Results of the matches
• Coming soon – All the goals (will be available before semi-finals)

How to use the world cup 2018 tracker?

Start page – set up the tracker

When you open the workbook, use “Home” page to set up your local timezone and favorite teams.

Group Stage – Schedule & summary points table

The group stage view shows all teams. It highlights your team(s) in different color to see when their games will be on.

On this page, you can also see group-wise points table. This is a live table. So as the matches happen, just press CTRL+ALT+F5 to update this table. The data comes from Wikipedia FIFA 2018 page thru Power Query. So you need Excel 2016 / Excel 365 or an older version of Excel with Power Query to get the refresh work.

Bracket View – Knockout Schedule

The knockout stage shows last 16, quarter-final, semi final and final matches in bracket view. This page is not dynamic. So as group stage finishes, go ahead and list the team names in the gray cells.

Timeline View

This shows all matches in a Gantt chart like view. From this you can track all your favorite team matches. It will also highlight current date so you know which matches are coming up next.

Results View

This view shows all match results to date. This is a live table. Just press CTRL+ALT+F5 to refresh it and get new data. All the data for this comes from the excellent open football github project.

Download FREE FIFA world cup tracker

Click here to download the FIFA world cup 2018 tracker.

Errors or Problems with this template?

• Error: Points table looks funny, incorrect
• What to do:
  • If you know Power Query:
    Go to Points Table. From Query ribbon, edit query.
    Backtrack the query to see at what step things have gone south.
    Try fixing it.
    Usually, this is because the wikipedia points page has been changed by someone
  • If you don’t know or care for Power Query
    Try downloading the latest version.
    As the games progress, I will test this and upload new version whenever I see serious issues.
• Error: Can’t see times or values in cells, All I see is #####
• What to do:
  • This happens when the column is too narrow for the content
    Turn on Headings from View ribbon
    Adjust column width
• Error: Can’t refresh the points table
• What to do:
  • You need Power Query for Excel & internet connection to refresh.
    If you said no for either, try fixing the problem or manually enter points in the table.
  • Sometimes if the wikipedia page is in the middle of editing process, you might get funny results. Wait a few minutes (until the match is over) and refresh.
• Error: Something else
• What to do:
  • Try downloading the latest version.
    As the games progress, I will test this and upload new version whenever I see serious issues.

Which teams are you rooting for?

As usual, I am cheering for Germany and Brazil. I will also watch out how Denmark & Sweden (my former homes) are going to play.

What about you?

Hello Awesome..

My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.

I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.

Thank you and see you around. Quicktime free download.

1. Good work as always - I liked the way you did the 'menu' on the left hand side (although the buttons aren't lined up between tabs if I'm being ultra picky)

   Have you previously written about the method of extracting the Wikipedia page into Power Query? It's not something I recall seeing before.

   ps other geeky observsations:

   - the bracket columns are too narrow for the date & match number - and will need to be wider still when the team names get populated
   - match 51 should be Moscow (Luzhniki) for consistency
   - it's not possible to be 23 hours ahead of GMT - the International Dateline gets in the way! I think the maximum is 14. There are also a couple of countries who work to a quarter hour to make it really complicated!
   - There's a typo in the how-to - 'compated' instead of compared

2. Hello!

   This is quite amazing and incredibly cool to use 🙂

   Testing the constraints of this sheets a few errors popped I noticed:
   - Vlookup Group E-H refers to column J instead of E (eg. Brazil gets the same points as Russia because the formula looks up Russia twice)
   - Power query only has 29 lines, the overview of has 32 but the 3 countries from group A are lost as the overview is refreshed - causing N/A in the group stage colums

3. Hi,
   Thanks for sharing this world cup tracker. Certainly makes it more interesting when the data is current. As a newbie, it also helps to have a couple of mistakes to find whether unintentional or not.

   Thanks again

4. Hi,

   Your v-lookups in the 'Group Stage' tab for groups E, F, G, and H (all the ones under column O) are pointing to the wrong country. They all point to column J, so whatever happens to the countries in column J will also be reflected for the countries in the groups in column O for that same row.
   Just thought I'd call that out. Thanks for the great work on this!

5. Refresh All did not work correctly. Team names vanished though points were updated.

6. Dear Chandoo

   Thanks a lot for this worksheet.

   However, while refreshing the data, I am getting error message as 'Initialisation of Data Source failed'.

7. @Etienne - yes. Copy row, paste formats will do it, although obviously that will bring the formats of every cell in the row as well as the height.

8. Latest version seems to be working well.

   One request: the Groups & Points tables on the Group Stage sheet have the team names pre-entered. This means they don't get sorted according to the results.
   On my copy, I've changed them to a lookup, so they appear in the same order as the points table. It would be good if you can do the same if/when you release a new update!

   Here's what I did. It's not the most elegant, but it works, and I didn't have much time to spend on it!

   Using helper values of 1,2,3,4 in columns I and N for each group, the formula for the first team name in group A (cell J4) is:

   =INDEX(points[Team],MATCH(OFFSET(J4,-(I4),0),points[Group],0)+(I4-1))

   This can be copied & pasted to the other team name cells.

   Cheers!

9. I consider my Excel skills as above average but far from guru and I love how your little projects like this get me to look at data in a new way. I would like to expand on the data in the points table through the use of some calculations but I am a little challenged by the data coming across as text. The Pts column is easy to deal with, but I'm having problems with the GD. The negative goal differential looks like it may be noted with an en dash instead of a minus sign, but if I search for an en dash in the data Excel doesn't find any. I would like to include conversion to a minus sign in my little macro so I can get everything to numbers but so far I am not having any luck. Any thoughts? Thanks for your help.

10. As always, an awesome spreadsheet from Chandoo. I love the Power Query score update without macros. The country watch-out is a unique feature as well!

    For those who like a predictor template with flag lookup and a ribbon UI, here is our spreadsheet:

11. […] Interesting World Cup Tracker here at chandoo.org : https://chandoo.org/wp/fifa-worldcup-2018-tracker/ […]

12. Great template!

    I came across another one with image vlookups for country flags

    https://eexcel.co.uk/downloads (World_Cup_2018_Sweepstake.xlsx)

13. This is a great Template.
    I am running Excel 2010 with the PowerQuery add-in running.
    The scores will not update, so I followed the error and the second operation (Fitlered rows) says that the table is empty.
    After a few minutes on Wikipedia, I realise that my PowerQuery skills are not good enough to work out what the issue is.
    Any suggestions?
    I would like to fix it myself is possible.
    Thanks,
    Sean.

14. Where can I see the results for a specific match?

    Thanks!