5. Exporting Data in Excel/CSV Format

© 2013 Plum Group, Inc. All rights reserved.

4. Summary Reports Prev Next 6. Exporting Responses and Audio by Web Service

5.1 Getting Started

To export data in Excel.csv format for your survey, first place your mouse on the "Reports" header as shown below and click on Export as Excel/CSV.

5.2 Filtering Responses

For Survey, you can select which survey you want to export the data for, as long as they have data collected for them. For Start Date and End Date, you can enter in a time period to filter how you want to view responses in Excel. To enter a date, you can either enter it by hand in a MM/DD/YYYY format...

or, you can use the calendar icon tool to select a date.

If you don't want to filter how you view your responses by date, you can leave Start Date and End Date blank.

To filter answers by response, click on the "Plus" button next to Add a filter. Here, you can select from the drop-down box under the "Item" header a question or value as a filter.

For Response Method, you can filter your responses by whether the user answered your survey by web or by phone. To filter your responses by phone, select Phone from the drop-down box under the "Value" header. To filter your responses by web, select Web from the drop-down box under the "Value" header.

For Caller ID or IP Address, you can filter your individual responses using the drop-down box under the "Comparison" header. The choices you can select are: is, is not, contains, and doesn't contain.

Once you decide on how you want to compare your individual responses to the filter, you can enter a value in the textbox under the "Value" header to complete your filter.

You can also filter your responses by the questions in your survey. To do this, select one of the questions in your survey from the drop-down box under the "Item" header.

From here, you can select how you want to filter your responses for this question by selecting a choice from the drop-down box under the "Comparison" header and by entering a value under the "Value" header.

Once you have completed filtering your responses, click on the Excel.csv button to download your responses in .csv format.

5.3 Downloading Audio Responses

In addition to downloading CSV responses, you can also download audio responses. To download these responses, click the Audio.zip button.

Once you click this button, you can download a zip file containing all the audio responses for your survey.

If you open up the zip file, notice that the naming of your audio files is by the ANI followed by a random number. Please note that the naming of your audio files corresponds to the <file:###-###.wav> tokens in the CSV response data. This will allow you to uniquely identify your downloaded audio responses with a respondent. You can rename these audio files to however you like once you have downloaded them, but make sure you do the same for your CSV file so that you keep track of the audio response files for each respondent.

4. Summary Reports Prev Next 6. Exporting Responses and Audio by Web Service