Retrieving F1 Race Data in Google Sheets

Other Questions Google Sheets
1

I’m trying to fetch F1 qualifying and race results using an API URL in cell A1. Here’s my try:

=FETCHTABLE(A1, "grid", 1)

I only get errors. Any ideas?

2

hey mate, have u tried IMPORTHTML? it worked for me with F1 stuff. try this:

=IMPORTHTML(A1, “table”, 1)

make sure ur API link is good tho. if it dont work, maybe the data isn’t in a table format? lemme know if u need more help!

3

I’ve found that FETCHTABLE can be finicky with certain API structures. Have you tried using IMPORTDATA instead? It’s often more forgiving with various data formats. You could try something like:

=QUERY(IMPORTDATA(A1), “SELECT Col1, Col2, Col3 WHERE Col1 IS NOT NULL”, 1)

This assumes your data starts in the first row. You might need to adjust the column numbers and add more specific filtering based on the actual structure of your API response. Also, double-check that your API URL in A1 is correct and returns the expected data when accessed directly in a browser. If you’re still having trouble, sharing a sample of the API response could help pinpoint the issue.

4

I have worked extensively with F1 data in Google Sheets and encountered similar issues when using the FETCHTABLE function. In my experience, using the IMPORTJSON add-on has proved to be a more reliable method for retrieving race and qualifying details. You can install IMPORTJSON and then apply a formula such as =IMPORTJSON(A1, “$.MRData.RaceTable.Races[0].QualifyingResults”, “position,Driver.givenName,Driver.familyName,Q3”) to extract exactly the data you need. This approach works well when your API URL in A1 correctly points to the desired session.