How to create a CSV file for product catalog

Want to add your products to your product catalog? Follow this guide to create a customer data file in the right format.

What is a product catalog?

A product catalog is a list of all your business’s products that collect reviews. It includes details like product name, photo, and Global Trade Item Number (GTIN).

To set it up, you'll need to create a spreadsheet that contains your products’ details, using a program like Google Sheets or Microsoft Excel.

Prepare your spreadsheet using Google Sheets

To prepare your file, follow these steps:

  1. Open a new, blank worksheet in Google Sheets.
  2. Create columns with the following titles (all lowercase), and the corresponding data for each product:
    • sku (required)
    • title
    • link
    • image_link
    • gtin
    • mpn
    • brand
    • price
  3. Save the file in CSV format. From the File menu, navigate to Download, and select Comma-separated values (.csv, current sheet).

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.

Submit your catalog

The next step is to send your completed product catalog file to our Support team via this form. They will then upload the file to your Trustpilot Business account. To read more about managing your product catalog, check out this article.