You can download your data in multiple formats. As soon as any data has been collected, the following formats are available for download:
- XLS (formatted spreadsheet)
- CSV (comma separated values)
- ZIP (a zip folder of your photos, videos, or sound recordings - if applicable)
- KML (a file containing all the GPS points collected - if applicable)
XLS and CSV export types have additional, one-time options that can be reached by clicking the "Advanced Export" button on their respective pages. These options disabling of the automatic disaggregation of responses to select-many questions into a binary column for each possible response, and changing the group delimiter when naming sub-items of groups and select-many responses.
By default responses to select-many questions exported with one column showing the concatenation of all selected responses and additionally disaggregated into individual columns to show if a particular response was selected or not.
Each new export can take a few seconds to be created. Afterwards each export is retained as a unique snapshot in the system. For more details and alternatives on downloading media file attachments, please see this post as well.
Importing data to SPSS
SPSS is a statistical software package that allows much more advanced analysis than is available in Excel. KoBoToolbox includes the custom syntax file that allows viewing the labeled version of questions and multiple response questions during data analysis. To import data to SPSS follow these steps:
- Download the XLS version of your data
- Open SPSS and import the Excel file into a new dataset (File>Open>Data). This will fully import your data into SPSS. If you would like to use the labeled version of your data (using the labels visible to the interviewer instead of the values saved in the dataset), follow the following steps as well.
- On the project page in KoBoToolbox, within the Form section, click the grey download button and choose the option 'SPSS labels'.
- Unzip the downloaded file and open the SPSS syntax (.sps) file
- In SPSS open the SPS syntax file by going to File>Open>Syntax (if you have multiple files pick the one whose language you want to include in your SPSS dataset).
- Go to Run>All. Your dataset will now be labeled for both variables and response options.