You can load the data in Excel or in CSV. First we will explain Excel, below you can review the options for CSV.


Excel

When importing an Excel file, you'll have some settings to define where your data exactly starts:


Sheet No: this defines the sheet, as you can have multiple sheets in Excel. 

Question code row No: this defines in which row of the Excel file Dapresy can read the variable or question codes

Question text row No: this defines in which row of the Excel file Dapresy can read the labels/question/reporting text

Data start row No: this defines in which row of the Excel file Dapresy can read the respondent data


Example:

In case your data looks like this:

The settings should be the following:

Note: in case you don't have the Question text in your file, you can read the question text from the Question code and have the same row number in here.


CSV

Once you load a csv file, you won't have the ability to define in which row and sheet the data is located, but you do have to define what the Decimal separator is and CSV delimiter:

Decimal separator: this is a symbol used to separate the integer part from the fractional part of a number written in decimal form. Different countries officially designate different symbols for the decimal separator. (The choice of symbol for the decimal separator also affects the choice of symbol for the thousands separator used in digit grouping)


CSV delimiter: this is a character used to separate the values. The most common delimiters are the commatab, and colon. You can see what the delimiter is by opening the file in text pad/notepad and check what is separating every data point.