Blog > Web Scraping > Post

How to Scrape Yelp Data to Excel: Business Names, Phone Numbers, Addresses, Reviews...

Wednesday, January 27, 2021

How to gather Yelp dataset for your own use? To scrape data from Yelp, it only takes 5 minutes to build a Yelp Data Scraper with Octoparse. 


Step 1:  Input the Yelp website URL to build a Yelp Scraper

You can do this by simple copy-and-paste. Give it a few seconds. Octoparse will detect the webpage data automatically. Once the detection is done, you can see data fields highlighted in red. This means that all the highlighted data is preselected by the bot.  


how to scrape yelp data to excel



Step 2: Check the pagination settings and the data preview

Pagination is a setting to scrap Yelp across multiple age. Usually, the pagination button is auto-detected, and you can check its position. But if that’s not the case, you can easily select the button manually by clicking on “edit” on the Tips panel and confirm your selection.

There is a data preview section below that allows you to preview your data at the bottom and choose how you'd like the data to appear. For example, you can edit the names of the data fields, change the sequence or delete them.  

Step 3: Create your workflow and execute the Yelp Scraper

Once you’ve made sure the data columns look perfect, simply hit “create workflow” and Octoparse will auto-generate a scraping workflow for you on the left-hand side. The workflow tells us that our crawler will extract the listing data one by one on the first page, and then head to the following pages to repeat the extraction on each page. 

You can choose to run your crawler on your computer or on Octoparse cloud servers. We usually recommend the latter as it allows you to schedule your extractions and can get data for you while you are sleeping. But the local extraction also works great for a one-time project. It is totally up to you. 

When you’ve got enough data, just stop the extraction and export it into formats of your choice such as Excel, JSON, CSV, HTML, etc. Octoparse also allows you to export the data to your database or data visualization tools via Octoparse APIs. 


Besides Yelp, Octoparse can also crawl Yellowpages, Google Maps, Amazon, eBay, Twitter, Instagram, and many other websites. You can check out our web scraping tutorials and shoot us an email at support@octoparse.com. If you are in need of data, we are so ready to help! 


Author: Milly

Related resources

9 Ways E-commerce Data Can Fuel Your Online Business

3 Most Practical Uses of eCommerce Data Scraping Tools

How Big Data helps your Ecommerce business grow

Top 20 Web Crawling Tools to Scrape Website Quickly

Video:3 Easy Steps to Boost Your eCommerce Buiness

Video:How Big Companies Build Their Price Comparison Model



Download Octoparse to start web scraping or contact us for any
question about web scraping!

Contact Us Download
We use cookies to enhance your browsing experience. Read about how we use cookies and how you can control them by clicking cookie settings. If you continue to use this site, you consent to our use of cookies.
Accept decline