fbpx

FIFA 2022 World Cup Schedule & Results – Excel [FREE Download]

Share

Facebook
Twitter
LinkedIn

It is the Soccer WORLD CUP time !!! Here is an Excel Workbook to keep track of the schedule, results, group standings and more. Download it today.

FIFA world cup 2022 schedule excel download

Download the FREE Excel Workbooks:

Download the Excel workbook (Excel 365 version)

Don’t have Excel 365? Use the Non 365 version here.

Features of this FIFA World Cup Schedule Workbook:

Group & Knockout Stage Views

Group & Knock-out stage views - Fifa 2022 Excel tracker

Two separate tabs provide clear view of the schedules & results from Group Stage & Knock out stage of the football worldcup. They will auto-update whenever you refresh the workbook.

Fantasy View (set your own Group Stage Winners)

Pick your own winners for each of the 48 group stage matches and then see how that pans out at the knock-out stages (bracket view) with this cool Fantasy view. Switch between Fantasy and actual standings anytime.

Match Schedules:

The workbook also provides match schedules (dates & times as per local Qatar timezone) and quick access links to the match report.

Game schedules, date & times, match report links & fantasy option in one place.

Refreshable Scores & Group Standings:

The workbook is refreshable. If you hit CTRL ALT F5 (or Data ribbon > Refresh All), the group standings, points etc. will automatically update. The workbook uses Power Query in Excel to connect to Wikipedia page and fetch standings & results.

How is this built?

I plan to make a video explaining the process if time permits. But here is the quick run-down of the process:

  1. All the data comes from 2022 FIFA World Cup page on Wikipedia.
  2. I am using Power Query (Data Ribbon) to fetch the relevant tables from the Wikipedia page.
  3. Once the data is loaded to Excel, I created two different views, one for group stage and another for knock-out (elimination) stage.
  4. Here I am using either Dynamic Array formulas (such as FILTER & SORT) or good old INDEX MATCH formulas to get the correct values.
  5. In a separate tab, I have the schedule of all the 48 games. Here you can also specify the winners in a fantasy column.
  6. I used Data Validation to let you (users) select whether you want to view fantasy view or actual view.
  7. I applied conditional formatting to change color of the bracket view if fantasy results are shown.

Issues with the workbook? Read this:

As this workbook relies on the Wikipedia page, if something changes there, the workbook can break. I will check the file once every few days and fix any known problems. Comeback to this page and download latest version if possible.

If there are any issues with the file, please post a comment so I can fix them.

Alternative trackers:

Try the Spreadsheet tracker from Spreadsheet1.com as well.

How do I learn these techniques?

These kind of files are a great little project to build up your Excel skills. I suggest reading up below pages to learn some of the skills:

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

One Response to “FIFA 2022 World Cup Schedule & Results – Excel [FREE Download]”

  1. khalid says:

    thankyou

Leave a Reply