• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

8. Connecting Excel to the World > 98. Import Data Directly into Excel

Import Data Directly into Excel

Using Amazon’s Web Services as a source of data, you can easily integrate live information about books into Excel spreadsheets. This example imports sales rank data for particular books and calculates the average rank.

This hack relies on Excel’s ability to perform web queries, so you’ll need Excel 97 or higher. Excel’s Web Queries tool transforms simple HTML tables into Excel spreadsheets.

Tip

To make this work, you’ll need to sign up with Amazon and get an associate tag. To do this, visit http://www.amazon.com/associates/. Then you’ll need to go to http://amazon.com/webservices/ and click on “Apply for a free developer’s token”. Both of these pieces are required to use Amazon’s web services.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint