View and analyze survey results

You can view individual responses, a list of all responses, or a graphical summary of responses. You can export your results to a spreadsheet for further analysis if you are using a spreadsheet program that is compatible with Windows SharePoint Services.

What do you want to do?

See an overview of a survey and its responses

View a graphical summary of all responses

View all survey responses

View a single survey response

Export responses to a spreadsheet

See an overview of a survey and its responses

To see an overview of your survey and its responses, click the name of the survey on the Quick Launch. If the name of your survey does not appear, click View All Site Content, and then click the name of your survey.

The overview page shows a description of the survey and the number of responses. From the overview page, if you have permissions, you can click links to see a graphical summary of responses or to view a list of all responses. If you are a survey respondent and you don't have permission to see other responses, you can click a link to see and edit the text of your own response, including a partial response.

Top of Page

View a graphical summary of all responses

The survey questions, number of responses, and percentages appear in the graphical view of summary responses.

Graphical summary of survey results

Only the responses that are complete appear in the graphical summary. A survey response is considered complete after the respondent views every page and then clicks Finish on the last page.

To view all responses, you must have permission. The person who set up your survey can specify whether people can view all responses or only their own responses.

  1. If the survey is not already open, click its name on the Quick Launch.

    If the name of your survey does not appear, click View All Site Content, and then click the name of your survey.

  2. Click Show a graphical summary of responses.

Top of Page

View all survey responses

To view all responses, you must have permission. The person who set up your survey can specify whether people can view all responses or only their own.

  1. If the survey is not already open, click its name on the Quick Launch.

    If the name of your survey does not appear, click View All Site Content, and then click the name of your survey.

  2. Click Show all responses.

    Tip   You can tell whether a survey response is complete or is only a partial response. If a survey response is complete, Yes appears in the Completed column of the All Responses view.

Top of Page

View a single survey response

  1. If the survey is not already open, click its name on the Quick Launch.

    If the name of your survey does not appear, click View All Site Content, and then click the name of your survey.

  2. Click Show all responses.

  3. Click the response that you want to view.

    To view your response, you must have permission to read content on the site. To view someone else's response, you must have permission. The person who set up your survey can specify whether people can view all responses or only their own responses.

Top of Page

Export responses to a spreadsheet

To export responses, you need a spreadsheet program installed that is compatible with Windows SharePoint Services.

  1. If the survey is not already open, click its name on the Quick Launch.

    If the name of your survey does not appear, click View All Site Content, and then click the name of your survey.

  2. On the Actions menu Menu image, click Export to Spreadsheet.

  3. Follow the prompts from your spreadsheet program to open and activate the file, if you believe the data on the SharePoint site is safe.

    Note   You may be prompted by your spreadsheet program to specify how you want to view the data, such as in an existing spreadsheet or in a new spreadsheet.

  4. If prompted to specify how you want to view the data, select the options that you want (such as in a new spreadsheet), and then click OK.

Note   If you are using a spreadsheet program that is compatible with Windows SharePoint Services 3.0, such as Microsoft Office Excel 2007, the exported data includes the results of rating scale questions. If you export to earlier versions of spreadsheet programs, the results of rating scale questions are not included.

Top of Page

Applies To: SharePoint Server, SharePoint Server 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language