Hello! How can we help?

Browse the Trustpilot Support Center to find info on Google Seller Ratings, Rich Snippets, TrustBoxes, Product reviews, plus how-to guides for editing your reviews and account settings

Creating a File Of Your Customers for Uploading

Which files can I use?

You can either use a TXT or CSV file. They can be created in most versions of Excel. Another good option is Notepad, or you can also use a simple text editor.

To ensure that special characters (or non Western European characters) are shown correctly in your invitations, please save your file using UTF-8 encoding.

Using Google Sheets

Google Sheets is a free application from Google that can help you convert files to a format that works well for ensuring your invitation files are correctly formatted.

Start by uploading your sheet to Google Sheets, or open a sheet and paste in the values. Look through the document and ensure everything looks correct. Then use the Download as option from the Files menu and select Comma Separated Values:

Using Microsoft Excel

Some versions of Microsoft Excel support saving CSV in UTF-8 format (the format you need for Trustpilot). However, since not all vernsions of Excel have this feature we highly recommend using Google Sheets as described above.

To create a file in Microsoft Excel, start by creating a spreadsheet containing the email, name and reference number of your customers.

Note: email, name and reference number are mandatory inputs and columns must be in a specific order: (1) email, (2) name, (3) reference number.

Your spreadsheet should look like the example below

Once the spreadsheet is ready, it must be saved as a Comma Separated File. Go to the Save as... menu and select CSV in the Save as type drop-down options:

In order to ensure that any international characters are correct in your invitations, find the small Tools button and select Web Options. In this dialogue you should find the tab called Encoding and select Unicode (UTF -8).

Click OK and then Save. Now you should have a perfectly formatted file for uploading into the Invite Customers module.

Comments

0 comments

Please sign in to leave a comment.