Use data from online tables inside of Microsoft Excel
One little-known feature ofExcelis its ability to importweb pages.
This import capability helps you analyze web data using Excel’s familiar formulas and interfaces.
Import Data from a Web Page
Excel is aspreadsheetapplication optimized for evaluating information in a two-dimensional grid.
Here’s how to import a data table from the web on a PC:
OpenExcel.
Select theDatatab and chooseFrom Webin the Get & Transform Data group.
The From Web dialog box will open.
SelectBasic, pop in or paste theURLin the box, and selectOK.If prompted, choose toConnectto the website.
In the Navigator box, opt for tables to import.
Excel isolates content blocks (text, tables, and graphics) if it knows how to parse them.
To import more than one data asset, place a check mark next toSelect multiple items.
After you select a table, a preview appears on the right side of the box.
If it’s the table you want, selectLoad.
The table appears in a new worksheet.
The right side of the screen displays theQueries & Connectionspane.
If you’ve imported multiple tables, select a table from the Queries & Connections pane to view it.
You’ll need to save the website to your gear using your web online window’sSave Asfunction.
Navigate to the location of your saved HTML web page, select it, and selectOpen.
Excel automatically imports the entire web page into a new workbook.
From here, clean up the chart to only include the needed data.
