Taxonomy!

[freaklfc]

Hello all,

Hope its been an easy day for you all.
I am new to MS EXCEL and need some help. I am a uni student and doing a project on Data Warehousing. Anyway, coming to the question, I am trying to retrieve a taxonomy and import it to excel from a website (Amazon) and don't really know how to do it.
What i am looking for is a file that contains the categories and sub categories of their books. Any help will be greatly appreciated.

Thanks.

LFC YNWA

[abousetta]

Hello,

Could you provide a more specific set of instructions on how you would do this manually? Do you go to Amazon.com, search for the Taxonomy and download everything there? Do you need to this repeatedly or just once?

abousetta

[freaklfc]

i have never done this and don't even know how to start.

I think my question is not totally related to Excel.
I know there is a way (but don't know how) to import data from a website by just doing it once. When imported, that file is in CSV format. Thats all i know.
What i want to do is -- Import Amazons Taxonomy. i.e their different categories and subcategories of books that they have. My next step is to use Excel and break this CSV file (Text to Columns) so that the categories and subcategories get separated into different columns.

I hope i make sense to you. I have tried looking for an answer but haven't succeeded.

Thanks for the reply.

[abousetta]

There are different ways of communicating between Excel and websites. For example, you can use the built-in web browser or you can connect Excel with Internet Explorer. What we need to know is what page you want to extract the data from. If you want to see examples then do a search for the term WebScraping.

Hope this helps.

abousetta

[freaklfc]

thanks i will try did and get back to you.