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:
| Class | Hotels |
|---|---|
| 5★ | 45 |
| 4★ | 91 |
| 3★ | 49 |
| 2★ | 7 |
| 1★ | 1 |
| Unclassified | 57 |
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:
| CRM field | Column |
|---|---|
| External ID | ld_id: stable across monthly releases, so later updates match |
| Account name | name |
| Address | street_address, postal_code, ld_city, country_name |
| Phone / website | phone, website |
| Segment | hotel_class, rating, review_count |
| Group | brand, chain_from_website |
| Map pin | latitude, 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.