yep, Python + selenium or BeautifulSoup to scrape, just save it to a notepad file as a CSV then open with excel and saves as xlsx. No need to worry about programming the excel side of it then.
A quick google shows this: http://webscraper.io/
Phew, your response came just in time!If you don't want to do any coding yourself, you could use GrabzIt's Web Scraper. It is completely online and scrapes are created in a point and click way.