Web Data extraction/scraper?

Anyone used an data extractor or web scraper to create a csv from vendors product that don't have it already compiled nice and neat for you?

I'm tired of going thru click by click copy/paste thru the hundred of products needed.

Any suggestions on how to simplify this process?

Thanks,

Jeremy