Extract data from a website

I am looking for a way to pull data from the website. For example: is it feasible to pull the list of stores and their addresses of a particular company, such as ODP, Big Lots, or Walmart?

Very easy with Power Query, a native tool of Excel.

HI, thank you for the reply. I have tried connecting to the website where the store locator information is available but no luck.

But if you have Excel 2007 you won't be able to use Power Query, what brings to the question, which Excel version is yours?