how can i convert HTML format tables into microsoft excel format?

Actualy i want to covert annual reports of the company which are in HTML format into microsoft excel.I tried to copy paste but it does not fill in the cells properly.

Public Comments

  1. no way, besides manually entering it in
  2. Potentially you have a few options. You can try to open the file in excel and see what it does, if the table has a consistent delimiter you could have excel use that. You can open the file in word and try to save it as some sort of delimited text. Excel can read tsv (tab separated values) just fine) You can write a macro to do a html -> tsv conversion, here is a page with good some possible macros, http://www.mvps.org/dmcritchie/excel/xl2html.htm here is a search for other possible solutions: http://search.yahoo.com/search;_ylt=A0oGkkJdyjxIU2MBl3yl87UF?p=html%20to%20excel&ei=UTF-8&iscqry=&fr=sfp
  3. The easiest way is to use web query 1. go to menu, data, get external data, new web query 2. 1st box put the url of the page with table, e.g. http://finance.yahoo.com/actives?e=us , click ok, choose whether the result show on new sheet(new sheet recommended), click ok Then after awhile(2-3 min. depending the complexity of the page) you're done
Powered by Yahoo! Answers