Excel 2003 XML Abilities and Amazon.com

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to use Excel 2003's XML abilities to download information from Amazon.com directly into MS Excel. Everytime I try to download the data directly though, the format is completely unuseable. How can I get the data in the link below parsed properly so that each of the items are in a seperate row and each item's fields are in a seperate column within their respective rows

http://xml.amazon.com/onca/xml3?t=b...rt=+salesrank&offer=All&type=heavy&page=&f=xm

P.S. Please don't abuse the link above or spam it across the internet or Amazon will shutdown my access to their XML fields. If you are interested in getting this type of access to Amazon.com simply go to the link below, get a developer's token and go from there. Thanks

http://www.amazon.com/gp/browse.html/ref=smm_sn_aws/002-9541831-6765624?_encoding=UTF8&node=3435361
 
As answered to your later post:

To import it directly into Excel (tested in Excel 2002 and 2003), choose
Data>Import External Data
Choose New Web Query
Paste the link into the Address box
Click the Import button
Select a starting cell, and click OK
 
Back
Top