Trustpilot is the reputation platform brands love when the score is good and quietly fight with when it isn't. The page shows the headline TrustScore and a paginated stream of reviews. What it does not show — at least not in any way you can pivot — is the gap between verified and unverified review averages, the owner-reply rate on 1-star reviews, or how a single PR event in March moved the curve. For that you need the data offline. This guide walks you through using ExportComments' Trustpilot Reviews exporter to pull every public review for any company page into Excel, CSV, or JSON in a single pass.

Why export Trustpilot reviews

Trustpilot is unusual on a few fronts. First, it weighs negative reviews more heavily than the raw average suggests, which is why brands with a 4.0 mean often look like they're sitting at a 2.8 TrustScore. Second, the "verified review" badge — the program that controversy followed in 2023 when the platform changed its invitation rules — runs in parallel to ordinary user-submitted reviews. The two pools behave very differently. Third, Trustpilot is the rare review platform where the language column carries real signal: international brands routinely have a stable English-speaking review pool and a wildly volatile German or French one. Once the data is in a spreadsheet:

  • Company-page bulk pull — every public review for the page in one file, no pagination, no scroll-to-load.
  • Owner-reply rate audit — measure what percentage of 1- and 2-star reviews your team actually responded to, and how fast.
  • 1-star slice for support triage — sort by rating, filter to 1, hand the file to support. Half the reviews are about a single recurring issue you can ship a fix for.
  • Language column for international brands — pivot rating by language and find the markets where the pool is rotting before the headline TrustScore notices.
  • Verified-vs-unverified split — recalculate the average separately for invited (verified) and organic reviews. The two numbers often disagree by a full star.
  • Time-bucket trend overlay — chart weekly average rating against your own PR calendar. The XYZ travel-agency negative-press spike of 2024 is a textbook example: the weekly mean cratered the moment the story broke and didn't recover until the company started replying systematically.

How to export — step by step

Step 1: Grab the Trustpilot company URL

Open the company page on Trustpilot — for example https://www.trustpilot.com/review/example.com. Any canonical company URL works. The exporter doesn't need you to navigate into a specific filter; it'll handle pagination from the company page itself. If you want a specific slice — only English reviews, only 1-star — you can pre-filter in the spreadsheet after export, which is usually faster than fighting the URL parameters.

Step 2: Paste the URL into the exporter

Head to the Trustpilot Reviews exporter and paste the URL. If you're auditing a competitive set — your brand plus three competitors — switch to bulk mode and paste one company URL per line. Bulk runs return one Excel file per URL bundled together in a single ZIP at the end of the job, so each company stays in its own file. You'd be surprised how often the only useful insight from a competitive scan is "the competitor everyone fears is actually rated worse than us, but they reply to every single 1-star review within an hour."

Step 3: Pick a format

Excel (.xlsx) is the right pick for support triage and weekly review meetings — pivot, filter, conditional-format, done. CSV is the safest pick for BI imports. JSON if you're feeding the file into a sentiment model or piping it through a notebook for a longer time-series study.

Step 4: Start the export

Click Export. The job runs server-side and paginates through the company's full Trustpilot review feed, including the verified flag, the language code, the country code, and the owner reply text where one exists. Larger pages with tens of thousands of reviews take a few minutes; close the tab and the file lands in your dashboard plus your inbox when it's ready.

Step 5: Open the file

Open the .xlsx in Excel, Numbers, or Google Sheets. Each row is one review; each column is one field. You're ready to pivot, filter, and chart immediately.

Inside the export — what fields you get

Each row is a single Trustpilot review. You'll find columns for:

  • Reviewer name — display name shown on the review.
  • Reviewer country — the two-letter country code Trustpilot attaches to the profile.
  • Rating — the 1–5 star score.
  • Title — the headline the reviewer wrote.
  • Body — the full review text.
  • Language — language code of the review (en, de, fr, es, etc.).
  • Verified — true if Trustpilot flagged the review as verified.
  • Owner reply — the company's response text, when present.
  • Owner reply timestamp — when the reply was posted.
  • Created at and Updated at — original timestamp and last-edit timestamp in UTC.

Common workflows

  • Owner-reply rate audit — filter to ratings 1 and 2, count rows with non-empty owner reply, divide. Below 80% on negatives is a leak. Pair the count with time-to-reply (owner reply timestamp minus created_at) and you'll see whether the team replies fast or whether replies are mostly weeks-late damage control.
  • 1-star slice for support triage — sort rating ascending, take the top 200, hand the file to support. Cluster the bodies by recurring keyword and the top three clusters are almost always your real product issues.
  • Verified-vs-unverified split — recalculate the average separately for verified = true and verified = false. If the verified pool is a full star higher, the headline TrustScore is being held up by invited reviews — fragile if Trustpilot tightens invitation rules again.
  • Language-pivot for international brands — pivot average rating by language. The market with the worst average isn't always the one your local team worries about; sometimes it's a small market silently rotting.
  • PR-event trend overlay — bucket the timestamp column by week, chart the weekly mean, overlay your PR calendar. The XYZ travel-agency 2024 negative-press episode left a textbook V-shaped scar on the weekly chart.
  • Verified-program impact study — if you have data spanning the 2023 invitation-program changes, split by date and re-run the verified-vs-unverified ratio. Brands that relied on invitations saw the ratio shift and the headline score with it.

Plan limits and API access

The Free tier returns up to 100 reviews per export — plenty to evaluate the format. Personal scales to 5,000 reviews per export, Premium to 50,000, and Business to 250,000, which is enough to capture every review for the largest Trustpilot company pages. If you'd rather refresh your competitive set on a schedule or trigger an export from your own pipeline, the same job is available through the REST API and via webhooks. See pricing for the full breakdown.

FAQ

  • Why is my Trustpilot TrustScore lower than the simple average of my reviews?
    Trustpilot weighs recent and negative reviews more heavily than the raw mean. Exporting and computing the unweighted average yourself is the fastest way to see the gap and understand which reviews the algorithm is leaning on.
  • Can I tell which reviews are verified versus organic?
    Yes. The verified flag is a separate column. Recalculating the average split by verified status is one of the most useful pivots on a Trustpilot export, especially after the 2023 invitation-program changes.
  • Does the export include the language of each review?
    Yes — the language column carries the ISO code (en, de, fr, es, and so on). For multi-market brands this is the most useful pivot in the file.
  • Can I export reviews for several competitors at once?
    Yes. Use bulk mode and paste one Trustpilot company URL per line. The run returns one file per URL bundled into a ZIP, so each company's reviews stay in their own sheet for direct comparison.
  • Are owner replies included in the export?
    Yes — both the reply text and the reply timestamp are included on each row that has one. That's what lets you audit your support team's reply rate and time-to-reply on negative reviews.
  • Can I run this on a schedule for ongoing reputation monitoring?
    Yes. The same export is available through the REST API and webhooks, so you can refresh your company page (and your competitive set) every Monday morning without anyone clicking a button.