How to Build a Simple Spreadsheet to Track World Cup Player Stats

Why Build Your Own Tracker?

Official tournament sites and apps provide plenty of statistics, but nothing beats a custom spreadsheet that tracks exactly what matters to you. Whether you’re running a fantasy league, writing analysis, or just want to impress your friends with detailed knowledge, building your own World Cup 2026 player stats tracker is a rewarding project.

Tools You’ll Need

Google Sheets (free, cloud-based, shareable)
Excel (more powerful formulas and charting, but local-only unless you use Office 365)
Data sources (covered in detail below)

Google Sheets is recommended for its real-time collaboration and easy sharing features.

Column Structure

Create these columns starting from cell A1:

Column	Header	Description
A	Player Name	Full name as listed on FIFA.com
B	Nation	Three-letter country code (e.g., ARG, FRA)
C	Position	GK, DEF, MID, FWD
D	Jersey Number	Squad number
E	Matches Played	Count appearances
F	Minutes Played	Total minutes
G	Goals	Total goals scored
H	Assists	Total assists
I	Shots	Total shots (including blocked)
J	Shots on Target	Shots on frame
K	Expected Goals (xG)	From FBref or Understat
L	Chances Created	Key passes leading to shots
M	Pass Attempts	Total passes attempted
N	Pass Completion %	Completed passes / attempted
O	Tackles	Total tackles made
P	Interceptions	Passes intercepted
Q	Clearances	Defensive clearances
R	Aerial Duels Won	Percentage or count
S	Fouls Committed	Total fouls
T	Fouls Drawn	Total fouls won
U	Yellow Cards	Caution count
V	Red Cards	Sending-offs
W	Rating	Your own or from WhoScored/Sofascore

Data Sources

Where to get the numbers:

FIFA.com: Official match stats are authoritative but take 24–48 hours to update after matches.
FBref: The most comprehensive free source. Includes xG, progressive passes, carries, and percentile rankings. Updated within hours of match completion.
Transfermarkt: Best for player background data (age, height, preferred foot, market value).
Understat: Excellent xG data for leagues, though World Cup coverage may be delayed.
Sofascore: Great for live stats and quick post-match data dumps.
WhoScored: Provides player ratings and heatmaps.

Key Formulas

Use these formulas to automate calculations:

Total Goals: =SUM(G2:G100) for team totals.

Averages per 90 minutes: =G2/(F2/90) — divide a stat by minutes played, normalized to 90 minutes.

Shot Conversion Rate: =G2/I2 — format as percentage.

Pass Completion %: Already a percentage if obtained, otherwise =N2/M2.

Conditional formatting highlights (Google Sheets):

Highlight goals > 3: Format > Conditional formatting > Greater than > 3
Highlight conversion rate > 25%: Custom formula =AND($W2>0.25, $C2="FWD")

Charting and Visualization

Make your spreadsheet visual:

Bar chart: Goals by player, filtered by nation.
Radar chart: Compare two players across 6 key attributes (goals, assists, passing %, tackles, xG, chances created).
Pie chart: Goal distribution by position type.
Scatter plot: Shots vs. goals — identifies efficient finishers.

In Google Sheets, use Insert > Chart and select the appropriate chart type. For radar charts, you’ll need to arrange data with attributes in rows and players in columns.

To share your template:

In Google Sheets, go to File > Share > Publish to web.
Copy the link and share with friends or on social media.
To let others copy your template, add ?template=true or use File > Make a copy instructions.

For Excel, save as .xltx (Excel Template format) and share via OneDrive or email.

Pro Tips

Update stats after each match day — consistency is key.
Use data validation (Data > Data validation) to create dropdowns for nations and positions.
Freeze the top row so headers stay visible while scrolling.
Color-code rows by nation for quick visual scanning.
Create separate sheets for each group, then a master sheet with combined data.

Building your own spreadsheet transforms how you watch the tournament. You’ll find yourself noticing patterns, tracking players you’d otherwise overlook, and developing a deeper appreciation for the statistical side of the beautiful game.