I can’t look up live results from the 2025–26 season right now, but I can (1) explain exactly which competitions and matches you should include, (2) show how to collect the data quickly from reliable sources, and (3) give simple spreadsheet/SQL formulas to compute the aggregate record of English clubs vs Spanish clubs for 2025–26. If you want, paste a list of match results and I’ll compute the totals for you.
1) Which games to include
- Competitions to consider (competitive matches only unless you want friendlies): UEFA Champions League, UEFA Europa League, UEFA Europa Conference League, UEFA Super Cup (if applicable), FIFA Club World Cup (if applicable), and any official UEFA/club knockout ties (e.g., intercontinental competitions). Do NOT include domestic league matches — English and Spanish clubs only meet in international club competitions.
- Season definition: "2025–26 season" usually means matches played in UEFA competitions belonging to that season (qualifying from summer 2025 through finals in spring 2026). Include qualifying rounds if you want the full picture.
2) Where to get the match list quickly
- UEFA.com (competition pages have full match lists and filters by season)
- Transfermarkt (season filters, head-to-head pages, and country filters)
- Soccerway / Flashscore / ESPN / BBC Sport / FotMob (match lists, results, dates)
- Wikipedia pages for each competition's 2025–26 season (good quick reference; verify with official sources)
- Opta/StatsBomb/WhoScored (detailed stats if you have access)
3) How to collect data (fast methods)
- Option A (manual but quick): go to UEFA Champions League 2025–26 match list, copy matches that include one English club and one Spanish club. Repeat for Europa League and Conference League. Paste into a spreadsheet.
- Option B (Transfermarkt): use club-country filters or head-to-head match lists and export or copy relevant rows.
4) Spreadsheet template (columns to create)
- Date | Competition | Stage | Home club | Home country | Away club | Away country | Home goals | Away goals | Result from English perspective (W/D/L)
5) Spreadsheet formulas (Excel/Google Sheets) — assume column names in row 2 onward
- Identify matches between England and Spain (e.g., column E = home country, column G = away country):
=FILTER(A2:J1000, ((E2:E1000="England")(G2:G1000="Spain") + (E2:E1000="Spain")(G2:G1000="England")))
- English club wins count (English team might be home or away). Add a helper column K with: EnglishGoals and SpanishGoals depending on which side is English. Example K2 (English goals):
=IF(E2="England", H2, IF(G2="England", I2, ""))
L2 (Spanish goals):
=IF(E2="Spain", H2, IF(G2="Spain", I2, ""))
- Then counts:
English wins: =COUNTIF(ArrayFormula(K2:K1000 - L2:L1000), ">0")
Draws: =COUNTIF(ArrayFormula(K2:K1000 - L2:L1000), "=0")
Spanish wins: =COUNTIF(ArrayFormula(K2:K1000 - L2:L1000), "<0")
- Goals for English teams: =SUMIFS(K2:K1000, K2:K1000, ">=-1000") (or simply SUM(K2:K1000))
- Goals conceded: SUM(L2:L1000)
6) SQL example (if you have a match table matches with columns: match_date, season, competition, home_club, home_country, away_club, away_country, home_goals, away_goals)
- Select all England vs Spain matches in 2025–26:
SELECT * FROM matches
WHERE season = '2025/26' AND ((home_country = 'England' AND away_country = 'Spain') OR (home_country = 'Spain' AND away_country = 'England'));
- Aggregate English record:
SELECT
SUM(CASE WHEN (home_country = 'England' AND home_goals > away_goals) OR (away_country = 'England' AND away_goals > home_goals) THEN 1 ELSE 0 END) AS english_wins,
SUM(CASE WHEN home_goals = away_goals THEN 1 ELSE 0 END) AS draws,
SUM(CASE WHEN (home_country = 'England' AND home_goals < away_goals) OR (away_country = 'England' AND away_goals < home_goals) THEN 1 ELSE 0 END) AS english_losses,
SUM(CASE WHEN home_country = 'England' THEN home_goals WHEN away_country = 'England' THEN away_goals END) AS english_goals_for,
SUM(CASE WHEN home_country = 'Spain' THEN home_goals WHEN away_country = 'Spain' THEN away_goals END) AS spanish_goals_for
FROM matches
WHERE season = '2025/26' AND ((home_country = 'England' AND away_country = 'Spain') OR (home_country = 'Spain' AND away_country = 'England'));
7) What to report as final metrics
- Matches played, wins/draws/losses (English clubs perspective)
- Goals for / against (and goal difference)
- Win percentage
- Breakdown by competition (Champions League vs Europa League vs Conference) and by stage (group vs knockout)
- Notable ties: knockout clashes (two-legged aggregate results), finals or semis
8) Want me to compute it for you?
- If you paste a list of match rows (date, competition, home club, home country, away club, away country, home goals, away goals) I will compute the aggregated English vs Spanish record immediately.
- Or tell me whether you want only UEFA competitions or to include the Club World Cup and UEFA Super Cup.
If you want, paste or upload the match list and I’ll produce the full 2025–26 head-to-head summary with tables and percentages.