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
Thanks for the response, Fuse!
I'm currently using the method you mentioned, so I can confirm it will work! But the problem with this method is it doesn't work well with many exchange web pages which will update itself dynamically. I haven't tried it with BTC-e - and I doubt it will work, but it can't read the page data normally on
bitcoinaverage.com and
cryptonator.com (main page only, the "all rates" page works fine).
Just thinking that if Excel can achieve the same with Google spreadsheet, then it will be very useful since many cryptocoin exchanges/sites usually support various API info in .json format!