The Scenario
You are an F1 analytics hobbyist. The 2023 season wrapped and you want to chart the championship progression across all 22 rounds — who led after each race, how the gap to Verstappen changed, which constructors scored most consistently. You are building the model in Excel because that is where your charting templates live.
You need every race result: driver, team, finishing position, and points, one row per driver per race, across all 22 rounds. That is 484 data rows before any analysis.
The bad version:
- You try to pull the API-Sports F1 race results through Power Query
- Power Query's web connector cannot handle the authentication header cleanly
- You write a Python script that loops 22 times, once per round
- Each response has a different race name string and you have to normalise them for your chart axis
- DNF rows have null in the points field which your SUM formulas choke on
- You export to CSV, open in Excel, discover the round numbers are not in the response
- It is midnight and you have not charted anything.
The faster version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that pulls the 2023 F1 season round by round and writes the full results table without you writing a single formula.
Open the SheetXAI sidebar and type:
Pull all 2023 Formula 1 race results — race name, round number, driver, constructor, finishing position, points — and write them into this workbook with one row per driver per race. Write 0 for points where a driver did not finish. Sort by round number then by finishing position within each round.
SheetXAI calls the API-Sports Formula 1 fixtures and results endpoints for the 2023 season, handles DNF/DNS edge cases (writing 0 for points and the status string for finishing position), infers round numbers from the schedule order, and writes the full 484-row table. Your SUM formulas will not choke on null points because there are none.
What You Get
A 484-row results table ready for Excel charting:
- Race name and round number — clean numeric round column for chart axes
- Driver name and constructor — consistent formatting across all 22 rounds
- Finishing position and points — DNF/DNS rows included with 0 points
Consistent driver names across all 22 rounds mean your PivotTable groups correctly without a cleanup step.
What If the Data Is Not Quite Ready
Championship progression analysis in Excel needs cumulative layers. SheetXAI can add them inline.
When you want cumulative points per driver for each round
You need a running total for charting who led after round 1, round 5, round 12.
Add a 'Cumulative Points' column. For each driver, calculate the running sum of points after each race in round order. Write the cumulative total into column G for each row.
When you want to filter to just the top 5 drivers for a readable chart
Twenty driver lines on one chart are unreadable. You want to isolate the championship fight.
Filter the results table to the five drivers with the highest total points across the season. Move those rows to a new tab called 'Top 5 Championship'. Keep all 22 rounds for each driver.
When DNF rows are breaking your PivotTable
Your PivotTable groups by finishing position and DNF rows appear as text, breaking the aggregation.
In column E (finishing position), replace any non-numeric values (DNF, DNS, DSQ, or blank) with the value 21. Add a separate column F called 'Status' that records the original string for those rows.
When you want the full championship analysis in one pass
You have not pulled any data yet. You want the results table, cumulative points, final standings, and fastest-lap counts, all in one workbook.
Pull all 2023 Formula 1 race results with race name, round number, driver, constructor, finishing position, and points. Write the raw results to the main tab with 0 for DNF points. Add cumulative points per driver per round. Create a 'Final Standings' tab with driver name, nationality, team, total points, and number of fastest laps. Sort the Final Standings tab by total points descending.
The pattern: instead of pulling the race data and building the championship analysis as two separate tasks, you describe the full deliverable and SheetXAI runs the API calls and the analytical layers together.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull a full F1 season's race results into your Excel workbook for championship charting. The API-Sports integration is included in every SheetXAI plan. For related workflows, see how to pull head-to-head match history in Excel or the API-Sports in Excel overview.