How to create a CSV file for Product Reviews

This feature is included in the Free plan

Get started now

In this article, we’ll show you step by step how to create a file with your customer data, so you can send invitations for product reviews.

First, you'll need to create a spreadsheet with your customer data in a program like Google Sheets or Microsoft Excel.

Prepare your spreadsheet using Google Sheets

To prepare your file to be imported, follow these steps:

  1. Open a new, blank worksheet in Google Sheets.
  2. Enter customer data in this order: 
    • Customer email
    • Customer name
    • Reference number (the customer’s internal reference number)
    • SKU
    • Product name
    • Product URL
    • Image URL (this one is optional)

Note: Your Product URL and Image URL must contain an http:// or https://

CSV_file_ex.png

  1. Save the file in CSV format. From the File menu, navigate to Download, and select Comma-separated values (.csv, current sheet).

Note: If the Reference number and the Customer email address match, all product reviews will be combined in one invitation email.

Prepare your spreadsheet using Microsoft Excel

If you’re using Excel, the steps for creating the spreadsheet are the same, but you’ll need to make sure that you’re saving your file using UTF-8 format.

Import your CSV file

Now you've prepared your CSV file and it’s ready to go. You can open it in a simple text editor like Notepad and it should look like this:

CSV_file_ex2.png

To import your prepared file, all you need to do is:

  1. Navigate to Trustpilot Business > Get reviews > Invite customers
  2. In the section Invite manually, select Upload a file - Service and product reviews.
  3. Click on Select file and upload your CSV file with relevant customer and product data.

That’s it! Your data is now imported and you can set up your sender information, customize your template, and start sending invitations.