Create an inventory map on Excel from website content?

[ShyamExcel]

i was looking for a ways in which we can link a website to an excel site and maintain a map of the inventory on it.


For example, if you look at http://www.amazon.com/kitchen-dining-small-appliances-cookware/b/ref=sa_menu_ki10?ie=UTF8&node=284507


is it possible to maintain a local excel sheet that lists out the various products listed on this page such as Kitchen > 'small appliances', 'Tools & gadgets', 'cutlery'? Just basic information such as title should be enough.


Are there other tools that any of you are aware that can help create such an inventory map of a website, if excel is not the right choice?

 

[SirJB7]

Hi, ShyamExcel!


Does this help?

http://chandoo.org/forums/topic/macros-web-query-huge-headache-can-anyone-help-me

http://chandoo.org/forums/topic/help-please-need-code-macro


Regards!

 

[ShyamExcel]

This definitely gives me some new leads. Thanks!

 

[SirJB7]

Hi, ShyamExcel!


When I wrote my first comment I haven't gone to the page of your link and answered about general procedures.

Now that I realize that's about Amazon, well, I'm afraid I have very bad news to you: this site as many other of the big players don't expose their data in simple tables on their web pages, turning impossible to access and stole (let us say borrow, download, what you like) its info in a systematized way.


Regards!