Get a spreadsheet with Business Name, Phone Number, Address, Website, Rating, and more. You can use this scraper to get business leads and phone numbers from Yellow Pages.
It’s as easy as Copy and Paste
Provide a list of Yellowpages Search Results URLs and extract all business details from Yelp.
Download the data in Excel, CSV, or JSON formats. Link a cloud storage platform like Dropbox to store your data.
| Rank | Business Name | Address | Phone | Average Rating | Total Reviews | Tripadvisor Rating | Tripadvisor Review Count | Bbb Rating | Result Type | Website | Image URL | Category | Snippet | URL | Listing URL | Input |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6 | Marouch Restaurant | 4905 Santa Monica Blvd, Los Angeles, CA 90029 | (323) 662-9325 | 4.5 | 12.0 | - | - | - | Organic | http://www.marouchrestaurant.com | https://i4.ypcdn.com/blob/53f60d9d3cc44abf65689920c7884b87a43489a5_600x600_crop.jpg?3639af0 | Restaurants | Middle Eastern Restaurants | Mediterranean Restaurants | The experience has been fantastic! The staff was helpful and friendly. Delicious food | https://www.yellowpages.com/los-angeles-ca/mip/marouch-restaurant-465004155 | https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA | https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA |
| 5 | Maria's Italian Kitchen | 10761 W Pico Blvd, Los Angeles, CA 90064 | (310) 441-3663 | 5.0 | 7.0 | - | - | - | Organic | http://www.mariasitaliankitchen.com | https://i4.ypcdn.com/blob/eec3d7b8fabf44b5b33742d3b84a71888cd2895d_600x600_crop.jpg?3639af0 | Restaurants | Italian Restaurants | While the quality of the food and service at Maria's Italian Kitchen is exceptional, the prices remain reasonable. The generous portions and high-quality ingredients ensure… | https://www.yellowpages.com/los-angeles-ca/mip/marias-italian-kitchen-459714534 | https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA | https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA |
| 9 | Sor Tino | 908 S Barrington Ave, Los Angeles, CA 90049 | (310) 442-8466 | 5.0 | 3.0 | - | - | - | Organic | http://www.sortinorestaurant.com | https://i4.ypcdn.com/blob/cd721e380d7842721a636d3915020cef18c69fec_600x600_crop.jpg?3639af0 | Restaurants | Italian Restaurants | Caterers | Great Italian food restaurant in this area... Fantastic atmosphere with awesome food, just great... love this restaurant. | https://www.yellowpages.com/los-angeles-ca/mip/sor-tino-8253783 | https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA | https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA |
| 4 | Tacos Baja | 5385 Whittier Blvd, Los Angeles, CA 90022 | (323) 887-1980 | 5.0 | 10.0 | - | - | - | Organic | http://www.lataco.com/taco/tacos-baja-ensenada-east-los-angeles | https://i4.ypcdn.com/blob/338b8e4be762b90c8428d45044a7fa45f3ad4c0c_600x600_crop.jpg?3639af0 | Restaurants | Mexican Restaurants | Seafood Restaurants | Five-star dining at its finest! The ambiance at The Silver Spoon is elegant and welcoming, and the cuisine is exquisite. I particularly enjoyed their seafood risotto - a… | https://www.yellowpages.com/los-angeles-ca/mip/tacos-baja-19218906 | https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA | https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA |
| 3 | Dinah's Family Restaurant | 6521 S Sepulveda Blvd, Los Angeles, CA 90045 | (310) 645-0456 | 4.0 | 11.0 | - | - | - | Organic | - | - | Restaurants | Family Style Restaurants | Caterers | Good place to hangout with family, friends or even children for great food!! Highly recommended! | https://www.yellowpages.com/los-angeles-ca/mip/dinahs-family-restaurant-2371111 | https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA | https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA |
| 2 | Mauro's Restaurant | 8112 Melrose Ave, Los Angeles, CA 90046 | (323) 653-7970 | - | - | - | - | - | Organic | http://www.mauroscafe.com | https://i4.ypcdn.com/blob/ed8ceceb105ce45d01ae408a331980183f8642e0_600x600_crop.jpg?3639af0 | Restaurants | Breakfast, Brunch & Lunch Restaurants | Italian Restaurants | Definitely fine dining....I love the service at the place and the chef is so friendly with the guests and always takes care to offer the best quality! | https://www.yellowpages.com/los-angeles-ca/mip/mauros-restaurant-4381539 | https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA | https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA |
| 1 | Rocco's Neighborhood Pizza | 6335 Wilshire Blvd, Los Angeles, CA 90048 | (323) 655-0058 | 4.5 | 7.0 | - | - | - | Organic | https://roccospizza.la/?y_source=1_MTA0NTQzNzk3MC01NTMtbG9jYXRpb24ud2Vic2l0ZQ%3D%3D | https://i4.ypcdn.com/blob/1467ec00d1f7118158d003a4e45b669848572842_600x600_crop.jpg?3639af0 | Restaurants | Pizza | American Restaurants | Rocco's Italian Kitchen is the best restaurant i had ever seen... Awesome food quality. | https://www.yellowpages.com/los-angeles-ca/mip/roccos-neighborhood-pizza-458023002 | https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA | https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA |
| 8 | The Main Course | 10509 W Pico Blvd, Los Angeles, CA 90064 | (310) 475-7564 | 5.0 | 2.0 | - | - | - | Organic | - | https://i4.ypcdn.com/blob/6d9d6f33ba3f7444bb4554dabf157074af556f64_600x600_crop.jpg?3639af0 | Restaurants | Health Food Restaurants | Family Style Restaurants | Always a great spot to get great food. Restaurant was clean. Staff was friendly, and service was very good.. | https://www.yellowpages.com/los-angeles-ca/mip/the-main-course-9633827 | https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA | https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA |
| 7 | The Boiling Crab | 3377 Wilshire Blvd Ste 115, Los Angeles, CA 90010 | (213) 389-2722 | 4.5 | 6.0 | - | - | - | Organic | http://www.theboilingcrab.com | https://i4.ypcdn.com/blob/e3be67e597749e3a6b50962ff644189a0593ead1_600x600_crop.jpg?3639af0 | Restaurants | Seafood Restaurants | Fish & Seafood Markets | We enjoyed our food, specially butter garlic crab.. Did not have to wait long. Incredible service. | https://www.yellowpages.com/los-angeles-ca/mip/the-boiling-crab-461549610 | https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA | https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA |
[
{
"address": "4905 Santa Monica Blvd, Los Angeles, CA 90029",
"average_rating": "4.5",
"bbb_rating": null,
"business_name": "Marouch Restaurant",
"category": "Restaurants | Middle Eastern Restaurants | Mediterranean Restaurants",
"image_url": "https://i4.ypcdn.com/blob/53f60d9d3cc44abf65689920c7884b87a43489a5_600x600_crop.jpg?3639af0",
"input": "https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA",
"listing_url": "https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA",
"phone": "(323) 662-9325",
"rank": "6",
"result_type": "Organic",
"snippet": "The experience has been fantastic! The staff was helpful and friendly. Delicious food",
"total_reviews": "12",
"tripadvisor_rating": null,
"tripadvisor_review_count": null,
"url": "https://www.yellowpages.com/los-angeles-ca/mip/marouch-restaurant-465004155",
"website": "http://www.marouchrestaurant.com"
},
{
"address": "10761 W Pico Blvd, Los Angeles, CA 90064",
"average_rating": "5.0",
"bbb_rating": null,
"business_name": "Maria's Italian Kitchen",
"category": "Restaurants | Italian Restaurants",
"image_url": "https://i4.ypcdn.com/blob/eec3d7b8fabf44b5b33742d3b84a71888cd2895d_600x600_crop.jpg?3639af0",
"input": "https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA",
"listing_url": "https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA",
"phone": "(310) 441-3663",
"rank": "5",
"result_type": "Organic",
"snippet": "While the quality of the food and service at Maria's Italian Kitchen is exceptional, the prices remain reasonable. The generous portions and high-quality ingredients ensure…",
"total_reviews": "7",
"tripadvisor_rating": null,
"tripadvisor_review_count": null,
"url": "https://www.yellowpages.com/los-angeles-ca/mip/marias-italian-kitchen-459714534",
"website": "http://www.mariasitaliankitchen.com"
},
{
"address": "908 S Barrington Ave, Los Angeles, CA 90049",
"average_rating": "5.0",
"bbb_rating": null,
"business_name": "Sor Tino",
"category": "Restaurants | Italian Restaurants | Caterers",
"image_url": "https://i4.ypcdn.com/blob/cd721e380d7842721a636d3915020cef18c69fec_600x600_crop.jpg?3639af0",
"input": "https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA",
"listing_url": "https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA",
"phone": "(310) 442-8466",
"rank": "9",
"result_type": "Organic",
"snippet": "Great Italian food restaurant in this area... Fantastic atmosphere with awesome food, just great... love this restaurant.",
"total_reviews": "3",
"tripadvisor_rating": null,
"tripadvisor_review_count": null,
"url": "https://www.yellowpages.com/los-angeles-ca/mip/sor-tino-8253783",
"website": "http://www.sortinorestaurant.com"
},
{
"address": "5385 Whittier Blvd, Los Angeles, CA 90022",
"average_rating": "5.0",
"bbb_rating": null,
"business_name": "Tacos Baja",
"category": "Restaurants | Mexican Restaurants | Seafood Restaurants",
"image_url": "https://i4.ypcdn.com/blob/338b8e4be762b90c8428d45044a7fa45f3ad4c0c_600x600_crop.jpg?3639af0",
"input": "https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA",
"listing_url": "https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA",
"phone": "(323) 887-1980",
"rank": "4",
"result_type": "Organic",
"snippet": "Five-star dining at its finest! The ambiance at The Silver Spoon is elegant and welcoming, and the cuisine is exquisite. I particularly enjoyed their seafood risotto - a…",
"total_reviews": "10",
"tripadvisor_rating": null,
"tripadvisor_review_count": null,
"url": "https://www.yellowpages.com/los-angeles-ca/mip/tacos-baja-19218906",
"website": "http://www.lataco.com/taco/tacos-baja-ensenada-east-los-angeles"
},
{
"address": "6521 S Sepulveda Blvd, Los Angeles, CA 90045",
"average_rating": "4.0",
"bbb_rating": null,
"business_name": "Dinah's Family Restaurant",
"category": "Restaurants | Family Style Restaurants | Caterers",
"image_url": null,
"input": "https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA",
"listing_url": "https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA",
"phone": "(310) 645-0456",
"rank": "3",
"result_type": "Organic",
"snippet": "Good place to hangout with family, friends or even children for great food!! Highly recommended!",
"total_reviews": "11",
"tripadvisor_rating": null,
"tripadvisor_review_count": null,
"url": "https://www.yellowpages.com/los-angeles-ca/mip/dinahs-family-restaurant-2371111",
"website": null
},
{
"address": "8112 Melrose Ave, Los Angeles, CA 90046",
"average_rating": null,
"bbb_rating": null,
"business_name": "Mauro's Restaurant",
"category": "Restaurants | Breakfast, Brunch & Lunch Restaurants | Italian Restaurants",
"image_url": "https://i4.ypcdn.com/blob/ed8ceceb105ce45d01ae408a331980183f8642e0_600x600_crop.jpg?3639af0",
"input": "https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA",
"listing_url": "https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA",
"phone": "(323) 653-7970",
"rank": "2",
"result_type": "Organic",
"snippet": "Definitely fine dining....I love the service at the place and the chef is so friendly with the guests and always takes care to offer the best quality!",
"total_reviews": null,
"tripadvisor_rating": null,
"tripadvisor_review_count": null,
"url": "https://www.yellowpages.com/los-angeles-ca/mip/mauros-restaurant-4381539",
"website": "http://www.mauroscafe.com"
},
{
"address": "6335 Wilshire Blvd, Los Angeles, CA 90048",
"average_rating": "4.5",
"bbb_rating": null,
"business_name": "Rocco's Neighborhood Pizza",
"category": "Restaurants | Pizza | American Restaurants",
"image_url": "https://i4.ypcdn.com/blob/1467ec00d1f7118158d003a4e45b669848572842_600x600_crop.jpg?3639af0",
"input": "https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA",
"listing_url": "https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA",
"phone": "(323) 655-0058",
"rank": "1",
"result_type": "Organic",
"snippet": "Rocco's Italian Kitchen is the best restaurant i had ever seen... Awesome food quality.",
"total_reviews": "7",
"tripadvisor_rating": null,
"tripadvisor_review_count": null,
"url": "https://www.yellowpages.com/los-angeles-ca/mip/roccos-neighborhood-pizza-458023002",
"website": "https://roccospizza.la/?y_source=1_MTA0NTQzNzk3MC01NTMtbG9jYXRpb24ud2Vic2l0ZQ%3D%3D"
},
{
"address": "10509 W Pico Blvd, Los Angeles, CA 90064",
"average_rating": "5.0",
"bbb_rating": null,
"business_name": "The Main Course",
"category": "Restaurants | Health Food Restaurants | Family Style Restaurants",
"image_url": "https://i4.ypcdn.com/blob/6d9d6f33ba3f7444bb4554dabf157074af556f64_600x600_crop.jpg?3639af0",
"input": "https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA",
"listing_url": "https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA",
"phone": "(310) 475-7564",
"rank": "8",
"result_type": "Organic",
"snippet": "Always a great spot to get great food. Restaurant was clean. Staff was friendly, and service was very good..",
"total_reviews": "2",
"tripadvisor_rating": null,
"tripadvisor_review_count": null,
"url": "https://www.yellowpages.com/los-angeles-ca/mip/the-main-course-9633827",
"website": null
},
{
"address": "3377 Wilshire Blvd Ste 115, Los Angeles, CA 90010",
"average_rating": "4.5",
"bbb_rating": null,
"business_name": "The Boiling Crab",
"category": "Restaurants | Seafood Restaurants | Fish & Seafood Markets",
"image_url": "https://i4.ypcdn.com/blob/e3be67e597749e3a6b50962ff644189a0593ead1_600x600_crop.jpg?3639af0",
"input": "https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA",
"listing_url": "https://www.yellowpages.com/search?search_terms=restaurant&geo_location_terms=Los+Angeles%2C+CA",
"phone": "(213) 389-2722",
"rank": "7",
"result_type": "Organic",
"snippet": "We enjoyed our food, specially butter garlic crab.. Did not have to wait long. Incredible service.",
"total_reviews": "6",
"tripadvisor_rating": null,
"tripadvisor_review_count": null,
"url": "https://www.yellowpages.com/los-angeles-ca/mip/the-boiling-crab-461549610",
"website": "http://www.theboilingcrab.com"
}
]
Get the latest phone numbers and addresses along with the number of reviews and ratings for each business, allowing you to get quality leads.
Does not renew
Compare all features &
choose what works best for you
Need More?
Contact us for a custom plan based on your needs.
Join 12400+ customers who love working with ScrapeHero
A few mouse clicks and copy/paste is all that it takes!
Get data like the pros without knowing programming at all.
The crawlers are easy to use, but we are here to help when you need help.
Schedule the crawlers to run hourly, daily, or weekly and get data delivered to your Dropbox.
We will take care of all website structure changes and blocking from websites.
Can’t find what you’re looking for? Check out Cloud Support for assistance!
All our plans require a subscription that renews monthly. If you only need to use our services for a month, you can subscribe to our service for one month and cancel your subscription in less than 30 days.
Yes. You can set up the crawler to run periodically by clicking and selecting your preferred schedule. You can schedule crawlers to run on a Monthly, Weekly, or Hourly interval.
No, We won’t use your IP address to scrape the website. We’ll use our proxies and get data for you. All you have to do is, provide the input and run the scraper.
Unfortunately, we will not be able to provide you a refund/data credits if you made a mistake.
Here are some common scenarios we have seen for quota refund requests
If you cancel, you’ll be billed for the current month, but you won’t be charged again. If you have any page credits, you can still use our service until it reaches its limit.
Some crawlers can collect multiple records from a single page, while others might need to go to 3 pages to get a single record. For example, our Amazon Bestsellers crawler collects 50 records from one page, while our Indeed crawler needs to go through a list of all jobs and then move into each job details page to get more data.
All our data credit reset at the end of the billing period. Any unused credits do not carry over to the next billing period and also are nonrefundable. This is consistent with most software subscription services.
Sure, we can build custom solutions for you. Please contact our Sales team using this link, and that will get us started. In your message, please describe in detail what you require.
Most sites will display product pricing, availability and delivery charges based on the user location. Our crawler uses locations from US states so that the pricing may vary. To get accurate results based on a location, please contact us.
Contact us to schedule a brief, introductory call with our experts and learn how we can assist your needs.
Legal Disclaimer: ScrapeHero is an equal opportunity data service provider, a conduit, just like an ISP. We just gather data for our customers responsibly and sensibly. We do not store or resell data. We only provide the technologies and data pipes to scrape publicly available data. The mention of any company names, trademarks or data sets on our site does not imply we can or will scrape them. They are listed only as an illustration of the types of requests we get. Any code provided in our tutorials is for learning only, we are not responsible for how it is used.