Transferring files for Excel and SPSS

During or after the examination, it is possible to have the obtain complete results of the study.

The following types of result files can be requested:

• CSV / TXT
• SPSS
• PDF

The files are live, which means that all results can be seen directly in the file.

Excel File (CSV-TXT) 

This file is named "RES_XXXXXX.TXT". Below you can you can read how this file can be read into Microsoft Excel. This description assumes an English language version of Excel. The Dutch version works the same.

• Go to Excel and go to "Open" in the "File" menu.
• At "Files by type", select the type "Text files"
• Go to the location on your own computer where you want the "RES_XXXXX.TXT" file.
• Select this file and click "Open".
• You will then see the import wizard (see below) picture comes. The values ​​must be entered as in the image below.
• Click on "Next" and you will be taken to the next screen. Here select "Semicolon" as the delimiter and the single quote (") as a text qualifier.
• If you click on "Next" in the previous screen the next step in the picture. This allows you to specify per column what kind of values ​​this column contains.
• Are you using decimal columns? To make sure to be that these are loaded they must, at step 3, loaded as string data format.
• Press "Finish" and your results file has been imported.
• Save the file as Excel or CSV

SPSS files

The following types of files are available for importing into SPSS available: a data file, a label file and a .sav file. The names are: "DAT_XXXXXX.TXT", "LAB_XXXXXX.SPS", "SAV_XXXXXX.SAV" respectively. The .sav file has already been imported into SPSS with the correct question and answer labels. This instruction concerns the manual import the .txt data file into SPSS and append it of labels through the label file:

• Save both files.
• Start SPSS and choose Open in the File menu and then for Data (see image).
• Then go to the correct location on your computer and select "Text (* .txt)" under "Files of Type" (see the following image). Select the correct "DAT _ ????. TXT" file and click "Open".
• You will now enter the SPSS Text Import Wizard. Make sure that "No" is selected and click "Next"
• In the next screen, "Delimited" should be selected and "Yes" to "Are variable names included at the top of your file? "
• If you pressed "Next" in the previous screen then the following screen follows. This must be done below way. Then click on "Next"
• Then you will see the following screen. Select here as delimiter Semicolon "and as text qualifier" ~ ". This character is on most keyboards to the left of the 1.
• From the screen on the previous page, press "Next". In the next screen you can also directly click "Next" and then in the last screen you can press Click "Finish". Now the data is imported into SPSS.
• Do you have SPSS 24 or higher? Then there must be 1 more setting are being changed. In the penultimate screen (step 5) the percentage must be set from 95 to 100.
• Are you using decimal columns? To make sure to be that these are loaded they must, at step 5, loaded as string data format.