How can I automate copying data from a website into Excel?

Sarah October 27, 2011
Pinterest Stumbleupon Whatsapp

I have to copy data from a website, then paste it into Excel. It’s very time consuming, and I’d like to find a way to speed things up.

The webpage looks like this:
ID# Job# Job Info Address Date
111111 555555 Bill Billingham 2222 Street Way 3-3-11

Then I paste only the Job# and Address into Excel, like this:
Column A Column B Column C
555555 Pineapple 2222 Street Way

Is there some kind of software that would allow me to grab and copy only the Job# and Address down the whole webpage and then paste it into certain rows in Excel in Column A and C? I really like iMacros for other tasks, but I can’t find anything similar that would transfer between the internet and Excel. Or do you know of what these kinds of programs would be called?

Thanks so much!

Ads by Google