Excel Workbook for Betting Data: tables parsed from football-data.co.uk

Betting-Data Excel Workbook: more than 40 different tables with more than 100 various statistical parameters from top 22 European leagues!

Click here to download Betting-Data workbook for CURRENT SEASON, 2020/2021
(right click and “Save as”; .xlsx file, ~2.5 MB)

As a passionate bettor, you are probably aware of www.football-data.co.uk and their Excel database that contains statistical details from football matches in more than 20 top European leagues!

You can download data in Excel format or as Comma Separated Values; but in both cases, they are presented in flat format, so one needs to manipulate them to get them sorted.

Over the years I have been using those data, I would parse the desired output each time I wanted to see some statistics; I have decided to wrap up all those tables together in a Workbook, and publish it as an extension to Football-Data.co.uk data, to help fellow bettors find the stats they’re after!

I named the workbook “Betting-Data”; it’s available for download for free. It contains instructions how to use it, and they are pretty easy and straightforward, it does not require any special Excel skills!

Let me repeat the instructions here.

Instructions how to use Betting-Data spreadsheet

  1. Download Football-Data.co.uk database, available at http://www.football-data.co.uk/downloadm.php
    Downloaded file should be named “all-euro-data-xxxx-yyyy.xlsx”, where “xxxx-yyyy” stands for the season, for example “all-euro-data-2019-2020.xlsx” (presumably you will want to download the current season).
  2. Download Betting-Data Excel workbook. Please note the season – you need to download Betting-Data workbook for the same season as the Football-Data.co.uk database (presumably you will want to download the current season).
  3. Once you downloaded both files to your computer, you need to place the both files in the same folder (Desktop, or any other folder of your choice).
  4. Open the Football-Data database. If prompted with alert “This file originated from an internet location and might be unsafe”, click “Enable Editing” – Football-Data.co.uk is safe site; you can check it at various sources, such as one provided by Norton, one of the leading internet safety companies: click here to check football-data.co.uk safety rating
  5. Open Betting-Data Excel workbook. The same rules apply: if prompted with alert “This file originated from an internet location and might be unsafe”, click “Enable Editing” – here at BetGPS.com, we don’t aim to trick you; click here to check BetGPS.com safety rating.

And that’s it. Choose the league of your liking from home sheet of Betting-Data workbook, and enjoy the stats!

Please note: sequence of opening the files is important – you need to open Football-Data database first, and then Betting-Data workbook; otherwise, you will probably receive “#REF” error. In that case, simply close Betting-Data workbook without saving it, and open database first. In case you saved the Betting-Data workbook, error might be irrepairable, so you might want to download the fresh one again.

You need to keep database open as long as you use Betting-Data workbook, otherwise it will not work.

Please note that, depending on speed of your computer, tables may take a while to refresh when you switch the league or change other parameters within workbook; progress is shown in Excel’s status bar.

If you have any issues, please consult F.A.Q. sheet within Betting-Data workbook; if you cannot find a clarification there, then contact me and I will (try to) help.

Football-Data.co.uk provides database of statistics for some 20 seasons in the past. However, Betting-Data workbook is specific for each season, so if you want to use it for previous seasons (beyond season 2013/2014, which are provided here), you need to adjust the workbook; instructions are provided within workbook itself, and should be easy to follow for average Excel user.

Please note that, depending on circumstances, Betting-Data workbook may miss some data, which is explained within F.A.Q. sheet in the workbook itself. Those cases include missing odds, usually for lower leagues, and subsequent change of result, due to officially awarded matches.

Please note that you use Betting-Data workbook on your own responsibility. BetGPS.com and Football-Data.co.uk provide the data free of charge, in good faith in their accuracy, and cannot accept any responsibility for possible financial damages that you, user of the data and the workbook, may suffer from betting activities after using this Betting-Data workbook.

Below you can download Betting-Data workbook for current season, as well as previous seasons.

Please note: you need Excel 2007 or later to run this workbook. It contains some formulae that will not work on Excel 2003, or Excel alternatives, such as Open Office, Libre Office, etc.

This workbook may be updated in the future, and updates or changes will be tracked here. The version available for download above is always the latest one.

If you have any comments or questions, please feel free to contact football-data.co.uk (for database related questions) or BetGPS.com (for questions related to Betting-Data workbook).

Notice for Excel 2007 users. Please note the following: I have received several reports that drop-down menu for league selection does not work in workbook for season 2015/16 (i.e., it is stuck with Spain Primera division, set by default, and no other league can be selected), while older ones work properly.
I checked the workbook, and everything worked fine for me.
However, as I tried to investigate that issue further, I found out that there may be a compatibility issue on drop-down list between Excel 2007 and 2010.
I used to have Excel 2007 when I prepared original file, but when I updated it for season 2015/16, I already switched to Excel 2010; and I see in the following links that Excel 2007 might not show drop-down in that case:
stackoverflow.com/questions/7715684/drop-down-list-compatibility-issue-between-excel-2007-and-excel-2010
ozgrid.com/forum/showthread.php?t=150080
This link here says that issue might dissapear if you save the workbook as Macro-enabled workbook (that would be .xlsm extension), so you may want to check it:
http://answers.microsoft.com/en-us/office/forum/office_2010-excel/excel-2010-drop-down-disappears
I don’t have Excel 2007 any longer, so I cannot test it. Hence, if you’re trying to run this file at Excel 2007 and face the issue described above, I’m afraid I cannot help there, sorry…

If you’re looking for more betting data in Excel format, you may want to check CGMBet software, who offers football statistical data in Excel, including time of goals scored (which is not available in this workbook here), and for more leagues than available here. Please note, CGMBet is paid service; BetGPS.com readers are eligible for 25% discount on all CGMBet packages, except “Light Version”. You can claim your discount by using code CGM25GPS19 on checkout. This is affiliate link, meaning that I will receive commission from any purchase you make at CGMBet using the above code.

Features available in Betting-Data workbook:
– League Summary
– Main Table (corners, shots, shots on target, yellow and red cards, fouls)
– Goals Table (choose the goal line from 0.5 to 4.5 goals, or BTTS, and display the respective table)
– Head to Head stats of selected teams
– HT – FT Goals – relationship between half time result/number of goals and FT number of goals
– Discipline – yellow and red cards and booking points
– Results matrix
– Profit/loss tables (the amount of money you would have won or lost if you had bet on a team to win, draw or lose, using odds from Pinnacle Sports and Bet365, or under/over 2.5 goals, using average odds, in all matches or only when odds are in specific range, in all matches, or only home/away matches)
– Odds Filters – count of matches and possible profit/loss for matches within selected odds range, again using odds from Pinnacle Sports and Bet365

There are some lower leagues where not all the stats above are available; availability of stats for each league is found on sheet “Availability” within Betting-Data workbook.

If you reached this far, thank you for reading BetGPS.com and for using the workbook.