Transcript:

• It is possible to export the data into Excel, CSV and SPSS formats
• Open the ‘Records’ tab and click on the ‘Export’ icon
• You can choose to either export All records or just a selection of records
• To export a selection of records, you must first select the records by marking the checkbox beside each record.
• In this study, we are going to Export all records into Excel format
• After clicking the ‘Export all records’ icon, a ‘Data export options’ window will appear
• Here you can choose the Export type
• You can also decide if you want your options to be displayed as Numbers (values) or Names (labels)
• For example, if you had a ‘Gender’ option group with a value 1 for ‘female’ and value 2 for ‘male’, if you choose to display options as numbers, 1 and 2 will appear in the data export
• It is also possible to choose if you would like to export the entire study, certain parts of the study, or certain variables
• To export the entire study, in the ‘How to export’ field choose the option ‘Interactive (tree)’ and then click on the Entire study in the tree
• To export the data, click ‘Export’ button
• The export includes multiple datasets
• Open the folder where the file was downloaded, unzip the exported folder and open the Excel document
• When choosing to export the entire study, the Excel export document will consist of several tabs
• ‘Study results’ contains all the study data collected via the Records
• ‘Study variable list’, often called as data dictionary, contains an overview of all the variables used in your study, including option groups, dependencies and calculations
• A separate data dictionary will be created for a study, reports and surveys
• You will be able to see all the option groups used in the study
• Comments and queries will be exported separately as well and you can find them in the respective tabs
• I am going to export the study into CSV format to demonstrate how this type of export looks like
• When exporting into CSV format, your export will be saved as a zip-file, containing a set of separate CSV files, one for study data and one for each report and survey, a list of variables and option groups
• If there is an upload file field in the study, it is possible to export the uploaded files using the ‘Export’ feature
• Click the ‘Export’ icon and choose the ‘Uploaded files (to zip-file)’ option
• For each upload file field, there will be a separate folder containing all the uploaded file
• A record id will be used as a prefix for each file