Hi All,

I have question about SharePoint survey. So I'm doing a survey through SharePoint for my company. We do this survey once every 6 months (survey questions may change every time), there are about 50 respondents. So we got 50 responses at a time. Except for export to Excel one by one, is there a way we can set it up to link all the responses to another page on SharePoint, so it could be consolidated? Or maybe point all survey responses to another page and compile responses together?  BTW We don't have SharePoint Designer, and we are not going to get it. Is there any way we can consolidate survey responses without export to excel separately and then combine them through excel? Look forward for your reply.

Hi,

Per my understanding, there is a Survey list with 50 responses, you might want to combine all the responses and display in a page.

In the OOTB Survey list, there is a Graphical Summary view which displays all the responses in a bar chart within a page:

Moreover, with the Export to Spreadsheet feature, we can export all the responses in details to a .iqy file which looks like this:

If there may be more complex requirements about the combination of the responses, a suggestion is that you can create a custom web part to gather all the data needed from this Survey list programmatically, then display in the way you want.

About how to create a custom Visual Web Part, then link below would be helpful:

http://www.sharepoint-journey.com/visual-webpart-in-sharepoint-2013.html

http://www.ashokraja.me/articles/How-to-create-a-new-Visual-WebPart-in-SharePoint-2013-with-Visual-Studio-2012