Put a formula in cell A1 of an empty sheet. Sheets fetches the table and refreshes it by itself, about once an hour. Every row starts with the event code, so several events' tables can be stacked in one sheet.
stats.csv
One row per team: OPR, non-penalty OPR and OPRc, auto and teleop OPRc, DPR, CCWM, Norm Avg, Max Norm Score, RS and RS bonus OPR, record, and an OPR for each part of the score
=IMPORTDATA("https://ftcrobin.com/2026/USAZGIQ/stats.csv")predictions.csv
Each scheduled match's predicted scores, winner and chance, and once played, the result
=IMPORTDATA("https://ftcrobin.com/2026/USAZGIQ/predictions.csv")matches.csv
One row per alliance in each match played: teams, score, result and the score breakdown
=IMPORTDATA("https://ftcrobin.com/2026/USAZGIQ/matches.csv")schedule.csv
The match schedule with its teams, once it is posted
=IMPORTDATA("https://ftcrobin.com/2026/USAZGIQ/schedule.csv")rankings.csv
The rankings, as the FTC API gives them
=IMPORTDATA("https://ftcrobin.com/2026/USAZGIQ/rankings.csv")top-scores.csv
The ten highest non-penalty scores
=IMPORTDATA("https://ftcrobin.com/2026/USAZGIQ/top-scores.csv")teams.csv
The teams registered for the event
=IMPORTDATA("https://ftcrobin.com/2026/USAZGIQ/teams.csv")