Write some Software

This project received 24 bids from talented freelancers with an average bid price of $469 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$250 - $750 USD
Total Bids
Project Description

Basically, I have a list of people and I need an automated process to find their location. I have an Access Database (that can be easily converted to Excel) which has tens of thousands of contacts., all of whom I know have LinkedIn Profiles. Most of these contacts have the person's city, but about 30,000 do not. I need a process to automatically fill in these missing locations. I have quite a bit of data on each person including First, Last, Title and company.

I need a formula, macro or Power Query or Microsoft Power BI to search the person's first and last name and either title or company in order to make sure it's the right person on Google (or another search engine), and return the city in the database. For instance, if Power Query searched their first, last and title and "linkedin", the first result should be their linkedin profile, and their location will be listed in that search result. I need it to scrape this location data and return it to the sheet.

I need this to be:

1. Powerful enough to go through tens of thousands of entries and not get flagged by Google (or however it searches the web) as a bot

2. Repeatable on any similar list in the future

I'm not sure if this is possible to do this or not, so please do not accept this job if you don't already know how to do this. I don't want to waste anyone's time!

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online