> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://www.guides.helpfulcrowd.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# 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](http://go.helpfulcrowd.com/guides-QnA-import-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](https://helpfulguides.crisp.help/en/article/encode-and-create-utf-8-import-files-as-and-save-them-as-csv-1p8cmww/)
4.  **Import** - In the HelpfulCrowd App Go to [Tools > Data import](http://go.helpfulcrowd.com/app-tools-data-import)

*HelpfulCrowd Q&A Import Template Fields*

![](https://storage.crisp.chat/users/helpdesk/website/66fbd5d04fe00400/image-5_1iamnhg.png)

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 ](https://helpfulguides.crisp.help/en/article/encode-and-create-utf-8-import-files-as-and-save-them-as-csv-1p8cmww/)format with [UTF-8 encoding](https://helpfulguides.crisp.help/en/article/encode-and-create-utf-8-import-files-as-and-save-them-as-csv-1p8cmww/) -  we strongly recommend using **Google Sheets** for editing
*   Use product codes with same #IDs as you see in the [Product Catalog](http://go.helpfulcrowd.com/app-product-catalogue)
*   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:

![](https://storage.crisp.chat/users/helpdesk/website/ad7bfd6a89825000/c4d061f2-e25a-42e3-a63a-60b97e_1b2yrry.gif)

**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_

![](https://storage.crisp.chat/users/helpdesk/website/69c19ebf897d2400/277d0018-99a0-4ca4-ab60-3441ef_gx5xa3.png)

**We also recommend reading:**

*   [Import Reviews](https://helpfulguides.crisp.help/en/article/import-product-reviews-wof0oy/)
*   [Setup Guide](https://helpfulguides.crisp.help/en/article/setup-guide-172vy4f/)