ENGAGE HELP CENTER
Export data
Learn how to download the survey results to a processing-friendly format.
The administrator can easily export the results of Survey activities accessible from the Activities view of the project. Export options can be accessed by clicking on the downward arrow icon placed at the bottom of each activity card.
Export options provide:
- All answers selection,
- Each participant's recent answers selection,
- Output to be generated in Excel or JSON format.

Additional option:
- Filtered results by period.
Each participant's recent answers
This selection provides an export of the most recent responses of all participants which is an important feature to use if the surveys are set up so that the participants are required to resubmit data with a certain time interval, e.g., once every two months.
Each response is assigned a number, which can be seen in the first column of the Excel spreadsheet. The names of the questions are displayed in the first row of the spreadsheet. The timestamp of the response is also available in the export file.
It is important to label your questions and responses thoroughly in the Survey builder, to make it easier for you to use the exported data.
All answers
This export option provides a file with the same structure and content as the one described above. In addition, it provides administrators with an export of all responses. For example, if one of the participants has completed the same survey multiple times, the file would contain all of the responses, and each of those responses would be assigned their own number and would be seen in a separate row.
If expressions and calculations have been developed in the section Calculated answers, the calculated values will also be displayed in the Excel data export files in a separate right-most column.
Excel exports
All answers exported in Excel will contain two sheets with the participant responses compiled in the sheet named Data and the survey legend - a list of all of the survey Name and Value elements - in the sheet named Legend.
JSON exports
Administrators can also export data in JSON format which is a format that allows storing data in readable text format that can be easily generated and processed by various systems.
{
		"label": "ICD Code",
		"key": "icd",
		"type": "icd",
		"options": [{
				"key": "A02",
				"label": "A02: Other salmonella infections"
			}, {
				"key": "A038",
				"label": "A038: Other shigellosis"
…
}
Such a format not only allows administrators to process data in various statistical tools but also makes it easy to showcase the metadata (statistical information) in Longenesis.Curator - a platform created by Longenesis to help your organisation visualize your data and engage in collaborations with other researchers and stakeholders.

Visit Curator Home Page to learn more.
If expressions and calculations have been developed in the section Calculated answers, the calculated values will also be displayed in the JSON export files as a separate code element.
{
      "height_cm": {
        "answer": 175,
        "answer_value": 175,
        "question": "Please indicate your height (cm)",
        "question_value": "height_cm",
        "type": "text"
      },
      "weight_kg": {
        "answer": 40,
        "answer_value": 40,
        "question": "Please indicate your weight (kg)",
        "question_value": "weight_kg",
        "type": "text"
      },
      "person": 1497,
      "created_at": "2022-06-15T08:51:02.244253+00:00",
      "BMI calculation": 13.1