With an Excel Question Template you can easily create an unlimited number of "Completed Questions" or "Questions with only one answer".


How to download the Excel Question Template?

How to fill in the Excel Question Template?

Tips for filling in the Excel Question Template

How to import the Excel Question Template?


How to download the Excel Question Template?

  1. Go to the "Questions" area in the left side menu

  2. Click on the "Question" section to access the list of questions

  3. From any list of questions you can download the excel question template, clicking on the "Upward arrow cloud" button at the top right

  4. In the pop-up window, click on the "Download" button 

  5. Find and open the folder on your PC where you want to download the template and click on "Save"







Back to the top of the article


How to fill in the Excel Question Template

  1. Open the Excel template "questions_sample_en" that you have previously downloaded

  2. In the first row you will find a brief explanation on how to fill in each column, read the instructions carefully, overwrite or delete that row and fill in the columns:

    1. Category: Add the category or category path (parent category > child category) to which the question belongs. If the question belongs to two separate categories, write the name of the categories separated by ; (Category 1; Category 2)

    2. Question: Write the statement of the question

    3. Answers (column C - G): you can include up to 5 answer alternatives. If it is a question for a training, write at least two different answers. If it is a question for Zap so that it can expand its knowledge, write only one answer

    4. Correct Answer 1-5: In this column, you must indicate which answer is the correct one. We recommend to put the correct answer in the first option (column C), this way, in this column you only have to add the number 1. Remember that the cell format must be "Number" otherwise it will give an error when importing.

    5. Shuffle Answers 1/0 (1 yes/0 no):  Type 1, if you want the answers to appear shuffled. Type 0 otherwise. Remember that the cell format must be "Number" otherwise it will give an error when importing.

    6. Hint and More Info: If you need to add Training Pills to the question in the excel template, include only the text







Back to the top of the article


Tips for filling in the Excel Question Template

  1. Do not remove any column even if you do not use it. When importing the excel, it will give an error

  2. Remember that each row in the excel template is a question

  3. Check spelling and grammar

  4. Try to avoid the following answers:

    1. True/False. If you use it, justify "true for X reason" and "false for X reason"

    2. Yes/No. If you use it, justify "Yes for X reason" and "No for X reason"

    3. "All the answers are correct." If a user asks Zap a question, Zap will display this answer, and the user will not understand it. Avoid this answer


Back to the top of the article


How to import the Excel Question Template?

  1. In the "Question" section click on the "Upward arrow cloud" button at the top right from any of the list of questions

  2. In the pop-up window, click on the "Import" button 

  3. Click on the "Select" button

  4. Find the Excel question template on your PC and click on the "Open" button. If you make a mistake when selecting the file, click on the "Change" or "Delete" button

  5. Click on the "Save" button

  6. Click on any section on the left side menu or via the Questions > Import Excel path in the upper left to exit the import process







Note: In the lists of questions "With only one answer" or "Completed" you can see the new questions created


Note: Remember that if you export a list of questions, edit the questions and import the list again, you will be duplicating the questions. The questions are not edited or updated with the Excel lists. To edit a question see the following article Edit, translate or delete a question


Note: Remember that the Excel of questions exported from the Administration Area is not used to import new questions. Check out our article Export questions 


Check out our articles What it is, create and translate a Training Pill, Types of questions and What Categories are and how to create them


Back to the top of the article