ende

Video Tutorial: Download Historical Football Data and Sort for Functionality in Excel 2003


We are often asked for advice and shortcuts on how speed up the process of filling-in data in our various Value Bet Detectors such as the League Matches with Head-to-Head History spreadsheet.

Here is our very own Soccerwidow with some Excel training, running you very quickly through the process of creating useful Excel workbooks to easily copy from and paste data into any of our Value Bet Detectors. We hope you enjoy her extremely sultry East German/Russian/English accent! 🙂

In this video you will learn the download process of data from www.football-data.co.uk into Excel 2003, and then how to prepare them for further analysis by sorting into home & away fixtures tabs.

You can enlarge the video by watching it directly in You Tube. (Click first on Play and then on the You Tube logo in the bottom right-hand corner of the video below).

If you find it difficult to watch the video on Soccerwidow’s site then feel free to swap over to YouTube. Here’s the link: How to prepare historical football data in Excel for further analysis

Video Tutorial Main Learning Points:

  • Where to find results and odds data for numerous European leagues in www.football-data.co.uk
  • How to open the files you want in Excel to instantly convert the existing .csv file format into a usable Excel spreadsheet.
  • Add extra columns for easier future reference and freeze the top row to ensure titles remain visible as you scroll down the spreadsheet.
  • Learn shortcuts like selecting a large block of historical football data using the Shift key.
  • Sort historical football data into home or away team tabs
  • Learn a row spacing technique for fast division/separation between different teams for ease of viewing and use.
  • Highlight the entire sheet to retain its format and copy it into a new tab


Related Videos:

Our True Odds and Value Bet Detector uses Excel 2003 to allow functionality in all versions of Excel.


learn to think like a bookmaker!
deciphering bookmaker mathematics

Last Update: 14 August 2013

Categories:Learning Centre Statistics & Historical Data



2 Responses to “Video Tutorial: Download Historical Football Data and Sort for Functionality in Excel 2003”

  1. liam
    11 March 2014 at 9:42 pm #

    When trying to separate the teams im not able to do it all in one go and am having to insert the gap individually?

  2. Soccerwidow
    12 March 2014 at 5:33 am #

    Hi liam, there is a little manual work involved, but you do not have to do each gap individually.

    Please watch above video again, and try to replicate the described process.

    Advanced Excel users should be even able to introduce Macros which do the job automatically. The only restriction for a fully automated process is that the leagues have a different number of teams and games each season, and teams are relegated and promoted each year. This is quite a challenge when automating the data collection process.

    Unfortunately, explaining programming and advanced Excel usage in detail is beyond the scope of this website.

Leave a Reply

Time limit is exhausted. Please reload CAPTCHA.