Articles on: Setting up HelpfulCrowd

Importing Questions & Answers

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


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
  • 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:


Updated on: 24/07/2025

Was this article helpful?

Share your feedback

Cancel

Thank you!