How to pull Linkedin url from 1000 websites?

shadabdurrani · May 6, 2020, 11:50pm

I have a list of 1000 companies and want to pull their LinkedIn URLs either looking on their website or with their business name?

diskborste · May 7, 2020, 11:31am

If you have the company domains then perhaps run the FindOnPage formula to check if they link to LinkedIn:

=FindOnPage(A2;"LinkedinAccount")

shadabdurrani · May 10, 2020, 5:15pm

its not working for Linkedin

diskborste · May 10, 2020, 5:31pm

It finds any LinkedIn accounts linked in the HTML:
=FindOnPage("https://seotoolsforexcel.com";"LinkedinAccount")

shadabdurrani · May 10, 2020, 5:37pm

its only working on some url not all even tho linkedin page is available on the page

shadabdurrani · May 10, 2020, 5:41pm

try with these urls

https://aecom.com/ca/
https://resumely.pk/

both have linkedin page on their home

shadabdurrani · May 10, 2020, 5:42pm

or is there any way I can scrape html source and regex linkedin page url?

diskborste · May 10, 2020, 6:42pm

Okay, figured out the issue. It only accepted LinkedIn persons, not company pages. Updated so both are accepted.

New version:
https://links.seotoolsforexcel.com/latest/

shadabdurrani · May 10, 2020, 8:32pm

Great! its now working!