Chapter 39. Importing data from the Internet
Question answered in this chapter:
How can I easily download sports statistics into Excel?
We all know that the World Wide Web contains useful data on just about everything. However, you can’t really do any sort of analysis of this data while it’s on the web. You need to import the data into Microsoft Excel, which you can do very easily, providing the data is defined inside an HTML table. In an Excel workbook, on the Data tab, in the Get External Data group, click From Web. When the New Web Query dialog box appears, paste the URL of the webpage into it and then click Go. The webpage appears in preview, and you can select the HTML table you want to import. The answer to this chapter’s question shows you ...
Get Microsoft Excel 2013: Data Analysis and Business Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
