On a related note, you can open a Web page in your browser from inside Excel. You can even share the data with other Office applications. Delete extraneous graphics and then copy or transpose blocks of data to organize the pieces just the way you want. However, this feature is a quick and easy way to get the raw data you need into a sheet. It’s a literal transfer of data, and remember, Excel isn’t a browser.

The resulting Excel sheet won’t look much like the Web page however. Hyperlinks are live - go ahead and click one! As long as you’re connected to the Internet, they should work just fine. In Excel 2007, the file type is All Web Pages (*.htm *.html *.mht *.mhtml).Įxcel actually enters the transferred data from the Web page into the current sheet, and you can manipulate the data as you would any other data. Choose Web Pages And Web Archives (*.htm *.html *.mht *.mhtml) from the Files Of Type control.Excel will probably display a “connecting to server” message. Enter the URL, including into the File Name text box.The Open command is on the Office menu in Excel 2007. Instead, open the Web page right in Excel, as follows: Ouch! You should never re-enter data if you don’t have to, and in this case, you don’t have to. If you glean data from the Web (and who doesn’t these days), chances are that you print the Web page and then re-enter the data manually. Open Excel and transfer the data directly into a worksheet.

Don't manually re-enter data you find on the Web.

Siu free excel download