Saturday, December 10, 2011

Is there a way to lookup address on Yellow Pages website and download them to excel.?

Its possible. But its only 6 listings at a time. Each listing is preceded by a single digit order from 1 to 6. Only 2 lines below that is useful contain the Company name and Address.





You can automate with Excel macros. But since this is for commercial use, contributors may like to charge you to write the macro for you. so make further enquiries.|||I visited the Yellow Pages web site and the format they use is a mess to import into Excel. There would be so much junk imported along with the data that you want that it would be much quicker to just type it out.





If your are lucky and get a "good" selection, the data can be made usable by using Copy and Paste Transpose, one entry at a time.

No comments:

Post a Comment