Free YellowPages Scraper – Yellow Pages
This bot that I made was originally going to be sold, but I decided to give it away. Not exactly sure why I did this because I know I could make some decent money off of it.
What it does is scrapes the listings off Yellow Pages (yellowpages.com) and puts them in a CSV file. When you open the program you need to browse to where ever you would like to start scraping. The script needs to be on the results page when you hit start.
Here’s the source code for you UBot developers. (Right Click -> Save As)
The program is for people only with the UBot Software. In order to get this program and use it you need to purchase UBot Studio.
Requirements:
IE8 Installed
Microsoft .NET 3.5 Framework Installed
This is for educational purposes only. I do not recommend or condone coping and using other sites content for your personal benefit.
Comments
51 Comments on Free YellowPages Scraper – Yellow Pages
-
Marc on
Sun, 6th Dec 2009 12:32 pm
-
Will on
Sun, 6th Dec 2009 2:04 pm
-
AJ on
Sun, 6th Dec 2009 3:06 pm
-
Dave on
Sun, 6th Dec 2009 3:10 pm
-
Dave on
Sun, 6th Dec 2009 3:16 pm
-
Onoby on
Sun, 6th Dec 2009 4:05 pm
-
onoby on
Sun, 6th Dec 2009 6:36 pm
-
Acemenace on
Sun, 6th Dec 2009 8:55 pm
-
Acemenace on
Sun, 6th Dec 2009 9:48 pm
-
AJ on
Mon, 7th Dec 2009 1:29 pm
-
NJ Ad Agency on
Mon, 7th Dec 2009 4:33 pm
-
Aaron on
Tue, 8th Dec 2009 7:11 am
-
Aaron on
Sun, 13th Dec 2009 12:40 pm
-
AJ on
Sun, 13th Dec 2009 8:25 pm
-
Acemenace on
Sun, 13th Dec 2009 9:41 pm
-
Acemenace on
Mon, 14th Dec 2009 8:44 pm
-
Acemenace on
Mon, 14th Dec 2009 9:33 pm
-
Unclaimed Money Guide on
Fri, 18th Dec 2009 2:39 pm
-
john on
Tue, 29th Dec 2009 11:25 am
-
gagol on
Fri, 29th Jan 2010 3:42 pm
-
tom on
Wed, 17th Feb 2010 7:48 am
-
turbolapp on
Sat, 20th Feb 2010 4:33 pm
-
Dustin on
Tue, 6th Apr 2010 8:32 pm
-
Dvon on
Sun, 11th Apr 2010 11:29 pm
-
Dvon on
Mon, 12th Apr 2010 8:34 am
-
Dvon on
Sat, 17th Apr 2010 7:56 pm
-
Brandon on
Thu, 22nd Apr 2010 2:16 pm
-
David Ford on
Wed, 26th May 2010 12:18 am
-
Dvonz on
Thu, 27th May 2010 6:58 pm
-
Russell on
Wed, 23rd Jun 2010 11:27 am
-
Michael Robinson on
Tue, 6th Jul 2010 12:14 am
Nice dude! Saves me from having to do this myself; much appreciated!
[Reply]
You’re the freakin man! Thanks.
[Reply]
Hi I downloaded your yellow page scraper. I ran the program but I can’t seen to figure out where the output .csv file is or how to link it or how to save it through the program? Please give me some detailed instructions on how to do this.
Thank you very much.
AJ
[Reply]
It is working now with the new download!!! Thanks so much!!!!
[Reply]
Does this check for duplicates? And is there any way to get all the categories, basically every business in a particular town or zip code?
[Reply]
Aaron Reply:
December 6th, 2009 at 6:25 pm
If you run it more than 1 time it will save in a different file. So there could be duplicates between the files.
Whatever you find on the search results is what it will scrape. If you can get it to every business in a particular zip code then it will. Not sure if you can do that though.
[Reply]
i have a problem too i dont see any csv file and it pops up an error !!! pls. help
[Reply]
yes downloaded it 3 times the only thing i got is u-bot folder and 3 text files in it Friendpos,Mailpos,Urls… sorry to bother!
[Reply]
Aaron Reply:
December 6th, 2009 at 6:42 pm
That folder and files have nothing to do with anything with this bot.
All you need to do is download the .exe to anywhere on your computer. Run the .exe and when it is finished it will save the .CSV on your C:\
If you cant find it when it’s done then try a search for “result” and you should be able to locate it.
[Reply]
Thanks dude. You are the man!! Appreciate you doing this.
[Reply]
I get this error – right when it is done scraping all the pages.
http://tinypic.com/r/2cwn72t/6
Any idea why that would happen?
[Reply]
Aaron Reply:
December 7th, 2009 at 12:59 pm
Does it save the .CSV properly even though you are getting that error?
[Reply]
I am having the same problem, does not save the csv file.
[Reply]
We get the same uBot error using Windows 7. Script seems to work good up until the time it needs to export the data.
[Reply]
Looks like the last version I put up is causing that error. I will fix this and update the download links by this weekend. Some of you have a working copy already so you won’t need to update it.
[Reply]
First thanks for the update. The update that I downloaded did not work at all. In the total in the top left corner of the program it stayed at “0″ and the completed stayed at “0″ I did a test of around 600 and it tried to scan 3 or4 pages and then went to your http://www.ubottutorials.com/ypdone.php page.
I am using win XP
[Reply]
Aaron Reply:
December 14th, 2009 at 7:20 am
Are you using IE8? If not, upgrade and try again. Should work.
[Reply]
Works perfect!
[Reply]
I got the first scrape to run fine (and made the comment above
) However, then it started to give me this error when I used the scraper again. – http://tinypic.com/r/3536oec/6
[Reply]
Aaron Reply:
December 15th, 2009 at 5:36 am
Does it stil work if you just hit OK on the errors? Should still go through and save the data. I just need to disable showing the errors.
[Reply]
Hey Aaron. Send you a few bucks.
Thanks for your help and videos.
[Reply]
I tried your yellow pages scraper today.
Every page it attempted to scrape generated a
this page has moved, or the page your are attempting to access is not available.
I ran it a few times for my locale on business I know are available.
I tried it with foxfire and IE browsers active.
I am logged into yellow pages web site on the browser and the browser portion of the scraper but still error, page not available.
Is this my side or a software error?
Thanks…great bots
[Reply]
Aaron Reply:
December 30th, 2009 at 8:49 am
I just tested it and it worked. Just make sure you have IE8 installed and I wouldn’t login YP. You dont need to open FF or IE to get this to work. Just need IE8 installed on your computer.
[Reply]
This bot looks perfect! I downloaded it and tried running it on the Canadian yellowpages.ca site, and though it did scroll through the pages, it didn’t recognize any of the listings. I realize this is free and don’t expect any assistance, just wondering if it would be a quick update to make it work on the Canadian site as well? Here’s a sample of the page I’m trying to scrape:
http://canada411.yellowpages.ca/search/pv-alph/1/restaurant/SK/rca-01125710-Restaurants
Thanks for your time! I’ve been searching for a working scraper for some time now and would be grateful if you have a chance to look at this.
Take care!
[Reply]
Aaron Reply:
December 30th, 2009 at 8:33 am
Suprised it even browsed the pages.
If I ever get some free time maybe I can add Canada on there. Shouldn’t be too difficult to do.
[Reply]
For what is good?
[Reply]
hello love this ubot but were is the yellowpage bot down load…
[Reply]
Hey Aaron,
Just downloaded the bot. NICE WORK! It ran perfectly except at the very end and the output to my documents was completely blank. Any ideas? (Obviously mines in .ubot an not an .exe)
[Reply]
Hello,
Thank you so much for the great bot. However, I’m having trouble getting it to work. I’ve downloaded the latest version above and have downloaded and installed IE 8 has my browser. I can open up the file and search on the site and get the results to show up on yellowpages.com.
I then hit the play button and it goes through all of the pages for the results. However I never see the “Total” and “Completed” feilds change, they always remain at zero.
I can find the cvs file however there’s nothing in it.
I would love to get this to work and if you could help me I would be more then happy to give you a donation for your time and energy.
BTW are you in Hati? I’m curious what it’s like down there. Have you seen Anderson Cooper or Sean Penn running around down there?
Thank you
Dustin
[Reply]
Aaron, I bought Ubot through your link because I need this yellow pages scrapper!!! The problem time… This bot doesn’t work anymore because Yellowpages changed the layout of their site slightly. Any chance to get some help as I bought through your link or an update on this bot so I can get it to work… please,,
[Reply]
Aaron Reply:
April 12th, 2010 at 3:26 am
I will take a look at it sometime this week. Not sure what they changed but I’m guessing it shouldn’t be too hard to change.
[Reply]
Dvon Reply:
April 24th, 2010 at 12:56 am
Any idea of a time yet. I know you must be busy, so you doing this is VERY appreciated.
[Reply]
Dvon Reply:
April 27th, 2010 at 11:03 pm
please please please help…. I really need to get the update on this. I know you must be busy, but I can’t tell you how grateful I’d be if you could update this.
[Reply]
Dvonz Reply:
May 18th, 2010 at 1:01 pm
PLEASE !!!!!!!!!!!!!!!!! Could you find your way to updating it so it works with the new layout……………….. PLEASE……………………..
[Reply]
Dude YOU ROCK!! You got back to me so quick! I thought I was going to be on my own. I’m Really glad I bought thru your link so I could help the cause! Thanks for getting back to me and I look forward t you future reply..
Thanks again so much!
[Reply]
Hey Aaron, hope the weeks been treating you well.
Just wanted to know if you had a chance to look over the yellow pages scrapper for the new format changes that they made. Thanks again for looking into this in advance.
[Reply]
Hey Aaron, just wanted to let you know that I get an error saying I can’t save the file.
Unable to save file
Command: save to file
Thanks!
Brandon
[Reply]
I just wanted to tell ya that I love watching your tutorials. It is helping me a lot on learning how to use it. As soon as I can save up enough money for it, I am ordering the ubot for sure. Of course I will make sure to order from your coupon so you get commission for sure on it. Then after I make some bots and sell them I will also make sure to donate some good money to ya too. I hope to someday be as good as you are on making bots, because being a marketer I can see making massive money from being able to make my own bots, both from selling them and from using them as well for advertising! So pretty soon it’s about to be on like Donkey Kong!!!
[Reply]
Ok, how much will it cost me for you to fix this! You said you’d look at it in a week, that was over a month in a half ago. I bought Ubot through your affiliate link so I could get this and have it work. So you got an affiliate commission and I have nothing. So, How much for you to patch this up. I don’t know if I can afford it or not, but I thought I’d ask. Please let me know. I really do need this now. I don’t mean to be a pain but I hope you could understand my position of buying something and thinking I was going to get a result, then spend a few hundred bucks and not getting what I thought I was going to get. I hope you can see my side and I’d just really appreciate it if you could get back to me with a yes or no and if need be a price.
[Reply]
Aron
I compiled the code but when I run it it just takes to the google home page.
Have you had a chance to see whats wrong wtih the scraper?
[Reply]
I found the error for saving the txt file. It has Aaron’s C: drive as the destination.
But there is another problem. Once the file does get saved, it is completely empty…
If anyone can get this to work, I would really appreciate some help with it.
Thanks,
Michael
[Reply]
Tell me what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!


AJ Reply:
December 6th, 2009 at 3:47 pm
downloaded it agian and it worked, thanks very much. Along with the phone number it also picked up the words CALL and E-mail. Is there any way to delete these from the phone number column easily? Will this ever be able to get the email addresses?
Thanks again, great job!
AJ
[Reply]
Aaron Reply:
December 6th, 2009 at 6:23 pm
I could add E-Mail but only like 4% of the listings even use it so it is actually worthless.
You can do a search and replace and just remove CALL from it.
[Reply]