List Only

What is the easiest way to make an Excel based listing of names and addresses off a list on the Internet?

Am I going to have to type it all out to get it on excel...or is there some software or tool that I can use to read it off the web and put it into an Excel spreadsheet. I want to make a list of the names and addresses of all the state politicians and then use it in Excel to print mailing labels.

Public Comments

1. Depending on how the list is formatted on the web site, you may be able to copy the text and then paste it in Excel and then use Data\Text To Columns to separate the data into separate cells. This may be difficult because addresses are widely variable in their formatting. You might also try using... Data\Import External Data\New Web Query ...to import the data from the web site. .
2. Easiest way would be to copy the data, put commas between the fields (name, address line 1 etc) and then IMPORT into Excel as CSV (Comma Separated Values). Its not perfect but is the fastest and easiest way for you to do it and to be sue the ordering is right... If you do a search you may already find the details in CSV format on the Web