excel for mac get external data from web

As you know if youve wasted any time surfing the web, Internet websites provide huge volumes of interesting data.

Often, youd like to grab this data and analyze it in some way.

And fortunately, Excel provides an easy way to move such data from a web page into Excel.

Therefore, your first step might need to be to open a workbook with a blank worksheet.

This button appears on the bottom edge of the worksheet next to the sheet tabs: Sheet1, Sheet2, Sheet3, and so on.

The Bureau of Labor Statistics website provides tons of tabular information, so if you want to play along, go ahead and visit their website and poke around until you find a page that shows a table.

Excel places this small yellow right-arrow button next to any tables that it sees in the open web page.

All you need to do is to click one of the buttons to grab the data that the arrow points to.

Select the Existing Worksheet radio button to place the table data into the existing, open, empty worksheet.

Excel goes to some work to grab and arrange the table information.

In this case, you might want to revisit the web page that displays the table and verify that you clicked the correct select button.

He is the author of more than 100 books, including QuickBooks For Dummies and Quicken For Dummies.

Excel For Mac Get External Data From Web