The Scenario
You are a fantasy football manager with a serious approach. The Gameweek 31 deadline is Tuesday at 6:30 PM and you need current injury and suspension data for all 20 Premier League squads before you finalise your transfers. You want player name, injury type, and expected return date for every sidelined player in one Excel workbook. It is Monday morning.
The bad version:
- You try to build a Power Automate flow that calls the API-Sports injuries endpoint for each team
- You have 20 teams; Power Automate charges per run and you are already close to your monthly limit
- You decide to script it instead, call the endpoint 20 times, get the results
- Suspensions are in a separate endpoint; you call it 20 more times
- You concatenate the two result sets, discover the return date field uses "Season" for long-term injuries, which breaks your date-sort in Excel
- It is Monday afternoon, you have 50 hours until the deadline, and you still have not compared the injury list to your squad.
The faster version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that calls the injury and suspension endpoints for all 20 Premier League clubs and consolidates the output into one structured table.
Open the SheetXAI sidebar and type:
Fetch current injury and suspension data for all teams in the Premier League for the current season and write player name, team, injury type, and expected return into columns A through D. Separate injury rows from suspension rows with a 'Status' column in column E labelled either 'Injured' or 'Suspended'. Map 'Season' return dates to 'Long-term'.
SheetXAI calls the API-Sports injuries and suspensions endpoints across all 20 clubs, maps "Season" return-date strings to "Long-term", and writes the consolidated table with the Status column separating the two categories.
What You Get
A consolidated injury and suspension table:
- Player name and team — all sidelined players across all 20 clubs
- Injury type — muscle, knock, suspension, illness
- Expected return date — readable date or "Long-term" for season-ending injuries
- Status column — Injured or Suspended
All 20 teams in one table means a single Excel filter shows you every sidelined player from every club without cross-referencing 20 separate pulls.
What If the Data Is Not Quite Ready
Injury research for fantasy decisions usually needs a cross-reference layer. SheetXAI can add it inline.
When you want the list cross-referenced against your squad
Your fantasy squad is in the Squad tab, column A. You want to know immediately which of your players appear in the injury list.
After building the injury table, check each player name against the player names in the Squad tab (column A). Write 'In My Squad' into column F for any injured or suspended player who is in your squad. Sort those rows to the top of the table.
When return dates use inconsistent formats
Some return dates come through as "Season", some as specific dates, some as "2-3 weeks". Your date-sort formula breaks on the mixed formats.
Standardise the return date column. Map 'Season' to 'Long-term'. Map '2-3 weeks' style entries to a date range calculated from today. Add a 'Return Category' column with three values: 'This Gameweek', 'Next 2 Gameweeks', or 'Long-term'.
When you only want players from teams in your upcoming fixtures
You only care about injuries in the squads your fantasy players will face over the next three gameweeks.
Filter the injury table to show only players from teams listed in the Fixtures tab (column A). Write those rows to a new tab called 'Relevant Injuries'. Sort by Return Category with 'This Gameweek' absences at the top.
When you want the full pre-deadline brief in one pass
You have no data yet. You want the full injury table, the squad cross-reference, the return categories, the relevant-fixtures filter, and a cell at the top telling you how many of your squad players are doubtful or out.
Fetch current injury and suspension data for all 20 Premier League clubs. Write player name, team, injury type, expected return, and status (Injured/Suspended) to the main tab. Map return dates to Return Categories (This Gameweek / Next 2 Gameweeks / Long-term). Cross-reference against my squad in the Squad tab and flag squad players in column F. Create a 'My Risks' tab with only my flagged players sorted by Return Category. Write the count of my squad players who are doubtful or out this gameweek into cell A1.
The pattern: instead of pulling the injury data and running the cross-reference as two separate tasks, you describe the full pre-deadline brief and SheetXAI builds the complete picture in one go.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull injury and suspension reports for all Premier League squads into your Excel workbook before your next transfer deadline. The API-Sports integration is included in every SheetXAI plan. For related workflows, see how to bulk-import Gameweek player stats in Excel or the API-Sports in Excel overview.