How about loading them into PowerQuery and then loading into Excel. You could have a table of URLs in Excel that you use as the source for a base query that then gets the rest.