A new and improved acceptance test data importer is now available. The new version provides improved data handling, simplified format requirements, and additional new features:

• Standardized data format requirements that matches the RedJade Numeric Raw Data Download, making it easy to download and reimport existing RedJade data sets.
• Now supports open-ended Text Question data. You can import text data then summarize your open-ends with RedJade AI. 
• Supports No Samples data. You can then Create a Demographic from a No Samples Questionnaire to filter data. 
• Allows for multiple data sets within one file to be imported to a single project. Include multiple worksheets (tabs) in the Excel file and each worksheet will be treated as a separate questionnaire data set.
• Improved data validation and error handling.
• Language selection is supported and import test can be Archived.
• A template file is available for download from this article for ease of reference.

The old Acceptance Data (Legacy) import was officially retired on June 16, 2025.

An Acceptance test is performed to determine the degree of consumer acceptance for a product and is usually conducted using untrained consumer panels. To perform an analysis, you can use data you've generated within RedJade or you can import data generated externally. When you import a data workbook, RedJade identifies and makes default choices from the data, which you can then refine.

See the following:

• Spreadsheet Formatting and Requirements
• Import Acceptance Data
• Add Demographics or Edit Questionnaires

Spreadsheet Formatting and Requirements

Worksheets

The Excel workbook can contain multiple worksheets (tabs). Each worksheet will be treated as separate questionnaire data sets. The worksheet names are used as the questionnaire names that display in the Topline Analysis left sidebar.

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. Only numeric data is supported. 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
• Row 5 – Start of data.
  
  

    Columns:

• Participant Code – Required. 
• Participant Name – Optional. If not included the Participant Code will be considered the Participant's Reporting Name.
• Sample ID – Required for signal sample data. If not included, the data set is considered No Samples.
• Sample Name – Optional. If not included, the Sample ID will display automatically in the results.
• Data 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.

    Data Column 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 Acceptance Data

To import acceptance test data:

1. From the main menu, select ANALYSES.
   
   
   
   
2. Click on [IMPORT DATA].
   
   
   
   
3. Enter a Name and optional Description for the project, then click [CONTINUE].
   
   
   Alternatively, choose Select Existing Project to create a new test under an existing project.
   
   
   
4. The Import Type defaults to Descriptive Analysis. Select Acceptance Data from drop-down list. Click on [BROWSE FOR YOUR FILE] or drag the file to the window.
   
   Optionally, change the Language selected for the test.
   
   
   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 and question types 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.
   
   Optionally, enter a Sensory Test Name for the test.
   
   
   Click on [IMPORT].
   
   
   
6. Once the import and initial analysis completes, you can view and work with the data in the newly created Acceptance Data Analysis.
   
   

   SEE ALSO – Configure Reporting in Analyses, Live Results for details on editing reporting options and analysis settings.

   
   
   

Add Demographics or Edit Questionnaires

Demographics can either be imported or assigned from No Samples questionnaire data. These demographics can then be used to create filtered data within analyses allowing for deeper insights into your data.

To add demographics to your imported data:

1. Click the Project Name link from the top of left sidebar to open the Test Dashboard.
   
   
   
   
2. From the Test Dashboard, click the settings cog to the right of the Test Name and select Edit.
   
   
   
   
3. Click on [EDIT WITH WIZARD].
   
   
   
   
4. Go to the Participants step.
   
   

   To import demographics, select the PARTICIPANTS tab and follow the steps in Adding Demographics to a Completed Test. To assign demographics from a No Samples questionnaire, select the DEMOGRAPHICS tab and follow the steps in Create and Map Categories / Demographics

   
   
   

5. Optionally, go to the Questionnaires step and click [ADD QUESTIONS] to view/edit question text or response labels. You can also edit and rename the questionnaires.
   
   
   
6. When done, click [SAVE & EXIT] to return to the Test Dashboard, then click the View Analysis tile.