Import Yellow Pages Result to Excel

8 posts / 0 new
Last post
Shyrightupthere...
Import Yellow Pages Result to Excel

Hi all!

Does anyone know how to take the results from Yellow Pages or White pages and import it into Excel?

 

Thank you!

   

hubby
Re: Import Yellow Pages Result to Excel

Is there a particular website you are getting your results from?

Shyrightupthere...
Re: Import Yellow Pages Result to Excel

Google and Phonenumber.com

hubby
Re: Import Yellow Pages Result to Excel

if I remember correctly, you can no longer use Google to directly do phone-number lookups.
Usually, if you have a list of data (like phone numbers, addresses, etc), you could copy it from the web-page and paste it into Excel. You could then do "convert text to column" to split up the data into individual columns..
BUT
phoneumber.com has intentionally made it difficult to copy and paste all the data (phone book entries) at once without also getting the ads and other crap.. so, you could copy and paste each phonebook listing result, one at a time, into Excel, do your convert from text-to column, then go on to the next one.. Obviously if you are dealing with more than 4 or 5 results, this may not be workable, which is exactly the way phonenumber.com wants it.. You might be able to copy the entire page (ads and all), but i'm not sure what will happen when you paste it into Excel .. Try it!

Shyrightupthere...
Re: Import Yellow Pages Result to Excel

ok thank you for your help!

Gina
Re: Import Yellow Pages Result to Excel

Try http://www.yp-to-excel.inc.se

Save Yellow Pages to Excel. It's Freeware.

cherise
Re: Import Yellow Pages Result to Excel

this does not work

uma
Re: Import Yellow Pages Result to Excel
Do you want to import yellow pages directories results and white pages directories results to excel. Then try the free trial of ListGrabber Software http://www.egrabber.com/TU4230k97

Add new comment