Skip to main content

How to export your Tripadvisor reviews to Excel, and search them by name

Tripadvisor has no export and its API returns 5 reviews per location. Import any public listing, search it by name, filter it, and download the lot.

A
Written by Axel Lavergne

Tripadvisor has no export button. You can't download your reviews from the Management Center, and the Content API returns 5 reviews per location, so both official routes stop short.

Reviewflowz imports every review on any public Tripadvisor listing. Search for your business or paste the listing URL, filter the reviews down to what you want, and download the result as a spreadsheet that opens in Excel or Google Sheets.

You can search every review by keyword or by a staff member's name, and attribute reviews to the people who earned them. The export needs a paid subscription, from $45 per location. Free trials can import and search, but not download.

Tripadvisor doesn't let you download your reviews

There is no export on Tripadvisor. Not for your own listing, and not for anyone else's. The Management Center lets you respond to reviews and see how the listing is doing, and that is where it stops.

The API doesn't get you there either. Tripadvisor's Content API returns 5 reviews per location, and you need partner approval to use it at all. Five, out of however many thousand you have.

So everyone ends up looking at scrapers, and there are a million of them. Most are dead slow, unreliable, and don't give you all the data that's on Tripadvisor in the first place.

Reviewflowz is a review management solution with access to Tripadvisor reviews. Paste your listing URL and you get a clean table of every review on it, which you can filter, search and download.

Tripadvisor reviews in a table in Reviewflowz

How to download your Tripadvisor reviews

Add the listing

Choose Tripadvisor, type your business name, and we go and find the listing. No URL needed.

You don't need to claim the listing first either, and you don't need Management Center access. Any public Tripadvisor page works, so you can pull reviews for a property you have never claimed, or for the hotel down the road.

If you already have the URL and you know it is the right listing, paste that instead and we go straight to it. Hotel, restaurant and attraction pages all work, and so do the individual tour pages a tour operator sells. Country domains and language versions work too, so www.tripadvisor.co.uk and fr.tripadvisor.com are both fine. Tripadvisor is one of the platforms we support, so the same works for Google, Facebook and the rest of your listings.

Adding a Tripadvisor listing by searching for the business name

Either way you see what we matched before anything imports: the name, the review count and the rating. Check it is the right one and confirm.

The import pulls every review on the listing. Not the recent ones, not the first page. If Tripadvisor says the page has 3,400 reviews, you get 3,400 reviews, back to the oldest one.

Filter and download

Filter the list down to what you want, then export it. The file contains exactly what was on screen, so if you filtered to every 1 and 2 star from last summer, that is what lands in the spreadsheet.

It builds in the background and takes two to three minutes. You get a notification with the link when it's ready.

The file opens in Excel and in Google Sheets, and it handles every language your reviews come in. Mandarin, Cyrillic, Greek, Arabic, accented Latin. It all comes through as written.

Here is what's in it:

Column

What's in it

Domain

Your own name for the listing

Profile Name

The listing the review came from

Platform

Tripadvisor

Title

The review's headline

Overall

The full body of the review

Score

1 to 5

Link

Straight back to the review on Tripadvisor

Review Date

The exact date, not "3 months ago"

Language

The language the review was written in

Reviewer Name

Whoever left it

Review Locale

The country the review was left from

Photos

URLs of every photo attached to the review

Tags

Your own tags

Attributed to

The team member the review is attributed to

External Review ID

Tripadvisor's own id, so you can match rows across two exports

The Attributed to column only carries attributions that were confirmed. An unvalidated guess never makes it into the file.

The download link expires after seven days and the file is deleted. If you need it again you generate it again.

The same export works on your other platforms, so if you also want your Google reviews in Excel or everything in one CSV, it's the same three steps.

Search your reviews by name

Names are how a lot of owners read their reviews. You want to know which guide, which server, which front desk shift keeps showing up in the good ones.

Tripadvisor has a search box on every listing, the one that says "show reviews that mention". It searches one listing at a time, it shows relative dates, and nothing comes out of it. So whatever you find, you are back to copying rows by hand.

In Reviewflowz, search runs across the full text of every review you have imported. Type a name and you get every review that mentions it, across every listing, with exact dates. It matches on prefixes, so "Maria" also finds "Maria's". It works the same way as searching Google reviews by name, on every platform at once.

