How to Build a Hotel Prospect List in Excel

If you sell to hotels, the hotel data is a ready-made list of accounts. This guide shows how to cut it down in Excel to the hotels that fit your product, by country, class, rating, chain and the contact details available, and which columns to keep for your CRM.

Start from the right sheet

Open the Hotels sheet of the free sample (or your delivered file). There is one row per hotel. Select any cell and press Ctrl+T to turn the range into a table: filters appear on every header, and formulas you add keep working as you filter.

Before filtering, hide the columns you do not need for prospecting. The groups that matter most are location, contacts and details; prices, polygons and neighbourhood columns can wait. The data dictionary lists every column by group.

Step 1: filter to your segment

Country and city

Filter country_name (or country_code) to your sales territory, then ld_city if you work city by city. In the sample, the largest countries are Spain (41), Greece (32), Germany (23), Austria (16).

Hotel class

Filter hotel_class to the star levels your product serves. Premium linen or amenity ranges usually target four and five stars; budget PMS software, two and three stars. In the sample, the split is:

Hotel class of the 250 sample hotels
ClassHotels
5★45
4★91
3★49
2★7
1★1
Unclassified57

Do not drop unclassified hotels without a look: many independent and boutique properties simply do not list a star class.

Rating and size

Use a number filter on rating ("greater than or equal to") to focus on well-reviewed properties, and on review_count to favour busy ones. Review count is a rough proxy for size and guest volume. If floor area matters, building_area_m2 gives the footprint of the building.

Chain or independent

brand and chain_from_website identify chain hotels; parent_name shows a parent group where one is listed. Chains often buy centrally, so one contact can open many properties, while independents decide locally. Filter brand to blanks for independents, or to a list of brands for a chain campaign. In the sample, brand is filled for 30 of 250 hotels, so most sample hotels are independents or unbranded.

Operating status

Keep only operating hotels: filter status and make sure closed_month is empty. last_confirmed_month shows when the hotel was last confirmed operating.

Step 2: keep the hotels you can reach

Filter out rows with no route in. In the sample, phone is filled for 220 and website for 217 of the 250 hotels. The full dataset adds publicly listed business email addresses, WhatsApp and social profiles (Facebook, Instagram, LinkedIn, X, TikTok, YouTube) where the property publishes them; see contact details for which fields the current sample includes.

Use domain to remove duplicates: hotels that share a domain usually share a sales contact, so keep one row per domain for a first campaign and attach the others to it.

Step 3: choose the columns for your CRM

A lean import has one column per CRM field. A practical set:

Suggested columns for a CRM import
CRM fieldColumn
External IDld_id: stable across monthly releases, so later updates match
Account namename
Addressstreet_address, postal_code, ld_city, country_name
Phone / websitephone, website
Segmenthotel_class, rating, review_count
Groupbrand, chain_from_website
Map pinlatitude, longitude

Copy the filtered table to a new sheet with Paste Special → Values, then save it as CSV UTF-8 for the import. Keeping ld_id as the external ID is the single most useful habit: next month's file updates the same records instead of creating duplicates.

Step 4: prioritise

Sort the list so the best fits come first. A simple score in a new column works well, for example points for the right class, a rating above your threshold, a high review count and a chain you already serve. Monthly change files add timing signals: a hotel that recently appeared (first_seen_month) or changed its amenities (amenities_added) may be buying right now. See Track hotel openings and closures.

Step 5: use it lawfully

The contact fields are business details as published by the properties themselves. You are responsible for using them in line with GDPR/ePrivacy, CAN-SPAM and local anti-spam and data-protection rules: identify yourself, offer an opt-out and honour it. The data licence allows lawful sales and marketing outreach for your own business, but not reselling or sharing the list.

Step 6: keep the list current

A prospect list goes stale quickly: hotels open, close, change owners and rebrand. If you take monthly updates, each release arrives with a change file. Join it to your CRM on ld_id and act on three kinds of change. New hotels in your segment become new accounts. Hotels with a closed_month should be marked inactive so nobody calls them. Changes to brand, name_history or website often mean a new owner or operator, which is a good reason to get in touch again. For a one-off purchase, plan a refresh before a major campaign rather than reusing a file that is a year old.

Where to go next

See sales prospecting for hotel suppliers, or tell us your territory and segment and we will send counts of matching hotels and how many have each contact field.

Get the data

Download the free Excel sample to see every column with real rows, or tell us the countries and fields you need for counts and a quote. We reply within 24 hours.

Download free sample Contact us