Cerrado

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!

Habilidades: Excel, Microsoft Access, SQL

Ver más: software write content for the latest keyword, write some software - outlook add-in for integration into connectwise, software write mq4, 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, software write technical manual

Información del empleador:
( 5 comentarios ) San Diego, United States

ID de proyecto: #11736135

23 los freelancers están ofertando un promedio de $479 para este trabajo.

fabest

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 Más

$526 USD en 10 días
(80 comentarios)
7.2
royalcalif

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 Más

$250 USD en 6 días
(51 comentarios)
5.4
BDtW

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 Más

$255 USD en 6 días
(32 comentarios)
5.1
$388 USD en 5 días
(3 comentarios)
4.8
crypthne

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 Más

$250 USD en 7 días
(29 comentarios)
4.4
$333 USD en 10 días
(9 comentarios)
3.7
$750 USD en 20 días
(2 comentarios)
3.0
MichaelFelonin

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 Más

$500 USD en 5 días
(1 comentario)
2.7
$250 USD en 7 días
(2 comentarios)
2.9
$555 USD en 10 días
(1 comentario)
1.9
$250 USD en 10 días
(1 comentario)
0.6
MECHATRONS

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 Más

$333 USD en 6 días
(2 comentarios)
0.0
nanangwibisono

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

$250 USD en 5 días
(0 comentarios)
0.0
jurivtorov

A proposal has not yet been provided

$555 USD en 10 días
(0 comentarios)
0.0
thomaspaquin

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 Más

$600 USD en 5 días
(0 comentarios)
0.0
proavinash

Please provide the data so that i can pursue the work

$500 USD en 10 días
(0 comentarios)
0.0
FabioFelgueiras

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 Más

$1500 USD en 10 días
(0 comentarios)
0.0
extreamcode

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

$555 USD en 10 días
(0 comentarios)
3.9
gasolanki

A proposal has not yet been provided

$277 USD en 5 días
(0 comentarios)
0.0
HKhayat

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 Más

$250 USD en 1 día
(0 comentarios)
0.0