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:
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.
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.