Searching content inside excel column and know their facebook,twitter or linkedin page

[Davide9000]

Hi all,
i have an excel column of 4000 rows that contains internet website and i want to know if this internet website have inside them relations with their facebook, twitter or linkedin page. Is that possible? and if it were possible how can i automate the compilation of another three column(facebook, linkedin and twitter)with their linkin page in excel? Thank you all.

 

[BarryL]

Are you asking to check if the URL is a facebook, twitter or linkedin page? Can you provide a test URL for example (not a real URL as that may violate someones privacy).

 

[Davide9000]

Are you asking to check if the URL is a facebook, twitter or linkedin page? Can you provide a test URL for example (not a real URL as that may violate someones privacy).

sorry, i inserted an url to imgur as example but it didn't charge before. Here is an example:
https://imgur.com/a/QSkGSy7.
I have only a column with various website(4000). I want to automate the insertion of their respective facebook, twitter or linkedin pages if they have one, task that up to now i did manually. Is it possible to automate it ?and if so,how? thank you

 

[BarryL]

What I think you are looking for is Web scraping or web mining. While you can automate IE with multiple URL's if the HTML is different (and it will be) i would imagine this is impossible in Excel. A more advanced web mining tool like python would probably make this possible.

Sorry I can't be of more help. Maybe someone else has more insight into this?