Excel data manipulation + scraping

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

Fixed Price

Delivery by June 30, 2014




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
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:
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:

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:
other methods are also welcome.

About the Client

(4.96) 454 reviews

Frankfurt 03:26 PM

694 Jobs Posted
71% Hire Rate, 7 Open Jobs

Over $40,000 Total Spent
605 Hires, 20 Active

$18.79/hr Avg Hourly Rate Paid
1,070 Hours

Member Since Sep 7, 2011