The list is just ascending lines of text.
i.e.

Business Name
Address
City, State Zip
Phone
Business Description
< space >
Business Name 2
Address
City, State Zip
Phone
Business Description
< space >
…

And I want to extract this data and automatically put it into an Excel file where each business is in a separate row.
Columns would be:
Business - Address - City - Phone - Description

I prefer that the software be free. I have MS Office 2003 and know Excel pretty well, but not well enough to do this.
(I can copy and paste the business address listings into Excel, but they are not formatted the way I want). I thought about using a macro, but wasn't able to get this to work.
Thanks!!!

Caffeinated Content

Related Articles:

• What drives more subscriber clicks to a comapny homepage, a sales email or an article publication?
• i want to transfer a list of names from my personal yahoo to my business 'domain'.how do I do that?
• how to create opt-in form?
• Please someone help me with my yahoo email account. It works OK on other computers but not on mine?
• how do i send out one email to a list of people?

One Response to “How can I extract a list of mailing addresses from a website into Excel?”

1. T G on December 2nd, 2008 10:21 pm

   learn how to 'parse' information.