The Expedia Affiliate Network is an excellent source of Hotel information and has REST API’s that you can use in Excel 2013 via Power Query. You can register for an account via http://developer.ean.com/

 image

Once you register for an API key, you can review the API documentation for Hotel Lists at http://developer.ean.com/docs/hotel-list/. The Query string that I used for getting a list of all available hotels in Seattle was:

http://api.ean.com/ean-services/rs/hotel/v3/list?cid=55505&apiKey=YOURAPIKEY&locale=en_US&currencyCode=USD

&city=Seattle&stateProvinceCode=WA&countryCode=US&supplierCacheTolerance=MED_ENHANCED

There are various parameters that you can experiment with to get variations of the data that includes hotel availability for specific dates or with specific amenities and so on.

Once you import the data into Excel, you can analyze the data using Power View or Power Map to slice and dice the data and make data-driven decisions. Here is an example of a visualization that I put together with Power View.

Hotel

 image