Rather than create a new questionnaire, you can save time and import questionnaire content from an Excel file. You can specify your question's text and responses that you commonly use and modify them after as needed. When you import a data workbook, RedJade identifies and makes default choices from the data, which you can then refine.


The questionnaire importer uses standardized data format requirements that match the RedJade Numeric Raw Data Download and Acceptance Data Importer, making it easy to download and reimport from existing RedJade data sets.


See the following:



Spreadsheet Formatting and Requirements


Worksheets

The Excel workbook can contain multiple worksheets (tabs). Each worksheet will be treated as a separate questionnaire. The worksheet names are used as the questionnaire names by default.


Data Layout Details

In the Excel file the data on each worksheet includes header rows that provide the data coding. Column and Question Type labels must match the label requirements listed below. A template file with example data is also available for reference at the end of this article.


    Rows:

  • Row 1 – The Question/Data Type, for example:  Single Selection or Single. 
  • Row 2 – The Question Text, for example:  What is your overall opinion of this product.
  • Row 3 – The answer coding, for example:  (a line breaks (Alt+Enter) is required for each answer)

1=Dislike Extremely

2=Dislike Very Much

3=Dislike Moderately
etc.

  • Row 4 – The question's Reporting Name, for example:  Overall Liking
    • Also included in Row 4 are the group labels for grid type questions which follows the : after the Reporting Name, for example:  Importance Grid: Brand A


    Columns:

  • Row 1 of each data column must include a valid Question Type from the list below. Otherwise, the column is ignored.
  • Any columns that do not meet the above requirements will be ignored.


    Question Types that are currently supported:

  • Single Selection or Single 
  • Dropdown or Dropdown Select
  • Multiple Selection or Multi
  • Numeric
  • Line Scale
  • Target (bullseye question)
  • Text
  • Single Select Grid
  • Multiple Selection Grid
  • Numeric Grid




Import a Questionnaire


To import a questionnaire: 

  1. From a project, select the test tab, then click on the Surveys tile.



  2. From the Questionnaires step, click on [CREATE QUESTIONNAIRE].

    NOTE – The questionnaire texts will import under the test's default language, see Work With Languages for a Questionnaire. Only one language can be imported at this time.




  3. Click on Import Questionnaires from File.


  4. Click on [BROWSE FOR YOUR FILE] or drag the file to the window.

    Locate the file on your computer, then click on [OPEN].


  5. The import function identifies all the questionnaires by worksheet name and displays the question number, question types, and responses found. If there are any exceptions, an error message will display. You will not be able to submit the import until all errors have been fixed.


    Click [NEXT] to continue.


  6. For each questionnaire in the list, specify the questionnaire details.

    Repeat the steps below for each questionnaire listed.

    • Optionally, rename the questionnaire's Title. The worksheet names are used as the questionnaire titles by default.
    • Select the Questionnaire Type drop-down menu.
    • Select the Sample Entry Mode and Sample Display type. See Sample Entry Mode and Sample Display: Name for further details.



  7. If importing a questionnaire that includes samples, select the samples to be evaluated using this questionnaire. As you add each sample, it moves to the Servings section on the right.


  8. Click on [SUBMIT] to complete the import.



  9. The questionnaires are added to the test. You can edit and modify it, as needed. See Edit Questionnaire Details and Servings.