Export

Select the Export menu on the analysis page.

Export dialog

Exporting Results

The default output format is XLS. Select your survey, then click Export to download the data.

Options

Type

  • Excel

  • CSV

  • Openstreetmap. An OpenStreetMap XML file of the location data in the selected forms, for use in OSM editing tools.

  • Shape. A shapefile of the location data.

  • Media. A ZIP file containing media. The name of each media file is taken from questions specified in the dialog.

  • KML / KMZ

  • VRT / CSV. A CSV file of the data with a GDAL virtual file (VRT) describing its geometry, so that it can be opened directly in GIS tools such as QGIS.

  • Stata / CSV. A CSV file with a Stata script to load it.

  • SPSS / CSV. A CSV file with an SPSS script to load it.

For most types, Include Read Only adds questions that are read only to the export. They are left out by default.

Depending on the selected export type, other options change.

XLS Options

  • Excel format. Specify XLSX or the older HTML format.

  • Language. If selected, an extra header row is added with labels for the selected language.

  • Compress select multiples. If selected, choices for select-multiple questions are exported in one cell, separated by spaces. If not selected, each choice is exported in its own column, with a value of 1 if selected and 0 if not selected.

  • Split lat/lon. If selected, latitude and longitude for geopoint questions are exported in separate columns.

  • Embed images in Excel file. If selected, images are included in the exported Excel file. Image width is set to 300 pixels. Click an image in the spreadsheet to open the full-size image.

  • HXL. Add a row of HXL (Humanitarian Exchange Language) hashtags under the headings. The hashtag for a question is taken from any value in its appearance that starts with #, for example #affected+f. New XLSX format only.

  • Include metadata. Select to include metadata in the export.

  • Include Read Only. Include questions that are read only.

Select Form

When a survey is selected, a hierarchical list of forms is shown here.

  • Select the main form to export just the data in the main form.

  • Select a subform to export that subform and its parent forms.

Filters

You can filter exported data by date range and by using the advanced filter. For details, see Help on specifying advanced filters.