Transfer results to excel tool

[Proud]

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.

[Maycj]

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.

[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?

[George_Hanson]

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%

[Maycj]

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

[Lukasz]

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

[undertakerns]

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?

[Proud]

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

[undertakerns]

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?

[Proud]

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

[JustAnotherVictim]

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)