A data file in Excel or CSV should have the questions in the columns, and the respondent results in the rows. Below and example of how the file could look like:

Mandatory variables

The first 3 columns in this example contain RespondentID, ResponseDate and Weight. As decsribed in the basics, these are mandatory variables. 

We have 3 options:

• If you have them in the file, Dapresy will recognize them

• If you them, but named differently, you can assign those variables to be the right ones during the data import (in the meta data transformation)

• If you don't have them, you can create those as new variables. RespondentID will be a random number, a date can be chosen and weight will be set as 1

Note: the order of the variables is not important

Variable codes and labels

As you can see in the example, the first row is the variable name/code. The names/codes are mandatory to be able to load the file. A code should always start with a letter. The variable name/code cannot exceed 50 characters. The second row in this example contains the variable labels or reporting text. This row is not mandatory, but without this, it will use the variable name/code as a label, which might be less useful.

Question types

Here you can find the question types that are supported by Dapresy.  Here you'll find some extra information regarding the question types specifically for Excel:

  • In the example file above you see in the 4rth column an example of a Single response question. Add the answer text to the question in your data file and Dapresy can categorize these automatically as codes 1 and 2. 
  • Multiple response: in this example the 3 variables with an underscore are the multiples. They can be merged into one multiple question in Dapresy with just 1 variable name and 3 answers. In this case the system will recognize it because of the underscore, but if you have another separator which is unique, we can set that as the separator during the import. Add the answer text to the question in your data file and Dapresy can categorize these automatically as codes 1, 2 and 3 (Fast food, Beverages and Ice Cream in the example above). 
  • The last column in this example is a string/open ended question. Note: those questions can be uploaded, but not reported, so there is no need to include this in your file.