---
title: "Import Q&A from CSV file"
description: "If you have a larger number of questions, you can import them as a CSV file."
url: https://docs.ryviu.com/en/articles/25-import-qanda-from-csv-file
collection: "Premium Features"
updated: 2026-11-03
language: en
---

# Import Q&A from CSV file

If you have a larger number of questions, you can import them as a CSV file.

This new feature provides additional ways to engage with customers, increase conversion rates, and boost store sales.

> **Info:** This feature only works in Paid Ryviu memberships.

Importing questions is a straightforward process. Just follow these steps:

👉 **Step 1:** Prepare your CSV file

To make sure the CSV file is correct, you should copy [**Ryviu questions CSV file template**](https://docs.google.com/spreadsheets/d/13zML3ZAzQa06jjbDhJXJ158bQFAnqn4umVQVQGKtxAI/copy)**.**

For the CSV file, please ensure the presence of the required fields:

-   **product\_handle:** The product handle (Shopify) or slug (WooCommerce) of the products you want to import should be used. Q&A for these products should be included.
    
-   **author:** The name of your customers.
    
-   **email:** The email of your customers.
    
-   **question:** The text of questions.
    
-   **status**: **"enable**" or "**disable**"
    
-   **create\_at:** The format should be **Year-Month-Date Hour:Minute**, such as 2023-06-15 09:12.
    
-   **answer\_created\_at:** The format should be **Year-Month-Date Hour:Minute**, such as 2023-06-15 09:12.
    
-   **answer:** The text of the answer.
    
-   **author\_answer:** The name of the store owner.
    
-   **email\_answer:** The email address of the store owner.
    

> **Warning:** We recommend using [Google Sheets](https://docs.google.com/spreadsheets/u/0/) **over** Excel to edit **CSV files for better handling of formatting and delimiters, avoiding** import errors.

-   You can leave the fields answer, author\_answer, email\_answer, and answer\_created\_at blank, but please include the field names.
    
-   If you provide an answer, you must also include the corresponding author\_answer, email\_answer, and answer\_created\_at for that particular answer.
    
-   If the date format in your CSV file is incorrect, questions and answers will be added to your Ryviu dashboard in real time when you import the CSV.
    

👉 **Step 2: Import Q&A from CSV to Ryviu**

-   Log in to your Ryviu account
    
-   Navigate **Reviews** > open the **Q&A** tab.
    
-   Click on the **Import Questions** button.
    
    ![Ryv​​iu Product Reviews Questions screen shows the Q&A tab selected, with a red arrow pointing from Reviews in the sidebar to Q&A. Visible: Ryviu Product Reviews, Products, Reviews, Store & Social, Q&A, Emails.](https://staticfiles.gleap.io/ghelparticle/RWftaxF1VjcnZJUuwDkkcFk3cD2HlHChVEachreyJAreYYrYR82WwNqjgL67qyQyTxe77nT3PXu.png)
    
-   Click **Add file**, choose your Q&A CSV file.
    
    ![Import Questions screen shows an uploaded CSV file, a confirmation message, import type options with Merge selected, and an Import Questions button. Visible: Import Questions, Upload CSV File, Copy of Ryviu-question-csv - waterproof-index-15000mm-warm-coat-ski-suit-windproof-baby-girls-jackets-kids-](https://staticfiles.gleap.io/ghelparticle/sFd748q1KiwnzBEMl5mkQvYn19Wn1UP3b5nyKklcYrQ1EvyM0JjFp30NXQXsEMVN6wFzGM62ai0.png)
    
-   Select Import type:
    
    -   **Replace:** Replace all existing Q&As for the product with the ones in the CSV file.
        
    -   **Merge:** Combine the product's existing Q&As with the new ones in the CSV file.
        

-   Click on the "Import Questions**"** button.
    

You can also visit the live site to see how it appears in your store.

* * *

**Need help?**

Get in touch with our support team through [live chat](https://docs.ryviu.com/en/articles/101-support.md) or email at [info@ryviu.com](mailto:info@ryviu.com)**.** We're here to help!