How to get a list of hotels in a city with ratings and contacts in one sheet
Which lodging types to include, which columns to keep (stars, rating, reviews, chain, phone, website) and how to land a list of hotels in a city with ratings in a spreadsheet.
Part of the guide Location intelligence automation
To get a list of hotels in a city with ratings, search a places database for every lodging type you count as a hotel, across the whole city rather than its centre, and keep a small set of columns: name, type, star class where known, guest rating, number of reviews, chain or independent, phone, website, address and position. Remove duplicates, then send the rows to a spreadsheet your team already works in.
Hotel lists are a staple for suppliers (linen, laundry, food, amenities), for event planners booking room blocks, for software sellers, for tourism offices and for airlines arranging crew rooms. Each needs slightly different columns, but all need the same base sheet. Here is how to build it, what to watch for, and an AI employee that keeps it up to date.
How many hotels to expect
Counts vary widely between cities. xMap's places database lists 2,408 hotels within 10 km of the centre of London, 543 within 10 km of the centre of Sydney and 312 within 10 km of the centre of Toronto (November 2026). Guest ratings differ too: Toronto's average 3.8 out of 5 across the 167 that have a rating, while the hotels nearest the centres of London and Sydney average 4.1.
London's count is far above what one search returns, so a full London sheet needs the city split into parts. Toronto and Sydney fit in fewer searches.
Decide what counts as a hotel
The database has many lodging types. Hotel is the main one, and around it sit Resort hotel, Extended stay hotel, Motel, Hostel, Guest house, Capsule hotel and others. A laundry service wants hotels, resorts and guest houses but not hostels; an airline crew office wants hotels near the airport only; a tourism office wants everything. Write the list of types down before you search. Nearby places takes up to 12 types in one block.
The columns worth keeping
| Column | Why it matters |
|---|---|
| name, category | Who and what kind of lodging |
| hotel_stars | Star class, where the database knows it |
| rating, reviews | Guest score and how many people gave it |
| chain, brand | Group-owned or independent, and which group |
| phone, website | How to reach the property |
| address, lat, lng | Where it is, for maps and routes |
| area | Which district it was found in |
Fields Nearby places returns for each hotel; star class and contacts only where the database has them.
Star class and guest rating answer different questions. Stars describe facilities; the rating says how guests felt. A three-star property rated 4.6 by hundreds of guests is often a better partner than a five-star rated 3.9.
A worked example
These numbers are made up. An amenities supplier in Nairobi wants mid-range hotels with good guest scores to offer a new toiletries range.
- An Area of interest covers five districts of the city.
- Nearby places searches Hotel, Resort hotel and Guest house in each, open places only, with a phone or website. It returns 410 rows.
- Remove duplicates leaves 388.
- A Filter keeps those rated 4.0 or more with at least 100 reviews: 152 hotels.
- Sort and limit orders them by reviews, highest first.
- The rows go to Google Sheets, one row per hotel, which the sales team annotates with call notes.
Branded hotels often buy amenities centrally, so the team splits the sheet by the chain column: chains go to the key-account manager, independents to the field reps.
Mistakes to avoid
- Only the Hotel type. Resorts, guest houses and serviced stays fall out of the list.
- One search in a big city. You get the hotels nearest the centre and none of the airport or suburbs.
- Ranking by rating alone. A 5.0 from four guests outranks a 4.6 from two thousand. Sort and limit by rating puts places with very few reviews after the others, but a review minimum in a Filter is clearer.
- Confusing stars and ratings. Keep both columns and read them separately.
- Stale contacts. Hotels change managers and phone numbers. Refresh the sheet, do not just add to it.
An AI employee that keeps the sheet current
Built once, the sheet can update itself. The workflow automation guide covers schedules and sheets in more depth.
- Schedule, monthly.
- Area of interest with your districts.
- Nearby places with your lodging types, open, with a phone or website.
- Remove duplicates.
- Only new in one branch, for hotels that appeared since last month.
- What changed in another, for hotels whose rating moved, or that closed or changed phone or website.
- Google Sheets for the rows and Email for a short summary.
The monthly email says how many hotels were added, which closed and whose rating moved. Starting points: Hotels near the convention centre for room blocks, Hotels near the airport, by how guests rate them and Hotels for my commercial laundry service.
Questions
Do I get star ratings and guest ratings?
Each hotel comes with its guest rating and number of reviews. Star class is included where the database knows it, which is not for every property.
Can I export the list to Excel or Google Sheets?
Yes. End the flow with the Google Sheets app to write a row per hotel, or save the results as a table in My data and download a CSV.
How do I include guest houses and serviced apartments?
Add their types to Nearby places alongside Hotel. Each type is its own search, up to 12 types in one block.
How do I separate chain hotels from independents?
Each hotel carries a chain flag and its brand. Filter on it, or set Chains in Nearby places to Only chains or Only independents.
Templates that do this
Read next
More on business and places data · Every article · Templates