Excel review importing
Learn how to import reviews to Trustmary from an Excel or .csv spreadsheet.
Santeri
Last Update vor 2 Monaten
Start by navigating to Platforms via the navigation bar.
Next, click the Import manually button.
This opens up a file import flow, in which you can either copy data from a spreadsheet or upload a file for automatic processing. Whichever you choose, in the next step you will need to specify the data types of the columns on your spreadsheet (e.g. reviewer's name, the review itself, NPS, etc.).
Once you've selected data types for all the columns, check that everything looks right in the Preview field, and click Import x reviews.
After the import is done, you'll see a page that tells you how many reviews were created, and a link to show these reviews.
Importing date & time
You can also add date and time to your review import, and use that in your public reviews. Note that in an Excel file (.xlsx) the column should be formatted as Date in Excel.
In a .csv-file the date should follow the ISO format, from which you can see an example below:
You can also override the date in the file import by checking the checkbox and selecting a date.