This site is for adults 18+ due to gambling/betting content. If you have a problem with gambling issues, or need information, please visit:
Gambling Help Online Gamblers Anonymous Gambling Therapy Gamble Aware Jugadores Anonimos JugarBIEN BeGambleAware GamCare

Announcement

Collapse
No announcement yet.

Transfer results to excel tool

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Transfer results to excel tool

    Do any of you know if there excist a site or tool that can help me to transfer results and past matches for a league to excel files? Its important its easy, like copy/paste or similar.

    #2
    I used to copy/paste results from soccerway.com or footballresults.org because there the results of a whole season were available on one page. I wrote myself a little spreadsheet that would extract the team names and the scores into different cells in a row and it suited me just fine.
    but now I haven't done it in this way lately as I changed to football-data.co.uk so I dont know how it is now. I think both of those sites changed the format in which the results are displayed so I could be a bit more difficult to copy/paste them.

    Comment


      #3
      Thanks for the reply Maycj.

      I have been using football data myself, but I have problems to copy the matches into excel. It seems like all info ends up in only one cell.

      Do you know how to change that?

      Comment


        #4
        Originally posted by Proud
        Thanks for the reply Maycj.

        I have been using football data myself, but I have problems to copy the matches into excel. It seems like all info ends up in only one cell.

        Do you know how to change that?

        hehe, it will be difficult to explain, as I have different language version and wasn't using eng version since two years. But let's try

        1) Data from the main menu

        2) something like "text to columns" (you have to mark what you want to edit)

        3) hmm then you tick "constant width" (at least that's how it called in my version)

        4) you have to mark wit hthe arrows when you want to divide the colums

        Hope it helps in 1%
        Thanks, Peter !
        Originally posted by DonJuanKieputo
        Im eating today chocclate like ****

        Comment


          #5
          Originally posted by Proud
          Thanks for the reply Maycj.

          I have been using football data myself, but I have problems to copy the matches into excel. It seems like all info ends up in only one cell.

          Do you know how to change that?
          I used to build a special spreadsheet that would cut the info by finding the position of the commas and dividing it up...

          but GH's method is much quicker

          thanks GH

          Comment


            #6
            Originally posted by Proud
            I have been using football data myself, but I have problems to copy the matches into excel. It seems like all info ends up in only one cell.

            Do you know how to change that?
            Hi Proud

            You seem to be talking about csv files with data seperated with comas. I would advocate what George did but instead of the 3) point would choose "with separators" and mark "comas" in the next step. Then you don't have to mark each column you want to seperate.

            Lukasz

            Comment


              #7
              I created a spreadsheet that uses results from betexplorer.com.
              All of the results are in one single page, and it provides me with average number of goals scored home and away for each team and all the leagues. It also gives me an overvview of the results for any given league for any given team. All I have to do is to paste the results.
              However, the results from betexplorer.com are not suitable for teamform.

              I would be willing to trade my spreadsheet if someone could send me his with a frame in excell in which I could paste the results of the league, and it would automatically give me all the results for every single team in the league classified by date, so that I could manage teamform.

              I hope this was clear enogh.
              Maycj, I guess your excell file is similar to mine. Maybe you have some usefull suggestions for me?

              Comment


                #8
                A big thank you to George Hanson, Lukasz, Maycj and undertakerns for your advices. After your posts I managed to export the data.

                Once you know it, its pretty easy. Learning Excel is probably one smart ting to do

                Comment


                  #9
                  You are welcome, Proud.
                  Excell is great, indead.
                  BTW, I tried to copy results from football-data, but it seems like I have to pay for the service. Am I wright?

                  Comment


                    #10
                    Yes, its a one time fee of £15 I think.

                    Comment


                      #11
                      My dear friend Proud I've extracted results from xscores.com. And they have one big advantage over most of others and it's the half-time results together with the full-time.If you're interested to see how they look and feel you can e-mail or pm me.

                      Keep Dancing. :wink: 8)

                      Comment

                      Latest predictions

                      Collapse

                      Last posts

                      Collapse

                      Top Tipster Month

                      Collapse

                      Top Tipster Overall

                      Collapse

                      Favourite bookmakers

                      Collapse

                      BET365
                      All-time favourite bookie of Bettingadvice.com due to their great betting offers in many sports, very good live betting and in-game cashouts, and general ease-of-use. Take me to Bet365!

                      PINNACLE SPORTS
                      Great bookie, offer superb odds (low margins), very high limits, does not slash winning customers. Probably the most reliable sportsbook on the net. Well known among sports punters for their ability and will to offer a fair product. Pinnacle will not hide. If you are good, you win. OK,  I'll give Pinnacle Sports a try!

                      Working...
                      X