betgps.com Open in urlscan Pro
2a06:98c1:3120::c  Public Scan

URL: https://betgps.com/betting/betting-data-excel-workbook/
Submission: On January 30 via manual from HU — Scanned from NL

Form analysis 1 forms found in the DOM

GET https://betgps.com/betting/

<form role="search" method="get" class="simple-grid-search-form" action="https://betgps.com/betting/">
  <label>
    <span class="screen-reader-text">Search for:</span>
    <input type="search" class="simple-grid-search-field" placeholder="Search …" value="" name="s">
  </label>
  <input type="submit" class="simple-grid-search-submit" value="">
</form>

Text Content

Skip to content
Latest News
 30. Jan Waalwijk vs Go Ahead Eagles Prediction  30. Jan Birmingham City vs
Blackburn Rovers Prediction  30. Jan Salford City vs Walsall Prediction  30. Jan
Carlisle vs Barrow Prediction  30. Jan Kilmarnock vs Dundee United Prediction
 30. Jan Real Madrid vs Valencia Prediction  30. Jan Monchengladbach vs Schalke
Prediction  30. Jan Stuttgart vs Werder Bremen Prediction  30. Jan Port Vale vs
Wycombe Prediction  30. Jan Portsmouth vs Barnsley Prediction
 30. Jan Waalwijk vs Go Ahead Eagles Prediction  30. Jan Birmingham City vs
Blackburn Rovers Prediction  30. Jan Salford City vs Walsall Prediction  30. Jan
Carlisle vs Barrow Prediction  30. Jan Kilmarnock vs Dundee United Prediction
 30. Jan Real Madrid vs Valencia Prediction  30. Jan Monchengladbach vs Schalke
Prediction  30. Jan Stuttgart vs Werder Bremen Prediction  30. Jan Port Vale vs
Wycombe Prediction  30. Jan Portsmouth vs Barnsley Prediction
Menu
 * Livescore



BetGPS


Search for:
×
Menu
 * Betting-Data Excel Workbook
 * Betting Blog
 * Contact & Newsletter
 * Disclaimer
 * Latest news
 * Betting Previews & Picks
 * Livescore

How do football and tennis players actually make their money?!


BETTING-DATA EXCEL WORKBOOK


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, 2021/2022
(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.

 * Click here to download Betting-Data workbook for CURRENT SEASON, 2021/2022
   (right click and “Save as”; Excel 2007 file, ~2.5 MB)
 * Click here to download Betting-Data workbook for previous season, 2020/2021
   (right click and “Save as”; .xlsx file, ~2.5 MB)
 * Click here to download Betting-Data workbook for season, 2019/2020
   (right click and “Save as”; .xlsx file, ~2.5 MB)
 * Click here to download Betting-Data workbook for season 2018/2019
   (right click and “Save as”; Excel 2007 file, ~2.5 MB)
 * Click here to download Betting-Data workbook for season 2017/2018
   (right click and “Save as”; Excel 2007 file, ~2.5 MB)
 * Click here to download Betting-Data workbook for season 2016/2017
   (right click and “Save as”; Excel 2007 file, ~2.5 MB)
 * Click here to download Betting-Data workbook for season 2015/2016
   (right click and “Save as”; Excel 2007 file, ~2.5 MB)
 * Click here to download Betting-Data workbook for season 2014/2015
   (right click and “Save as”; Excel 2007 file, ~2.5 MB)
 * Click here to download Betting-Data workbook for season 2013/2014
   (right click and “Save as”; Excel 2007 file, ~2.5 MB)

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.

Here are couple of screenshots from the workbook. It’s free to download and use,
so why don’t you check yourself!









CGMBET – POWERFUL TOOL FOR EXPERIENCED PLAYERS!


CGMBET - STATE-OF-THE-ART FOOTBALL BETTING SOFTWARE PACKAGE

Software created to provide punters with betting statistics for 74 football
leagues from 45 countries, in last 15 seasons.



Click here to visit site and check details.


MAKE YOUR OWN STATS!


MAKEYOURSTATS.COM - THE MOST COMPREHENSIVE FOOTBALL BETTING STATS AND LIVESCORES
IN ONE PAGE!

Website that provides detailed football statistics for more than 200 football
leagues all over the world

Pre game stats and Odds, Live stats, H2H stats, Lineups and Standings, Unlimited
custom feeds and filter features, League selection and alerts for more than 15
in-play events.



The unique in-play Pressure Index chart: follow the match development through
minute-by-minute stats based on shots, shots on target and dangerous attacks,
and make informed in-play betting decisions!



Click here to visit site and check yourself!


EXCEL FILE TO ARM YOU WITH DETAILED FOOTBALL STATISTICS


BETTING DATA WORKBOOK - FOOTBALL BETTING STATISTICS IN EXCEL FILE



More than 20 leagues covered, with more than 70 statistical parameters for each
league! Detailed football statistics, parsed from the data available at
football-data.co.uk.

Click here for more info, instructions and download!


SELECT LEAGUE





LATEST POSTS

0 1
30. January 2023


WAALWIJK VS GO AHEAD EAGLES PREDICTION

0 2
30. January 2023


BIRMINGHAM CITY VS BLACKBURN ROVERS PREDICTION

0 3
30. January 2023


SALFORD CITY VS WALSALL PREDICTION

0 3
30. January 2023


CARLISLE VS BARROW PREDICTION

0 1
30. January 2023


KILMARNOCK VS DUNDEE UNITED PREDICTION


SELECT LEAGUE

 * England Premier League
 * England Championship
 * England League One
 * England League Two
 * Spain Primera Division
 * Spain Segunda Division
 * Germany Bundesliga 1
 * Germany Bundesliga 2
 * Italy Serie A
 * Italy Serie B
 * France Ligue 1
 * France Ligue 2
 * Portugal Primeira Liga
 * Netherlands Eredivisie




Copyright © 2023 BetGPS

Design by ThemesDNA.com

Scroll to Top