How to Save Survey Results to a Spreadsheet

Survey results are typically downloaded as reports in PDF files.  You have the option to also save your survey results in spreadsheets.  This will allow you to use powerful spreadsheet functions to analyze your data.  When saving results to a spreadsheet, you will still receive the PDF report.  All questions and answers presented in the spreadsheets will be based on the question IDs and the answer IDs, NOT the more user-friendly question and answer fields you see in the PDF report.  This is to keep cell length at a minimum.  It may be helpful to have the Survey Template open in Pruvan Online the first few times you use the spreadsheet to become familiar with the IDs.

• Save Surveys to Individual Spreadsheets
• Collect Survey Results in a Single Spreadsheet

Save Surveys to Individual Spreadsheets

This will create a spreadsheet in CSV format for each survey that is submitted.  The questions will be on the top row and the answers on the 2nd.

Enable Saving Surveys to CSV

Once survey saving is active it will begin processing data for surveys downloaded going forward.  It will NOT process data from surveys that have been previously downloaded.  Follow these steps to enable:

1. Open your Pruvan Downloader
2. Click Settings
3. Select Options
4. Check Export Survey Answers to CSV
5. Click Save

Collect Survey Results in a Single Spreadsheet

This will collect survey results by Survey Template.  A Survey Template is the blank form a user fills out to submit a survey.  So if you have an Initial Inspection survey template then you can collect all of the surveys submitted from that template into a single file.  This will let you quickly analyze differences between answers to the same question across multiple survey submissions.  The header row will have some project fields and then the questions from the template and each row after will be from an individual survey submission.

Activate Survey Collection

Once survey collection is active it will begin collecting data for surveys downloaded going forward.  It will NOT collect data from surveys that have been previously downloaded.  Follow these steps to enable Survey Collection:

1. Open your Pruvan Downloader
2. Click Settings
3. Select Options
4. Check Collect Survey Answers
• Note: You must check Export Survey Answers to CSV in order to check Collect Survey Answers
5. Click Save