O'Reilly logo

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition by Wayne L. Winston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 34. Importing Data from the Internet

  • The MSN Money Central Web site provides analyst ratings (buy, sell, and hold) for stocks. How can I import this information into Excel?

  • Is there a way I can download current stock prices into Excel?

We all know that the World Wide Web contains useful data on just about everything. However, we can’t really do any sort of analysis of this data while it’s on the Web. We need to import the data into Microsoft Office Excel. Excel 2007 makes importing data from the Web very easy. After you find the URL where the data you want is located, copy the URL to the Windows Clipboard. Then open an Excel worksheet and on the Data tab, in the Get External Data group, click From Web. When the New Web Query dialog box appears, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required