Scrape About page of all local companies into Excel sheet

Help
1

I’d like to scrape the about page of all companies in an excel sheet, so that I can refer to the info even when it’s offline. In addition, it will be good if:

  1. It can read through the entire site and tell me what is the core business about (sentiment analysis?)
  2. auto-culls all LOCAL businesses only (i.e. those with physical presence in the country, say Canada)

How do I go about doing this?

2

@auto

How does the webpage that you want to scrape look like?