For more information, see Shape data. Table of ContentsGet External Data from Web ManuallyScrape data using VBA programmingScrape data […] Insert a new Excel worksheet, and name it Hosts.

There are two methods that you can use to complete this kind of task. However, we have to import the data into Microsoft Excel before doing any kind of analysis.

Now that we’ve imported data from an Excel workbook, let’s import data from a table we find on a web page, or any other source from which we can copy and paste into Excel. It is well known that World Wide Web contains huge useful data. In the following steps, you add the Olympic host cities from a table. Use Excel's Get & Transform (Power Query) experience to import data into Excel from a wide variety of data sources.You can then use the Query Editor to edit query steps to shape or transform data. This wikiHow teaches you how to copy a data table from a web page, and paste it into an Excel spreadsheet without messing the original data in the table, using a desktop computer.

How to Import Web Data Into Excel on PC or Mac.