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

How to import reviews manually (Excel, csv, etc.)

Quick steps


  1. Go to Review Connections in Trustmary and click Import manually.
  2. Paste the rows from a spreadsheet, or upload an Excel or CSV file.
  3. Pick a data field for every column, check the preview and click Import x reviews.


Are the reviews on a platform Trustmary can connect to, such as Google or Facebook? See How to import reviews.


Open the file import


Open Review Connections in the navigation bar on the left. The last tile under Add new review connection is Import manually; clicking it opens the Review file import panel.



Choose the source


Under Source of import there are two ways to bring the reviews in.


Copy from Excel takes rows pasted straight from a spreadsheet. Copy the rows and paste them into the text box; the import recognises how the values are separated and splits them into columns. If the columns do not come out right, separate the values on each row with a comma.



Upload file (Excel/CSV) takes an .xlsx or .csv file: click Select file and pick it. Every piece of information has to be in a column of its own, so the review text and the reviewer's name, for example, are in separate columns.


An example of a spreadsheet where every piece of information has its own column.


Match the columns


Under Match file columns with Trustmary data fields, pick a data field for every column of the file: the review text, the reviewer's name, NPS or star rating, and so on. A column that should not be imported is set to (Do not import). Every field is described below.



Under Preview, check that the values landed in the right fields. Rows that cannot be imported are listed separately with the reason and are skipped; a header row ends up in that list, which is expected. Then click Import x reviews.



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


Dates


A review can carry a date and time. The format depends on the file type:


  • In an Excel file (.xlsx), format the column as Date in Excel.
  • In a CSV file, write the date in ISO format:


2023-03-02T15:17:00.000+02:00


The dates in the file can also be overridden: under Review date, tick Override all review dates with the date below and pick a date. Every imported review then gets that same date.


Data fields explained


Data field

Description

Review text

The review itself, as the reviewer wrote it.

Reviewer name

The name shown on the review.

Reviewer job title

The reviewer's job title, if known.

Review profile image URL

A URL to the reviewer's profile image.

Review location

A location attached to the review, if known.

Reviewer organization

The company or organization the reviewer works for.

NPS

Net Promoter Score, how likely the customer is to recommend the company to others. Scale 0–10.

Star rating

A star rating on a scale of 1–5.

Review date

The review's date and time. The format requirements are under Dates.

External ID

An id from another system, such as a CRM.

Tag

A keyword imported as a tag on the review.

(Do not import)

The column is left out of the import.


Wrapping up


Reviews imported from a file do not refresh on their own. That is the difference from a connected review source, which fetches new reviews once a day; a file import fetches once, when it is run. Later reviews are brought in with a new import.


The same file imported twice creates the reviews twice. The import does not recognise reviews it has already brought in, so a new import should contain only the rows that have not been imported yet.


The imported reviews are listed under Responses, in the Reviews list, where they can be edited and picked for widgets.


Importing a tag column is worth it when the reviews are going to be filtered into widgets by source, product or location: see Adding tags to your reviews.

Updated on: 20/11/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!