I have an excel file with about 10 000 companies.
I have columns : name of company and adress, but unfortunately field adress has only zip code and city, sometimes street.
I need to complete this field with number of house where company have his location.
All you have to do is to copy company name and address which is included in file, search this company at google and copy completed address, with : street, house number, zip code and city.
Can i send you about 30 companies and then you will resend me file and say how long it takes you to complete this data?
Normally, about 10-15% adresses of companies can't be find in the internet, so it will be ok if you find about 85-90 adresses.
it's important to have text format in Column D : street and house number, zipcode and city (comma between (STREET AND HOUSE NUMBER) , (ZIPCODE AND CITY)
[url removed, login to view] row from column C and D(if data about street and city is provided) to [url removed, login to view] and search completed address connected with this company/person
[url removed, login to view] no data is searched, copy just row from column C
[url removed, login to view] no data is searched, go to next row (about 10-15% addresses is not public in [url removed, login to view])
3.1 if data is searched, copy and paste addres to column D in text format : street and house number, zipcode and city (neccessary ! )
price is 20$/1000 completed addresse