Build an extractor to scrape locations into excel

So I have a steady need to find the locations of people in large data files (excel sheets with anywhere from 2,000-50,000 contacts). The files include first, last, title, company and I want to scrape their locations from LinkedIn into a new column. Since LinkedIn limits how many searches you can perform, I want to use Bing searches first, then fill in the remaining with LinkedIn directly.

I created a LinkedIn Search URL and Bing search URL for them all in two new columns. The URLs work, I tested them. Here is an example: [url removed, login to view]

And Bing:

[url removed, login to view] Ski Resort%09Children's Ski and Snowboard School Supervisor&qs=n&form=QBRE&sp=-1&pq=

I need something simple, reliable and quick that does not cost anything monthly. I believe there are a few ways to do this and I am open to different ways. Possibly with an excel web query.

I believe this can be done using Python, dump to a csv, and then open in excel. Possibly using splinter or selenium with python to do the searching, and optionally use beautiful soup to extract the location information from the search results.

For this project to be successfully completed, I need the process to be:

-A streamlined way to process multiple large files 2,000-50,000 contacts a month

-No monthly fee

-Reliable long-term

-An easy-to understand explanation of how to do this on a regular basis as I've never used Python before

In your bid, please let me know:

-Details of how this can be done

-Previous similar projects you've completed

Skills: Excel, PHP, Python, Software Architecture

See more: excel screen scrape spreadsheet, scrape sites build xml, excel www scrape, excel screen scrape website, vba excel wait query finished web, excel screen scrape vb, excel macro scrape, contact info email addresses phone proofreading transcription excel data scrape research, contact email address excel research scrape, excel macro query xml web service, excel 2008 scrape website, excel vbs scrape html, free excel web data extractor excel, web page excel screen scrape, query database web design, excel data scrape, excel screen scrape, build manga reader web, build static html web page, build real state web site, using excel web query fill web form, sharepoint web part query sharepoint web part, excel vba scrape, access user query via web form, php mysql dump web script

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

Project ID: #14586503

Awarded to:


Hello ! I am a PHP developer and I have already worked on multiple scraping projects using CURL and PHP native functions. I already have spotted an easy way to extract the location on Yahoo. Regards Relevant Skills an More

$110 USD in 4 days
(14 Reviews)

39 freelancers are bidding on average $137 for this job


Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. i have delivered almost 240 project with 100% client satisfaction. Relevant Skills and Experien More

$140 USD in 3 days
(221 Reviews)

Hi sir, I am scraping expert, I have did more than 350+ scraping project, please check my feedback then you will know. Can we discuss more details about this project? then I will provide example data/scr More

$135 USD in 3 days
(276 Reviews)

Hello I have read your requirement and I'm interested in doing this project as we have all the required skills and expertise needed for this work. Kindly open chat to discuss and get started. Relevant Skills and Exp More

$147 USD in 3 days
(64 Reviews)

SALUTATIONS How are you? I hope you are doing well and this season is going great for you and your business as well. I've carefully gone through the requirements of your project. All the requirements mentioned by y More

$365 USD in 5 days
(95 Reviews)
$155 USD in 3 days
(99 Reviews)

Hi, I would like to work on your interesting project. I am ready to talk about details in chat.

$100 USD in 2 days
(73 Reviews)

Hi there, I have read the project description and can make a scraper to get this done.. I have good reviews for my past projects. We can discuss further details in private message. Stay tuned, I'm is still working on More

$50 USD in 0 days
(133 Reviews)

Hey, I am Ahmed from Blue Fountain Media, with more then 12yrs of experience. My work speaks for my services. I have delivered 1350+ projects sucessfully. MY WORK [url removed, login to view] http://www.azyam.c More

$100 USD in 3 days
(61 Reviews)

A proposal has not yet been provided

$35 USD in 1 day
(181 Reviews)

Respected Sir/Madam, It is my pleasure to be able to bid on your project. I have minutely gone through the details mentioned in your project description, and very much excited to be a part of your esteemed projec More

$100 USD in 2 days
(315 Reviews)

I have read your project. I'm sure i can help you to do it. I am expert in web scraping. I have created many scraping tools. I have 7 years of experience in Web Development, System & Network Administrator and Sec More

$88 USD in 1 day
(46 Reviews)

Hi , I have reviewed your requirement and I can built as per your requirement and i can show you my past work in further discussion. I have a advanced skills in WORDPRESS , Angular JS ,PHP, Codeigniter,MYSQL, Jo More

$222 USD in 3 days
(30 Reviews)
$155 USD in 2 days
(18 Reviews)

Dear Sir/Madam, I am Monalisa Akhter from Dhaka, Bangladesh. I have a team and I can do this urgently if you needed. I want to do your job perfectly if you select to me. Thanks. Regards Monalisa A Relevant S More

$500 USD in 2 days
(17 Reviews)
$155 USD in 3 days
(10 Reviews)

Dear Employer, I am a student of [url removed, login to view] Electrical Engineering. It's my main source of income. More than last 5-years having 100+ completed projects along with top positive feedback on my profile easily proof my expertis More

$155 USD in 3 days
(26 Reviews)

I’ve 5 years of experience of data entry & MS Excel especially with pivot tables, charts, advance formulas and VBA codes Relevant Skills and Experience MS Excel Proposed Milestones $50 USD - Upon Completion

$50 USD in 1 day
(19 Reviews)
$155 USD in 3 days
(4 Reviews)

Dear Sir, I think I can do this job. Let's discuss on chat? We will use Python+ Selenium to search and get data. Please take a look on my profile to see some similar projects which I have done. Or watch these demo vi More

$150 USD in 7 days
(15 Reviews)
$155 USD in 3 days
(9 Reviews)