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.
Announcement
Collapse
No announcement yet.
Transfer results to excel tool
Collapse
X
-
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.
-
Originally posted by ProudThanks 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%
Comment
-
Originally posted by ProudThanks 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?
but GH's method is much quicker
thanks GH
Comment
-
Originally posted by ProudI 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?
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
-
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
Latest predictions
Collapse
Last posts
Collapse
-
Reply to POD 24/01/2021by al-gor#6 / +99
Sport Recife - Bahia
Pick: 2 (+0 AH) @ 1.8
Pinnacle
Football match from Brazil serie A between...-
Channel: Contests/Competitions
24-01-21, 22:02 -
-
Reply to Thanks Macot!!!by DimitriWelcome back....
-
Channel: Praise and recognitions
24-01-21, 21:28 -
-
Reply to POD 24/01/2021by gamblerbgPick 6 /+14
Ceara - Palmeiras
Pick : 1 (-0.25 AH)
odds 2.12 at Sbobet
Football game from Brazil...-
Channel: Contests/Competitions
24-01-21, 20:03 -
-
Reply to POD 24/01/2021by WKSkofuPick 7(5w,1lost) +341
Atletico- Valencia
Pick Atletico -1.0 , 1.88 Pinnacle
Atletico have a great season, they are getting...-
Channel: Contests/Competitions
24-01-21, 19:53 -
-
Reply to POD 24/01/2021Pick #8
5-0-2 +251
NBA. San Antonio v Washington
Pick: SAN ANTONIO -8.5 AH
Odds: 2.21 Pinnacle
Washington...-
Channel: Contests/Competitions
24-01-21, 19:46 -
-
Reply to POD 24/01/2021by MacotPOD #4
So far 3/0/4
-104
20:00 Lommel SK v RWD Molenbeek, take RWDM (+0,5) AH @2,02 Pinnacle
Well,...-
Channel: Contests/Competitions
24-01-21, 19:41 -
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!
Comment