Searching Tripadvisor reviews for a staff member name

Text search has a limit though, and it is worth understanding before you rely on it. Guests write what they remember. Maria gets written up as Mary, as Maya, as Mariah. A text search for "Maria" finds none of those, so the count you get is always lower than the truth.

That is what the Attributed to column is for.

Attribute reviews to the right person

Once your team is on the account, every review that names someone is attributed to them. Not by string match, so Mary and Maya land on Maria.

Each person then becomes a filter, the same as rating or date. You can pull one guide's reviews on their own, or ask a real question in one go: every review that mentions Maria, rated 3 or below, still unanswered. Then export it, because the download takes whatever you filtered.

There are three ways to build the roster.

  1. We find them. Our AI reads the reviews you already have and proposes the people it keeps seeing, including nickname and spelling variants. It only suggests someone who appears more than once, so a guest's name mentioned in passing doesn't become a staff member. It never counts role words either. "The staff", "management" and "reception" are not people.

  2. You add them. One at a time in settings, or send us a list and we import it. First name is the only thing we need, though last names make the matching sharper.

  3. You connect the system that already knows. Bókun for tour operators, Toast and Square for restaurants. Bookings and covers come in carrying the person who ran them, so attribution comes from who actually did the work rather than from whether the guest remembered a name.

When the AI isn't sure it says so instead of guessing. Anything below full confidence goes to a validation queue where you confirm or reject it, so your reviews sort into attributed, needs a look, and no attribution.

The attribution validation queue with a suggested match

From there you can group people into teams and see who gets mentioned most and who is rated highest, per person and per team. A review naming two people from the same team counts once for the team. That is the same report as a review leaderboard, built from your Tripadvisor reviews instead of your Google ones.

Staff ranked by number of reviews and average rating

And it all lands in the export. The monthly spreadsheet a lot of managers still fill in by hand, counting names one review at a time, is a filter and a download.

Tour operators: the brand page and every tour page

Tripadvisor splits a tour operator across more listings than anyone expects.

You have one brand page, the Attraction listing with your company name on it. Then every tour you sell gets its own page, an AttractionProduct listing with its own reviews. Sell twelve tours and your reviews are spread across thirteen pages.

Both shapes work in Reviewflowz. Bring in the brand page and the tour pages together and you can read one tour on its own or the whole operation at once.

The brand page aggregates the reviews from every tour underneath it, so we scope each profile to its own reviews. You see each review once, in the right place, and your counts stay right.

A Tripadvisor brand page with its tour product pages underneath

This is where attribution earns its place too. Connect Bókun and each tour's reviews find the guide who ran that departure, which is not something you can reconstruct from a listing page afterwards.

Why not just use a scraper

Almost every result you found for this is a scraper, so it's worth saying why they don't do this job.

They're browser based, usually a Chrome extension. They read what's rendered on the page in front of you, which is unstructured and messy, and it isn't the real data. Tripadvisor serves reviews machine translated by default, so what the scraper captures is the translation and not what your guest actually wrote. The original text is not on the page, so it can't get it.

Then there's the free tier. Every one of these advertises one, and it gets you a handful of reviews before it stops. To get your listing you pay.

So the question was never whether you pay for this. It's whether you'd rather spend two hours, or twenty dollars.

Reviewflowz reads Tripadvisor's review data directly, not the rendered page. When a review comes back machine translated, we flag it and fetch the original, so the text in your export is what your guest wrote. The Language column tells you which language that was.

What it costs

Any paid subscription includes the export, from $45 per location. The current rates are on our pricing page.

Free trials don't have it. You can import a listing, search it and filter it on a trial, but the download needs a subscription.

For a tour operator the important part is what counts as a location. One Tripadvisor listing plus all of its tour pages is one location. So a brand Attraction page and twelve product pages is one, not thirteen.

What to do next

Search for your business, let the history import, filter it to what you need and download it.

If you run tours, add the brand page and you'll see the shape of the whole catalogue.

Add a Tripadvisor listing and the import runs on your whole review history, not a recent window. Filter it by rating, date, language or team member, then download that exact set. Every filter in the filter list works on the export.

Did this answer your question?