Hey, mate.  No need for apologies, it's a good question.  I think with Excel, you could use get external data from web and just use the actual page to fetch the data from.  I think excel just looks at the webpage, breaks it into it's xpath data, and then uses that xpath data to import into the spreadsheet.

I'd have to verify, but I think that would be the way to go.  I'll test it at work and report back.

-Fuse