import html file from web

[kennydouglasw]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

In windows, one goes to data/import from web...I do not see that in the MAC version. Is there anyway to do this in Excel for MAC?

 

[JimG]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

In windows, one goes to data/import from web...I do not see that in the MAC version. Is there anyway to do this in Excel for MAC?

Hi,

You can use your web browser to save a web page, and the use File > Open
in Excel to open the web page.

You can use your web browser to look at the HTML source code. You can
copy the entire source code, and paste it into a cell in Excel, and
Excel will do what it can to render the web page information. Generally,
you would look for tables. You'd start copying the beginning <table> tag
and copy through to the ending </table> tag and paste everything
(including the table tags) into a cell in Excel. Excel does an
excellent job of rendering web tables.

-Jim Gordon
Mac MVP