Articles on: Setting up HelpfulCrowd

Import Questions & Answers

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

Export - your question and answer data from your existing platform
Download - the HelpfulCrowd template
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
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:

Import Reviews
Setup Guide

Updated on: 08/03/2021

Was this article helpful?

Share your feedback

Cancel

Thank you!