Fill in a Spreadsheet with Data
该项目成功由sisicirnes ，以€100 EUR的价钱在5 天内完成。为像这样的项目获取免费报价
项目预算€30 - €250 EUR
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.
- The New York Times
- Wall Street Journal
- Times Online