Data need to be gathered from the webpage and put in the Google sheet. It should be a very simple, yet a bit time-consuming work due to a large amount of data.
All the process of gathering the data is explained. If you find any other way to be more effective, you are welcome to implement it.
- football club name
- contact person name (up to 4 contacts per club)
- function/role of the contact person
All the data can be found on the webpage [url removed, login to view]
The webpage is in German, however it is easy to deal with once you start.
Here is the link to the Google spreadsheet:
1. To find the right league on the webpage, you should go under "TABELLEN & ERGEBNISSE" and find the right one of the 9 areas, then select the right league from the 2 drop-down menus on the webpage. The process is simple once you see it.
2. After you find the right league, you should fill the club names.
I suggest you choose the link "Statistik" and select the last table (called "Auswartstabelle"), copy it (select all the clubs in the league from the bottom to the top) and paste it to the Google sheet.
Then remove the unnecessary data so that only club names and underlining webpage links remain in the sheet.
3. To get the contact person names, click on the club name and check the link "Funktionare" and "Trainer".
Each club should have a name of the following persons:
- sportlicher leiter
- trainer (what is important here is that you choose the main trainer, usually this is the first one on the list)
Up to 4 contacts is needed, minimum 2 per club.
4. You fill in the role/position.
5. You copy and paste the email address.
In the sheet, there is an example to show how the data should look like.
As said, the task is simple for someone who is behind a computer and is able to click & copy the data in the sheet for hours. By the way, I have more such tasks to be done for someone who is interested in such work.
Web scraping is a welcome technique
77 freelancers are bidding on average €117 for this job
Hi, we can scrape and get the club name, trainer name and other information similar to your product description accurately. We are good in getting this type of work. Looking forward to hear from you. thanks
Hi, After reviewing the project description I know that I'm an excellent fit for this [url removed, login to view]'s discuss and start right now. Awaiting for your positive reply thanks.
Hello there, how are you? I am very interested in doing this project and can start working on it after being awarded. Hoping to hear from you and may you have a great day ahead. Thank you :)
I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start