Creating a QES file from an Excel file (AskiaTools)

Use this AskiaTools feature to convert an Excel (XLS or XLSX) file into a new QES file.

This import method scans all the rows in the Excel file to determine the question types that will be created. It reads unicode data, and there is no limitation of 255 columns.

To access this feature, from the file menu, select import, then Excel file.... The Excel import dialog appears.

View image

 

To import the file:

  1. Next to Excel file, click ... and specify the path to your Excel source file. You can select an XLS or XLSX file.
  2. In sheet, select the worksheet in the Excel source file that you want to import.
  3. Next to Askia file, click  ...  and specify a name and location for the new *.QES file.
  4. Set the options, as described below.
  5. Finally, click OK.

Options

The available options are:

Option Description

Excel file

Type the path and filename of the source (.XLS or XLSX) file or click ... and select the file.

Askia file

Type the path and filename of the output file (where the data will be stored), or click ... and specify the path and filename in the file dialog.
Into inverted data format

If you select this, the target file will be created with an inverted data format.
Max number of responses Determines how AskiaTools will identify questions as closed or open text in the source file. If a variable has the stated number of unique responses or fewer, it will be considered a closed question; if it has more responses than this, it will be considered an open text question. For example, if you enter 20 here, then any question with more than 20 different responses will be treated as an open text question.
Max number of discrete values Determines how AskiaTools will identify questions as closed or open numeric in the source file. If a variable has the stated number of unique numeric responses or fewer, it will be considered a closed question; if it has more responses than this, it will be considered an open numeric question. For example, if you enter 10 here, then any question with more than 10 different responses will be treated as an open numeric question.

Question separator

Specify the character used to separate questions in the source file ("TAB", ";", ":" or ",").
Create your own Knowledge Base