No-Code Spreadsheet Connector · Google Sheets & Excel
Live football tables, probabilities & match xG in Google Sheets & Excel
No Python, no Apps Script and no fragile copy-pasting. Our pre-wired .xlsx workbook connects directly to the Football Charts CSV endpoints across 98 leagues: paste a free API key into one setup cell and Google Sheets' native =IMPORTDATA() formulas pull standings, expected points, upcoming match probabilities and finished results automatically.
Ready-to-use Football Model Workbook (5 tabs, all 98 league codes built in)
Upload to Google Drive → Open with Google Sheets, or open in Microsoft Excel. Includes Setup, League Table, Upcoming Probabilities, Match Results & xG, and a 98 League Codes reference sheet.
- Step 1 · Grab a free key belowTakes 10 seconds, no card. Confirm your email to raise your daily budget from 100 to 200 sheet refreshes/day.
- Step 2 · Paste into Setup!B3Open the workbook in Google Sheets and paste your
fc_...key into cellB3. - Step 3 · Switch league or seasonType any of the 98 codes in
B4(premier,cha,germany2,brazil1…) and all data tabs refresh.
Get your free spreadsheet API key
Works in Google Sheets (=IMPORTDATA), Excel Power Query (Data → From Web) and our instant CSV downloads.
Copy-paste Google Sheets formulas (build your own sheet)
Already have your own model workbook? Paste any of these three formulas into cell A1 of an empty sheet and replace YOUR_KEY with your key:
=IMPORTDATA("https://footballcharts-backend.onrender.com/api/v1/leagues/premier/table/?format=csv&season=2026-2027&key=YOUR_KEY")=IMPORTDATA("https://footballcharts-backend.onrender.com/api/v1/leagues/premier/fixtures/?format=csv&key=YOUR_KEY")=IMPORTDATA("https://footballcharts-backend.onrender.com/api/v1/leagues/premier/results/?format=csv&season=2026-2027&key=YOUR_KEY")Desktop Excel tip: Microsoft Excel does not have Google's =IMPORTDATA() function. In Excel, open the Setup tab of our template, copy the generated URL in B8:B10, click Data → From Web, paste the URL and click Load — thereafter Data → Refresh All updates your workbook in one click. Remember to clear your key from Setup!B3 before sharing a sheet publicly.
What populates in your sheet on Free vs Paid keys
| Feature in your sheet | Free Key (€0) | Personal (€9/mo) or €49 Season Pass | Odds Archive (€29 / €199) |
|---|---|---|---|
| Leagues covered | All 98 leagues | All 98 leagues | All 98 leagues |
| Seasons unlocked | Current + previous season | Every season back to 2020 | 2020-21 to 2025-26 |
| League table & xPTS (17 cols) | Included | Included (all seasons) | — |
| Upcoming probabilities (19 cols) | Included (1X2, O/U, BTTS, HT) | Included | — |
| FT/HT scores & first-goal minute | Included (13 columns) | Included (13 columns) | Joined to odds rows |
| Per-match xG, shots, box shots, passes & cards | Season club tables on site | 34 extra columns auto-added to Results CSV! | — |
| Opening & closing bookmaker odds | Not on API | Not on API | Bulk CSV + Parquet download (/data) |
| Daily refresh budget | 200 refreshes/day | 5,000 refreshes/day | Offline files — unlimited |
Plans & one-off options — same API key, zero formula or code changes
Start with a free key in 10 seconds. Upgrading flips one flag on your existing key so historical ?season= calls and per-match xG/stat columns unlock immediately.
Free Key
€0no card
200 requests/day
- • All 98 leagues (men's, lower tiers & women's)
- • Current + previous season
- • CSV, Google Sheets, REST JSON & MCP
- • FT/HT scores, first-goal minute, tables & probabilities
2026/27 Season Pass
No subscription€49one-off · through July 2027
or €9 / month cancel any time
5,000 requests/day
- • Every season back to 2020 across all 98 leagues
- • 34 per-match stat columns: xG (25 leagues), shots, box shots, passes & cards (~64 leagues)
- • Single payment, zero auto-renewal
- • Personal & academic/modelling use
Historical Odds Archive
€291 league · €199 all 98
Bulk CSV + Parquet download
- • 2020-21 to 2025-26 opening & closing bookmaker odds
- • 1X2, Asian handicap & Over/Under ladders, BTTS, CS
- • ~3 books/match, bet365 named (no Pinnacle in 2020–26 pack)
- • Free Germany 2 & Estonia sample zips included
Building an app, site, bot or paid channel that other people use? See the Commercial API plan (€39/month, 25,000 requests/day).