Import from HTML

[Guest]

I need to import name & address data held in 2 columns on HTML pages (one
page per name & address) on our intranet into a spreadsheet (one row per
entry). Any ideas?

 

[Paul Corrado]

Have you tried

Data/Get External Data/New Web Query

You can use this to import an entire web page, or if the data you seek is in
a table, just that table.

 

[David McRitchie]

Hi Doug,
Maybe you have your answer since you didn't say that you didn't,
but if you data is in two columns it sounds like something from a
database. With the what you want for the column title in column A
and the item in Column B.

Creating a Spreadsheet from Database data (#dbdata)
http://www.mvps.org/dmcritchie/excel/snakecol.htm#dbdata