Excel : Import tables from web pages

Ran into a bit of a tough nut the other day. One of my colleagues was trying to gather data from a HTML page and run some reports. He could scrape the page and copy the data into Excel, but any operations he tried on the data errored out. He tried every trick in the book (change format of columns etc) but it didn’t help.

A bit of googling and found this new cool function in Excel 2003.

Go to “Data –> Import External Data –> New Web Query” in Excel and you check on this new cool method.

“F1” in Excel rules :)..