Just like reviews, you can import questions and answers from another platform in four easy steps:

  1. Export - your question and answer data from your existing platform
  2. Download - the HelpfulCrowd template
  3. Format - using a spreadsheet application, such as Google Sheets (recommended) or Microsoft Excel to edit and format your question and answer data from your existing platform into the HelpfulCrowd .csv file format in UTF-8 encoding
  4. Import - In the HelpfulCrowd App Go to Tools > Data import. Navigate to the section titled Import Q&A Reviews and upload the .csv file into HelpfulCrowd

HelpfulCrowd Q&A Import Template Fields

A few things to keep in mind:

  • Status field values are case sensitive. They need to be entered in lowercase
  • Make sure your file is in valid CSV format with UTF-8 encoding - ¬†we strongly recommend using Google Sheets for editing
  • Use product codes with same #IDs as you see in the Product Catalog under Product column. Q&A for unrecognised products or incorrect codes will be ignored in the upload process
  • The HelpfulCrowd Agent name will be automatically assigned as the author to each imported answer
  • Q&A status 'published' and 'archived' will be recognised. Any other value will be ignored and Q&A status will be set to 'pending'. All status can be changed after import

Dates MUST be in the format one of following formats:

  • 2011/05/19
  • 2011-05-19
  • 2011-05-19 10:30:14 EST

Here is a short video showing how to correctly format the dates using Google Sheets and the yy-mm-dd format:

NB: Incorrect date formats or a blank date filed will result in the line item being rejected and requiring re-processing.

Screenshot: Import Q&A

We also recommend reading:

Did this answer your question?