Importing Product Properties from an Excel File in EyeQuestion

Importing Product Properties from an Excel File in EyeQuestion

In this article we will explain how to import products properties in an EyeQuestion project using an excel file.

Step 1: Prepare your Excel file:
In order to import product properties effectively, it is crucial to arrange your data in a structured format within an Excel file. Begin by adding the header of the property name to the first row. Subsequently, each row should contain the properties of each product in a chronological order. For instance, row 2 will represent the information for product 1, row 3 for product 2, and so forth. You can use the excel file in the attachment as a starting point. 



Step 2: Access EyeQuestion and navigate to the relevant questionnaire:
Click on Design>Product. 



Step 3: Import the file excel in EyeQuestion

Select Import>Import Excel




The information imported will be automatically added to the products. 

If you have further questions about this functionality after reading this article. Please do not hesitate to contact support@eyequestion.nl
    • Related Articles

    • Product Database (PDB)

      Different types of databases EyeQuestion offers three types of databases, namely the Attribute Database (ADB) for storing attributes and adding questions in bulk, the Product Database (PDB) for storing product-related information such as brand, EAN ...
    • How can I import a custom design?

      If your preferred design cannot be created using the design generator, a custom design can be created using excel and imported into an EQ project. To import a custom design, go to the design page of your project. Click on the "Import Design" option. ...
    • How can I import a panel in EyeQuestion project?

      You can add panelists in EyeQuestion by transferring them from the Panel Database to the panel access list or using excel import. Open a project and click the panel tab. Panelists can be added to the panel by adding them to the access list from the ...
    • How to I import or update panellists in bulk

      In EyeQuestion you have the possibility to import or update information about your panellists. The steps to be taken for this are described below: Step 1: Go to Panel Management and click on ''Import Panellists'' (The option can be used to create new ...
    • Importing Panelists into a Specific Panel Group

      Introduction In sensory science, a panel group refers to a specialized group of individuals who are trained to evaluate sensory attributes such as taste, smell, texture, appearance, and overall sensory experience of products or stimuli. You can learn ...