I need to capture product data and images from a supplier website into an excel file. The supplier website has 1200 products (description and images) on separate pages. I need all that information into excel format so that I can structure this and upload this into my own website. Is there a software out there that can do this?
September 7th, 2010 on 11:42 am
You can use web table import follow this guide. http://www.mrexcel.com/tip103.shtml using this method you will probably have to create 1200 sheets of each product page and then one to compile info.
there are some more advanced methods here http://office.microsoft.com/en-us/excel-help/getting-data-from-the-web-in-excel-HA001045085.aspx
you can also seach "excel web querys vba" to find a code in vba that is more tailored to your needs. http://www.mrexcel.com/tip072.shtml has a query that pulls from 4000 pages so it probably can be adapted to your 1200 product pages.