Data extraction of multiple websites

[extactor]

Hey guys,

I am looking for a program that extracts URLs, locations, Instagram, Facebook, phone numbers, and emails of different hotels all around the world that I just have the name for and can get the URLs myself if I need to. All hotels have different websites, would it be possible to extract data from all of them with just one program without writing code for each one?

Thanks for the help!

 

[Automatrix]

I think you're looking at something like accessing all the URLs with Power Automate, have it dump all visible text or the source code into an excel file, and then you may be able to extract something systematically in Power Query afterwards. How many URLs are we talking about?

 

[extactor]

The thing is I need something to extract only wanted data, not all visible text, such as phone numbers and email ... if everything is extracted I would be back to square one filtering the data myself. I've done some research and i think it is an impossible to automate given the amount of detail needed.

 

[Automatrix]

The thing is I need something to extract only wanted data, not all visible text, such as phone numbers and email ... if everything is extracted I would be back to square one filtering the data myself. I've done some research and i think it is an impossible to automate given the amount of detail needed.

You may for example be able to extract X characters after the phrase "Telephone", which will probably catch a large percentage of phone numbers. Likewise for data after "facebook.com/" etc.