Exporting Sites

Classic Interface

The following section describes the steps for exporting Sites as an XLS or CSV file in the Classic Data Entry Interface.

You can export the Sites that have been submitted to an Activity during Data Collection in XLS or CSV Format.

  • Due to XLS limitations, there is an Export Limit of 256 columns, if you have more than this amount of columns we recommend using the CSV Format.
  • If your Database includes data from linked indicators, this data will not be included in the export.
  • All data shown here is fictional and for demonstration purposes only.
How to Export Sites in XLS Format
  • Select "Classic Structure" from the "Export" pop-up window and click on the "Export" button.
  • A pop-up window will display the progress of your download. If the download does not start automatically, click on the link. 
  • Once the download is complete click on the "Close" button.
  • Once downloaded, click on the file on the Download Bar of your browser to open it.
  • The Sites have been exported as an XLS file.
  • Each Site submitted to your Activity will result in a single record (i.e. row) in the exported spreadsheet. All relevant information will be stored in the columns. This includes geographic information such as the names of the administrative levels as well as the latitude and longitude if the Site is linked to a Location.
  • Single-selection attributes will have their label as the value in the column, but multiple-selection attributes will have a separate column for each option and 1 as the value if it is selected and 0 otherwise.
Example form design
How to Export Sites in CSV Format
  • Select "Form Structure" from the "Export" pop-up window and click on the "Export" button.
  • A pop-up window will display the progress of your download. If the download does not start automatically, click on the link. 
  • Once the download is complete click on the "Close"button.
  • Once downloaded, click on the file on the Download Bar of your browser to open it.
  • The Sites have been exported as a CSV file.