--- title: "Importing Q&A into Yotpo" slug: "importing-qa-into-yotpo" tags: ["Reviews ", "Shopify Plus", "Shopify", "Adobe Commerce (Magento)", "WooCommerce", "BigCommerce", "Volusion", "Custom", "Salesforce Commerce Cloud"] updated: 2026-07-21T13:35:05Z published: 2026-07-21T13:35:05Z canonical: "support.yotpo.com/importing-qa-into-yotpo" stale: true --- > ## Documentation Index > Fetch the complete documentation index at: https://support.yotpo.com/llms.txt > Use this file to discover all available pages before exploring further. # Importing Q&A into Yotpo Products Reviews ###### Supported plans Pro, Premium, Enterprise ###### eCommerce Platform Shopify, Shopify Plus, Adobe Commerce (Magento), BigCommerce, WooCommerce, Volusion, Salesforce Commerce Cloud, Custom ## Overview This article describes how to prepare questions and answers for importing by Yotpo.If you want to re-use existing Q&A when migrating to Yotpo, you can provide information from any platform. > [!CAUTION] > Important > > - If you have more than one account, you need to create an import file for each account > - You cannot import questions that do not have answers ## How it Works You can import questions and answers (Q&A) into Yotpo to preserve customer content when migrating from another platform. Imports are handled by Yotpo Support and must be submitted in the correct file format. ### Download the import template
Yotpo Q&A import template .xlsx
 1. Open the file using a spreadsheet tool such as [LibreOffice](https://www.libreoffice.org/) or [Google Sheets](https://www.google.com/sheets/about/). 2. When you finish editing, export or save it as either **CSV (UTF-8)** or **Excel (.xlsx)** format. > [!CAUTION] > Important > > **If you’re using Excel, d**on’t open a UTF-8 CSV file **directly**. Instead, **import** it to preserve special characters. > > [View Excel import instructions](/docs/importing-qa-into-yotpo#) 3. Complete the template with the appropriate information filled in according to the following guidelines: - All fields are mandatory. - Ensure that the product-id in your file matches the product-id on your website for every product. - Make sure the date format is consistent across the entire date column. The recommended format is YYYY-MM-DD, for example, 2016-03-21. - When you import Q&A to Yotpo, they are automatically published to your website. Edit the files before you send them to Yotpo to remove any Q&A you do not want to be published. - If a question has multiple answers, create a row for each answer with the same question_id, question poser and product data (see rows 1 and 2 of the template for an example). - You cannot have multiple answers for the same question from the same user email. 4. Save the file either as Excel (.xlsx) or a .csv file in UTF-8 encoding. Other formats, such as Apple Numbers, are not supported, **To save an Excel file in UTF-8 format:** 1. Select **Save As** in the File menu. 2. Select Web Options in the Tools menu near the Save button. 3. Select **Encoding**. 4. Select **Unicode (UTF-8)** in the Save this document as: drop-down list. 5. Click **OK.** 6. Click **Save.** Please note that these instructions depend on the version of Excel you're using. **To ensure the CSV File is in UTF-8 encoding:** 1. Open the file in Windows Notepad. 2. Select **Save As** in the file menu. 3. Select **UTF-8 encoding** in the Encoding dropdown menu next to the Save button in the Save As dialog box. Make sure to only select the Tab and Comma Separator Options. 4. Save the file using a new name. 5. Go through the checklist below before you submit your files to Yotpo Support. #### Selecting the Tab and Comma Separator Options: ![](https://cdn.document360.io/f3c2ab59-fe4c-4f93-9614-2872f40e8aa7/Images/Documentation/c2083b70-5caf-4205-a8ec-cc7370e01d72.png?sv=2026-02-06&spr=https&st=2026-11-03T15%3A48%3A34Z&se=2026-11-03T16%3A48%3A34Z&sr=c&sp=r&sig=CNxq6z88vCFOjTu%2BWY1FYqQ3L%2BfpekzC43sE4Q7jbSA%3D) #### Checklist: - Target account ID for the Q&A import: To find your account ID, click [here](/v1/docs/importing-qa-into-yotpo#finding-your-account-id) - Verify [product IDs](/v1/docs/finding-product-ids-in-your-ecommerce-platform) - Remove any questions you do not want to be published - Verify that all the mandatory fields are filled - Remove invalid strings of characters that were converted from emoji into UTF-8 - Verify the product URLs and product image URLs are valid - The URLs should open the product page. - Verify that the character encoding is UTF-8 - Verify that the file format is Excel (.xlsx) or CSV (comma separated values) - commas between the data, and inverted commas as the text delimiters, for example: `question_id,question_content,question_user_email,question_user_name,question_created_at,product_sku,product_title,product_description6. Use the online support form to send the files and Yotpo will import the Q&A for you. Specify the Yotpo account ID for which to import the Q&A.` > [!CAUTION] > Note > > Yotpo Support will contact you when the questions and answers have been imported. ### Finding your account ID To find your account ID, do the following: 1. Log into Yotpo Reviews. 2. From the account menu in the bottom-left corner of your screen, select **Account Settings**. 3. In Store Settings, go to **General Settings**. 4. Locate your Yotpo Account ID. ### Finding product IDs To find your product IDs, please [click here](/v1/docs/finding-product-ids-in-your-ecommerce-platform). ### Import Q&A template | Field | Mandatory | Description | Example | | --- | --- | --- | --- | | question_id | X | The unique id of the question. | 1 | | question_content | X | The content of the question | What colors does the T-shirt come in? | | question_user_email | X | The email of the user who asked the question | johndoe@email.com | | question_user_name | X | The name of the user who asked the question | John Doe | | question_created_at | X | The date the question was asked in YYYY-MM-DD format | 2016-03-21 | | product_sku | X | The sku (product ID) | 1 | | product_title | X | The name of the product | Yotpo T-shirt | | product_description | X | The description of the product on the store | Yotpo-branded T-shirt | | product_url | X | The url of the product on your store | http://magento.yotpo.com/index.php/yotpo-products/yotpo-t-shirt.html | | product_image_url | X | The url of the product image | http://magento.yotpo.com/media/catalog/product/cache/1/image/9df78eab33525d08d6e5fb8d27136e95/2/0/2011-12-19_15.13.05_large.jpeg | | answer_content | X | The answer added by a customer or the store owner | Only in a stylish blue at the moment | | answer_user_email | X | The email of the person who answered | jane_smith@domain.com | | answer_user_name | X | The name of the person who answered | Jane Smith | | answer_created_at | X | The date the answer was created | 2016-03-23 | > [!CAUTION] > Note > > - All fields are mandatory > - One product may have multiple questions > - One question may have multiple answers > - If a question has multiple answers, create a row for each answer with the same question_id, question poser and product data (see rows 1 and 2 of the template for an example) > - You cannot have multiple answers for the same question from the same user email > - product_sku is the product_id