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

  1. Jay
    October 28, 2011 at 7:21 am

    Internet explorer has an option to right click on text and send to excel On some computers, one of my laptops has this option, but desktop does not.

    may be web query can help : http://www.labnol.org/software/tutorials/extract-data-from-web-pages-into-excel/1979

  2. Anonymous
    October 28, 2011 at 7:09 am