Learning Hub > SharePoint > Viewing Survey Results

Viewing Survey Results in SharePoint

1. As the administrator of the survey, go to your SharePoint site and click on the survey title (the bar above the survey on the homepage).
2. Click show a graphical summary of responses to view answers in a simple bar graph.
3. You can also click show all responses to open individual submissions.

Export Results to Excel

1. First, on your computer, launch Excel. Minimize it and go to your survey.
2. On the survey page, click Actions and choose Export to Spreadsheet.
3. A dynamic query will run and require communication with Excel. When prompted for what to do with the file owssvr.iqy, choose Open.
4. Excel may prompt you too, about security measures. Click Enable to open the file.
5. Your results will display with filters on each column. Copy the information you want or save the file as a spreadsheet. Modify the information to create charts and graphs that suit your needs or use sorting features to weed out duplicates.