Excel for mac, and connecting to external .html file

[adamash]

Hi guys, I hope you are all well.

I have a program that exports data in a .html file. I want to create a spreadsheet to automatically import this data (or allow me to click refresh when it has been updated) so that I can query it and automatically update charts etc.

I cannot seem to find a way to do this. Is this possible?

Thanks for any help.
Adam

 

[adamash]

To add to this, on Windows, I can select the 'from web' option, paste in the link to my document, e.g., C:\Users\ etc. and then import it. However, on a mac it says 'from HTML' and only lets me navigate to the saved .html file. When I select it, Excep opens it in a new workbook and thus, doesn't allow a connection that I can refresh when the .html is updated.

Perhaps this is another limitation of Excel for mac, but thought I'd check with you guys first.

 

[adamash]

I'm not really sure on the rules for bumping a thread, but I could really go with an answer, or work around for this.

Thanks
Adam