Excel data manipulation + scraping

Closed - This job posting has been filled and work has been completed.
Web, Mobile & Software Dev Scripts & Utilities Posted 1 year ago

Fixed Price

Delivery by June 30, 2014

$29.00

Budget

Details

We would like to create a database for calling clients.
We are creating the database based on erento.de website and existing excel files which were scraped from erento.de

We would need to have the following data manipulations made on this file:

A. Pull the city name from column E , it is located between the postal code and the word Deutschland
http://screencast.com/t/DW6OnjTGm
locate the city name in column F.

B. Insert the state of each city.
You can create a list of cities and states from this link for instance:
http://en.wikipedia.org/wiki/List_of_cities_and_towns_in_Germany
locate the state names in column F.

C. insert the the category and the subcategory and sub sub category of each company on erento.
the category and the subcategory  are showing at the url of the item advertised by the company:
http://screencast.com/t/0fUXx2O7

One idea how to get the category of the company:
Google "Erento" + "company name " (from the excel) and pull the the category and the subcategory and sub sub category from the url.
here is a video:
http://screencast.com/t/L3Z1eSvBOZ6
other methods are also welcome.


About the Client

(4.96) 297 reviews

Germany
Frankfurt 06:30 AM

544 Jobs Posted
73% Hire Rate, 6 Open Jobs

Over $30,000 Total Spent
410 Hires, 15 Active

$29.58/hr Avg Hourly Rate Paid
426 Hours

Member Since Sep 7, 2011