Articles on: Getting started with Trustmary
This article is also available in:

How to import reviews

Quick steps


  1. Open Review Connections from the navigation bar on the left.
  2. Under Add new review connection, click the review platform.
  3. Search for the business, sign in, or paste the review page URL, and click Connect.
  4. For a spreadsheet, click Import manually, upload the file and match its columns.


Importing starts on the Review Connections page, in the navigation bar on the left.



Every platform Trustmary can import from is listed under Add new review connection. Sources that are already connected appear further down the page, under Review connections.


Google reviews


Click Google. Type the business name into the search field, or paste its Google Maps URL, pick the business from the suggestions and click Connect. The import starts right away.



If the business is not among the suggestions, open Not found? and click Connect with OAuth to sign in to the Google Business Profile that owns the reviews. This is the route for a business without a physical address in Google Maps.


Importing from a single Google Maps location by its address is covered in Importing reviews from Google Maps.



On the free plan the reviews are imported once, when the source is connected. On the paid plans Trustmary fetches new Google reviews once a day, and at any time from Import reviews now on the connection's card.



Facebook reviews


Click Facebook, then Connect to Facebook. Facebook asks for a sign-in and for permission to give Trustmary access to the page; the import starts once access is granted.



Other review platforms


G2, Capterra, Tripadvisor, Yelp, Google Play, Booking.com, Airbnb, Trusted Shops and TrustRadius all connect the same way: click the platform, paste the URL of its review page into Address (URL) and click Connect. The panel shows what the URL should look like for that platform.



The first import can take a few minutes, depending on how many reviews there are.


Importing from a spreadsheet


Reviews that exist only in an Excel (.xlsx) or CSV file are imported through Import manually, the last tile in the list. It opens the Review file import panel.


  1. Under Source of import, choose Upload file (Excel/CSV), or Copy from Excel to paste the rows in instead.
  2. Click Select file and pick the file.
  3. Under Match file columns with Trustmary data fields, pick a data field for every column: review text, reviewer name, NPS or star rating, review date. A column can also be left out of the import. Tick Override all review dates with the date below to give every review the same date instead of the one in the file.



  1. Check the rows under Preview. Rows that can't be imported are listed separately with the reason and are skipped; a header row ends up in that list. Click Import x reviews.



Import ready shows how many reviews were created, and Show reviews opens them in the Reviews list.



The data fields, and what each one accepts, are described in Importing reviews manually (Excel, CSV etc.).


Wrapping up


Imported reviews are listed under Responses, in the Reviews list. On the paid plans a connected source keeps importing new reviews daily while Auto-import new reviews daily is on; a file import is a one-off. The import brings in the reviews themselves, not the replies written to them.

Updated on: 20/11/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!