Web Scraping Google Hotels to Excel Without Coding

Hotel search on Google helps you discover and compare top rated hotels at all locations around the world. It provides details like hotel name, address, rating, price, reviews, amenities and hotel contact details like website address and phone number. In this article you will learn how to scrape Google Hotels listings data to Excel using WebHarvy.

Download & Install WebHarvy

WebHarvy is an easy-to-use visual web scraper which can scrape data from any website. You can download and install the free trial version of WebHarvy locally in your computer. Being a locally installed desktop application (not SAAS), you can get the full version of WebHarvy with a one-time license fee. There are no recurring (monthly) payments. You get the software for life.

Video Demonstration

The following video shows how WebHarvy can be used to easily scrape hotel data from Google. The following data fields are extracted.

  1. Hotel name
  2. Address
  3. Phone number
  4. Rating
  5. Number of reviews
  6. Price
  7. Amneties.

Step-by-step Instructions

The following are the steps which you need to follow (as shown in the above video) to scrape Google Hotels data using WebHarvy.

  1. After installing WebHarvy in your computer, open it. Load the Google Hotels listings page within WebHarvy’s browser. You can use the search and filter options provided by the website to load the data which you are interested in (location, price, rating etc.)
  2. To start selecting data, click the Start button in the Home menu.
  3. Click on the data items which you need. To select the hotel name, click over it and then select the Capture More Content option from the Capture window displayed. Then using mouse, highlight the hotel name from the block of text displayed in the preview area. Click on the Capture Text button.
  4. To configure pagination, click on the Next button at the end of the page. Select the Set as next page link option from the Capture window.
  5. To follow the link of the first hotel, click over its title and select the Follow this link option. Wait for the hotel details page to load.
  6. Once the details page is loaded, you can click and select more data. Hotel price, rating, reviews etc. can be extracted by clicking over it and selecting the Capture Text option from the Capture window.
  7. To open the About tab, click over it and select the Click option. Once the tab is opened, you can click and select details like hotel address, website and phone number.
  8. Once you have selected all required data, Stop configuration.
  9. You may now optionally Save the configuration so that it can be run, edited or scheduled later.
  10. Start Mine to start mining data
  11. Once mining completes, click the Export button to save it as a file or to a database

Have Questions or Need Support?

In case you have any questions or need support in configuring WebHarvy please do not hesitate to contact our technical support.

Related Articles

  1. Scraping TripAdvisor using WebHarvy
  2. WebHarvy Getting Started Guide