Find emails of businesses in Excel list (from the web)

[RE_NERO]

Hi guys,

I have an Excel list of 483 Australian businesses (please see below an extract of the list).

As you can see the list shows the business type, name, location, state and post code.

The million dollar question is: Are you guys aware of any way to find out the contact email for these businesses? (I would like to avoid manually googling each business if I can! :D)

I have already spent 3 days searching the web but I couldn't find any solutions. Most of the advice were about finding out the business email of a specific person if I already knew the name of that person.

I am also not restricted to using Excel. If you guys are aware of any other way to solve this problem I will happily take it!

Thank you very much in advance to anyone is going to answer

[pjwhitfield]

Its very difficult to do this comprehensively unless theres some website that contains all of these businesses and holds the data in a set format.

For instance, if theres a business listings site that contains these and has the info you want then you could automate a screen scrape to view the pages in turn and extract the data you need but for that to work you need to know where to find the info you want for example it may be held on the page with the words "contact email:" before it and therefore can be identified however if theres no single page or site that contains this then you'll not get the info you need easily.