Write some Software

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!

Skills: Excel, Microsoft Access, SQL

See more: software write content for the latest keyword, write some software - outlook add-in for integration into connectwise, software write mq4, web scraping, software write chip epson, useful software write book, software write web specs, free software write user guide, software write edid, free software write company profile, software write websites idea, software write book images, software write books, lisp water profile excel sheet, software book writer satish jain profile, software write protection, free software write book, software write book, write magnetic online dating profile, software write protect software

About the Employer:
( 5 reviews ) San Diego, United States

Project ID: #11736135

23 freelancers are bidding on average $479 for this job


Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser More

$526 USD in 10 days
(80 Reviews)

Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have provide you 24/7 communication support during the projec More

$250 USD in 6 days
(51 Reviews)

Hello, Thank you for posting your project here and for the clear description. I scrape data from the web and I use Selenium with Python or VB.NET for building the scrapers. Your project seems interesting enough More

$255 USD in 6 days
(32 Reviews)
$388 USD in 5 days
(3 Reviews)

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ More

$250 USD in 7 days
(29 Reviews)
$333 USD in 10 days
(9 Reviews)
$750 USD in 20 days
(2 Reviews)

Hi! I have more than 5 years of experience in data analytics. I also prefer to work with prototypes: create a mock solution for free and if you are fine with this we can discuss the details. Let me know if you are int More

$500 USD in 5 days
(1 Review)
$250 USD in 7 days
(2 Reviews)
$555 USD in 10 days
(1 Review)
$250 USD in 10 days
(1 Review)

Hello,We are a team of developers and do all work related to computer science( Software Engineering ),. We have experience in , JAVA,C# ,My SQL , website Design( wordpress ,PHP), Excel, ( vb ,(macro)), Research( biolog More

$333 USD in 6 days
(2 Reviews)

i'm very familiar with macro excel, vba, visual basic, access database, and other spreadsheet data manipulation with fastest solution

$250 USD in 5 days
(0 Reviews)

A proposal has not yet been provided

$555 USD in 10 days
(0 Reviews)

I'll be completely honest, I've never done this before. But, I will say, you've got me hooked on this problem. if you don't select me for the job, I'm going to solve it anyway :) Hope you have a good weekend! Let me More

$600 USD in 5 days
(0 Reviews)

Please provide the data so that i can pursue the work

$500 USD in 10 days
(0 Reviews)

Is possible to do however will need many private proxys, that i need to buy. Google will allways flag as bot if you do many connections, we can use captcha service... but best solition for multithreading, (multiple s More

$1500 USD in 10 days
(0 Reviews)

Hi, I can assist you with this project. Here is a sampling of the few of my work contained at my portfolio: [login to view URL] Please reply back so we can discuss. Regards, DT

$555 USD in 10 days
(0 Reviews)

A proposal has not yet been provided

$277 USD in 5 days
(0 Reviews)

Hi... Although I am a new freelancer, I have ab advanced practical experience in design and develop Access databases, including queries, forms and reports. My offer is a free week to test the project and informe me o More

$250 USD in 1 day
(0 Reviews)