FIFA World Cup 2027 Excel Schedule
+ Tutorial
+ Betting match results

Betting match results

If you're having fun betting on match results with family or friends and turning it into a little competition, you can show the hidden worksheets
'Predictions_1',
'Predictions_2',
'Predictions_Ranking_1',
'Predictions_Ranking_2' and
'PrSettings'.

Further information is available here: ▸Betting match results.

Tutorial for creating your own Excel match schedule

If you want to know how to create such a schedule yourself and how it works, you can find a detailed tutorial on the EURO schedule here, which is internally structured in the same way as the World Cup schedule for women. Every single formula is explained in detail.
EURO_Tutorial_1.5_en.pdf    (Last updated: 19.01.2025)

The tutorial includes ten Excel files that represent the current status of the project after each of the ten chapters. This means you can start at any point or skip chapters.
Excel files for the tutorial    (Last updated: 18.01.2025)

World Cup Tournament 2027

The World Cup tournament starts on June 24, 2027 and ends on July 25, 2027. As with the 2023 World Cup, 32 teams will participate. Brazil is the host country.

The 32 starting places for the final round were allocated as follows:

• AFC (Asia und Australia): 6
• CAF (Africa): 4
• CONCACAF (North and Central America): 4
• CONMEBOL (South America): 3
• OFC (Oceania): 1
• UEFA (Europe): 11

Host nation Brazil automatically qualifies for the finals. The three remaining participants will be determined through intercontinental play-offs.

Further information from FIFA regarding the final tournament:
FIFA website for the 2027 Women's World Cup
Information and dates for the 2027 Women's World Cup

Intercontinental Play-offs

The starting places for the intercontinental playoffs were divided among the confederations as follows:

• AFC: 2
• CAF: 2
• CONCACAF: 2
• CONMEBOL: 2
• OFC: 1
• UEFA: 1

The Play-off tournament consists of two phases.

Phase 1:

The two AFC participants, the two CAF participants, the runner-up from CONMEBOL, and the OFC participant compete in the first phase of the intercontinental playoffs. The top two teams qualify for the second phase.

Phase 2:

The two CONCACAF participants, the highest-placed CONMEBOL participant, the UEFA participant, and the two best teams from Phase 1 will be drawn against each other in three knockout matches. The three winners will qualify for the final tournament.

Schedule:

Phase 1:  November/December 2026
Phase 2:  February 2027

UEFA Qualifying Phase

To determine the 11 participants in the final tournament and the one participant for the intercontinental play-offs, a tournament in the Nations League format will be held – with the difference that there is no Final Four round. Two play-off rounds will follow the group matches.

The four group winners from League A qualify directly for the World Championship finals. The remaining seven starting places and the participant in the intercontinental play-offs will be determined in two subsequent play-off rounds.

The second and third-placed teams in League A will play in the first play-off round against the six group winners and the two best second-placed teams in League C, while the four fourth-placed teams in League A and the four group winners in League B will be drawn in eight pairings against the second and third-placed teams in League B.

The 16 winners of this first round compete in the second round for seven direct World Championship tickets, which are awarded to the seven best winners of this round. The worst winner participates in the intercontinental playoffs.

Schedule:

Group matches:      03.03.2026 - 09.06.2026
1st Play-off Round: 07.10.2026 - 13.10.2026
2nd Play-off Round: 26.11.2026 - 05.12.2026

More information on the UEFA qualifying phase:
UEFA Qualifying Phase - Group Schedule
UEFA qualifying phase - all the fixtures

Current World Champion

Spain defeated England 1-0 in the final. The current World Champion is called Spain.
Third place is taken by Sweden with a 2-0 victory over Australia.

More information from FIFA

List of previous World Champions

FIFA Women's World Ranking

The FIFA women's world rankings have been in existence since July 2003. Like the men's world rankings, it is based on the so-called ELO rating. However, the calculation differs significantly from that of the men. For example, in the case of women, the match result is taken into account and not just victory or defeat. The home advantage is also included in the calculation.

The USA and Germany alternated leading the rankings. The USA led the rankings about three quarters of the time. In 2005 Germany achieved the highest ELO value (of 2234) ever achieved by a team.

Official world rankings published by FIFA

If you are interested in how the rating numbers in the FIFA women's world rankings are calculated, you will find a detailed explanation with calculation example, online calculator and Excel file for download here:
Calculation of rating numbers in the FIFA Women's World Ranking

Calculate your own rankings with Excel

Download Excel file (Calculate_Rankings_Women_1.0_en.xlsm)
Last modified: 2023-04-13
The file contains VBA code and therefore only runs under Microsoft Excel.

With this Excel file you can calculate your own rankings, analogous to the FIFA world rankings. Just like with FIFA, you enter all match results for a certain period of time. After clicking on a button, Excel then calculates the new ranking list with the current rating numbers.

For example, a regional football association can have its own regional ranking list similar to the FIFA world ranking list and update it at certain intervals.

FIFA uses values from 15 (friendly match) to 60 (World Cup match) for the weighting.

As an example, the Excel file contains the FIFA rating numbers of the top 70 teams in the world rankings as of 2023-03-24 as starting values. Some matches from April 2023 are entered on the second sheet and the newly calculated rating numbers are listed. So you can see how the FIFA rating numbers have changed as a result of these friendlies.