Trustpilot Reviews

Export Trustpilot Reviews to CSV/Excel (Free Guide + Template)

Step-by-step instructions to export Trustpilot reviews to CSV or Excel, including ratings, dates, reviewer profiles, and full text. Ideal for analysis and reporting.

December 19, 2024
6 min read
Step-by-Step Guide

Trustpilot reviews are gold for reputation monitoring and voice-of-customer analysis. Here's how to export them quickly, accurately, and in a format ready for Excel, Google Sheets, or BI tools.

Fastest path: use the Trustpilot Review Extractor Chrome extensionto grab ratings, dates, reviewer names, and full text in seconds.

What We Export from Trustpilot

  • Rating (1–5) - Star ratings from each review
  • Review date - When the review was posted
  • Reviewer name (or alias) - Who wrote the review
  • Full review text (and title where available) - Complete review content
  • Business name & URL - Which business was reviewed
  • (Optional) Location, Verified status, Categories — when present

Method 1: Manual Copy (Not recommended at scale)

  1. 1Open a Trustpilot business page.
  2. 2Expand each review to show full text.
  3. 3Copy into Excel/Sheets.
  4. 4Repeat across pages/filters.

Downsides: Slow, error-prone, and misses hidden fields.

Method 2: One-Click Export (Recommended)

1. Install the Trustpilot Review Extractor (Chrome Web Store).

Get the extension from the Chrome Web Store.

Chrome Web Store page for Trustpilot Review Extractor

2. Open any Trustpilot business page

Apply filters (e.g., country, rating, date) before exporting if needed.

3. Click the extension → choose CSV or Excel → Start

The extension will paginate and gather all fields available on the page.

4. Download your file

You'll get trustpilot_reviews_<brand>_<date>.xlsx/csv.

Sample CSV Header

rating,date,reviewer,review_title,review_text,business,business_url,verified,location

Clean & Analyze the Data

  • • Create sentiment buckets from star ratings (1–2 negative, 3 neutral, 4–5 positive).
  • • Build a complaint heatmap: keywords like "shipping", "support", "refund", "billing".
  • • Track change over time: month-over-month share of negative vs positive reviews.
  • • Benchmark competitors: export several brands and compare.

Excel/Sheets Quick Wins

  • Pivot by verified to see differences in tone.
  • Use LEN(review_text) to flag short vs long reviews.
  • Use conditional formatting to highlight 1-star reasons (top keywords).

Compliance & Best Practices

  • • Respect Trustpilot's Terms and privacy policies.
  • • Use the data for legitimate business analysis and reporting.
  • • Avoid publishing personal data without consent.

Need the data now?

Try the Trustpilot Review Extractor — $29.99, instant, no account required.

View All Extensions

FAQ

Can I filter which reviews get exported?

Yes—set filters on Trustpilot first (rating, time period, location), then export.

Does it handle pagination automatically?

Yes, the extension iterates through pages to collect reviews.

How many reviews can I export?

Thousands, depending on the page and filters.

CSV vs Excel?

Use CSV for data pipelines and Excel for analysis or presentations.

Related Guides

Export G2 Reviews to CSV/Excel

Complete step-by-step guide for extracting G2 reviews with ratings, dates, and reviewer information.

How to Analyze Exported Reviews in Excel

Free template and advanced analysis techniques for review data. Coming soon.