Download Survey Data

Downloading survey Data is very useful for Data Analysis because you will be working with a Pivot Table Template where you can refresh the Data that has been downloaded from the Data Warehouse.

Window: Survey Indicator Values: Download

To Filter and then Download:

  • Data Domain: Entering the Data Domain is not required. If you only select the Data Domain, all the survey data from that domain will be selected for download. If nothing is selected all the survey data will be downloaded.

  • Survey: If you know the name of the survey you would like to access, please select accordingly. Note you cannot select more than one.

  • Country: If you know the country from the survey data you want to access, type in the country. If you do not select a survey and you select the country, all surveys from that country will download. Some surveys crosscut many countries; in that case this field will not be relevant.

  • Download: Press download and you will get the CSV downloaded file from where to access the data

This is the data on an excel spreadsheet after downloading:

![](20 (1).jpg)

Figure 20: Survey Data Download

  • Excel Web Query URL

Another way for downloading the data to import data directly to your spreadsheet is as follows:

  • * If you click on Excel Web Query from the top right hand corner of the Download Screen, you will get a drop-down from where to select ‘copy link’

    • Open an excel workbook and access ‘Data’ from the ribbon to select ‘From Access’ at the top left hand corner of the screen.

    • Copy the link on the address field and press ‘Import’

Note at the moment there is a workbook to be distributed to all nutrition users with which, by using the copied link from ‘Excel Web Query’, you will be able to do data analysis with specific charts and pivot tables that you can customize. Like this the process for updating data will be much easier because you will only need to refresh.