Build a One-Shot Competitor Analysis Sheet From Tripadvisor Into Excel

The Scenario

You are a revenue manager at a boutique hotel in Amsterdam. Your general manager is presenting at the ownership meeting Friday and she wants a competitor set slide: the top 10 hotels in Amsterdam on Tripadvisor, with ratings, review counts, price levels, and links — something the ownership group can look at and compare.

She sent the request Thursday afternoon. The meeting is at 9 AM Friday.

The bad version:

• Search "top hotels Amsterdam Tripadvisor" in a browser, click into individual property pages, copy the rating and review count for each
• Paste the data into a workbook, hotel by hotel, switching between the browser and Excel ten times
• Finish at hotel nine, realize the review counts are not consistent across the properties because some came from the summary view and some from the full reviews page

The ownership deck is 80% done. This competitor table should not be what keeps you at the office until 8.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook, calls the Tripadvisor search and details endpoints in sequence, and writes a complete competitor table — hotel name, rating, review count, price level, and URL — in one operation.

Here is the prompt for this specific task:

For each city and its TripAdvisor location ID in columns A and B of my sheet, find the 5 nearest hotels and write their names, ratings, and review counts into a results tab organized by city

What You Get

• Column A: City name (repeated per hotel row)
• Column B: Hotel name
• Column C: Overall Tripadvisor rating
• Column D: Total review count
• Results organized by city in the results worksheet, with one row per hotel

What If the Data Is Not Quite Ready

You need a full top-10 list for a single city with price levels and direct links

Find the top 10 TripAdvisor hotels near location ID 188633 (Amsterdam) and for each one write the hotel name, rating, number of reviews, price level, and TripAdvisor URL into this workbook — one row per hotel

You want results filtered to properties with more than a minimum review count

Find the top 10 TripAdvisor hotels near location ID 188633, filter to only properties with more than 300 reviews, and write hotel name, rating, review count, price level, and TripAdvisor URL into this workbook

You want to add your own property as a benchmark row at the bottom of the table

Find the top 10 TripAdvisor hotels near location ID 188633, write name, rating, review count, price level, and URL into rows 2 through 11, then in row 12 fetch the details for TripAdvisor location ID 12345 (our property) and write the same fields so we can compare directly

You want the full competitor table plus a positioning summary for the ownership slide

Find the top 10 TripAdvisor hotels near location ID 188633, write name, rating, review count, price level, and URL into the Competitors worksheet, then in cell A1 of the Summary worksheet write three bullet points: where the rating midpoint falls, where the highest-reviewed property sits, and where our property stands relative to the group if our location ID is 12345

Three bullets drawn from live data, written as part of the same prompt as the table itself.

Try It

Get the 7-day free trial of SheetXAI and open a blank Excel workbook before your next revenue review, then ask it to pull the top competitor hotels for your destination with ratings, review counts, price levels, and links. You can also ask it to pull the most recent reviews for each competitor or to check which properties hold current Travelers Choice Awards.