How to import reviews manually (Excel, csv, etc.)
Quick steps
- Go to Review Connections in Trustmary and click Import manually.
- Paste the rows from a spreadsheet, or upload an Excel or CSV file.
- Pick a data field for every column, check the preview and click Import x 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.

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:00The 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 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
Thank you!
