Comeback to this page and download latest version if possible. I will check the file once every few days and fix any known problems.

I applied conditional formatting to change color of the bracket view if fantasy results are shown.Īs this workbook relies on the Wikipedia page, if something changes there, the workbook can break.

I used Data Validation to let you (users) select whether you want to view fantasy view or actual view.

Here you can also specify the winners in a fantasy column.

In a separate tab, I have the schedule of all the 48 games.Here I am using either Dynamic Array formulas (such as FILTER & SORT) or good old INDEX MATCH formulas to get the correct values.Once the data is loaded to Excel, I created two different views, one for group stage and another for knock-out (elimination) stage.I am using Power Query (Data Ribbon) to fetch the relevant tables from the Wikipedia page.All the data comes from 2022 FIFA World Cup page on Wikipedia.But here is the quick run-down of the process: I plan to make a video explaining the process if time permits. The workbook uses Power Query in Excel to connect to Wikipedia page and fetch standings & results. If you hit CTRL ALT F5 (or Data ribbon > Refresh All), the group standings, points etc. The workbook also provides match schedules (dates & times as per local Qatar timezone) and quick access links to the match report. Switch between Fantasy and actual standings anytime. 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.

They will auto-update whenever you refresh the workbook.įantasy View (set your own Group Stage Winners) Two separate tabs provide clear view of the schedules & results from Group Stage & Knock out stage of the football worldcup. Features of this FIFA World Cup Schedule Workbook: This fixed a bug with the knockout stage view (bracket).ĭownload the Excel workbook (Excel 365 version)ĭon’t have Excel 365? Use the Non 365 version here. Download the FREE Excel Workbooks (updated on 6 December):ĭownload the latest files from below links. It is the Soccer WORLD CUP time !!! Here is an Excel Workbook to keep track of the schedule, results, group standings and more.

Free download fifa live streaming free