Working with ImportXML or ImportHTML Functions Google Sheets or Excel. Scraping address locations off of websites for logistical data & research.
The problem:
I need to go to corporate websites to collect location information for all offices, branches or facilities. We want to be able to search a website of a large international bank, national restaurant chain, network of hospitals or multi-national conglomerate of manufacturing facilities and collect relevant information like Address Location Phone etc. For the purposes of plotting the branches offices restaurants or facilities on a map utilizing geo-coding and logistics. For instance, some of the banks, retail stores and or restaurants under their find a store locator or store locations area on many websites. Example https://www.lowes.com/
As you can see from the store locator on the above website. It launches a small window of local store close to me. However, I am hoping to get a list of all stores either by state or across America. I am aware of the Google Sheets that uses there Import HTML or Import XML code function to do this. I think Excel has a similar function as well. At the moment I cannot find examples or steps for what I am hoping to do. Wondered if any of you out there knew what tool I could use and how I might go about it?
I need to go to corporate websites to collect location information for all offices, branches or facilities. We want to be able to search a website of a large international bank, national restaurant chain, network of hospitals or multi-national conglomerate of manufacturing facilities and collect relevant information like Address Location Phone etc. For the purposes of plotting the branches offices restaurants or facilities on a map utilizing geo-coding and logistics. For instance, some of the banks, retail stores and or restaurants under their find a store locator or store locations area on many websites. Example https://www.lowes.com/
As you can see from the store locator on the above website. It launches a small window of local store close to me. However, I am hoping to get a list of all stores either by state or across America. I am aware of the Google Sheets that uses there Import HTML or Import XML code function to do this. I think Excel has a similar function as well. At the moment I cannot find examples or steps for what I am hoping to do. Wondered if any of you out there knew what tool I could use and how I might go about it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you sir
I think anyone with a gmail account can get an API key and some monthly credit. go to https://console.developers.google.com and see what is offered.
Roy
Roy
ASKER
I assume there is no free way to do this? I thought with the ImportXML code that the information could e gathered at no cost or was I wrong? Maybe my question is wrong. I know most of the companies I want to scrape the data from. But now that you have mentioned a way to look for a type of business (in your case bike shops) It is intriguing to think of what I can gather this way. Are we talking two different processes here?