Import Data from a Web Page
Excel is a spreadsheet application optimized for evaluating information in a two-dimensional grid. If you’re going to import data from a web page into Excel, the best format is as a table. Excel imports every table on a web page, just specific tables, or even all the text on the page.
Import the Data (Excel for PC)
After you’ve identified the website that contains the information you require, you can import the data directly into Excel using the From Web tool with only a few clicks, customizing import options along the way. Here’s how to import a data table from the web on a PC: Edit Data Before Importing It If the dataset you want is very large or not formatted to your expectations, modify it in the Query Editor before loading the data from the website into Excel. In the Navigator box, select Transform Data instead of Load. Excel loads the table into the Query Editor instead of the spreadsheet. This tool opens the table in a specialized box that allows you to:
Manage the queryChoose or remove columns and rows in the tableSort dataSplit columnsGroup and replace valuesCombine the table with other data sourcesAdjust the parameters of the table
Work with Imported Data After your web data loads into Excel, you’ll have access to the Query Tools ribbon. This new set of commands supports data-source editing (through the Query Editor), refreshing from the original data source, merging and appending with other queries in the workbook, and sharing the scraped data with other Excel users.
Import the Data (Excel for Mac)
You cannot import data from a website into Excel for Mac. You’ll need to save the website to your computer using your web browser’s Save As function. After you’ve saved the website, import the page’s HTML data into an Excel spreadsheet with the following method: While the From HTML method for Mac isn’t as clean or controlled as the From Web option for PC, it still allows data from a web page to be imported into an Excel spreadsheet.
