I have a survey and all the needed results. I need to export the results to excel, though in the process of setting up the survey I changed or removed the Overview.aspx page/view. Now when I add a webpart like the overview.aspx, everything is the same except when I go to the Action button “Export to Excel” is not an option. How do I get that option back? If I can’t get that option on a webpart back how can I get the results of the survey exported to excel?
I have not found a way to do this either.
But I found one workaround:
To avoid having to open each response to see the selection made, I found that the RSS feed view at a least contained the value chosen. From there I copied the feed into excel and cleaned it up.
I tried attaching the list in Ms Access - but it isn't an available list to choose.
If there isn't a way to get at the values in a response, I don't think I'll use this template again.
The above suggestion to find the export option didn't work for me either.
If you go the "rss feed" method, be sure you allow RSS for the list, pick your columns and adjust the item limits to meet your needs. Find this under survey settings > communications > rss feed
I had a similar problem where the export option was not visible in the action menu. As workaround, I found that if I accessed the survey from Site Settings ==> View All Site Content ==> My Survey then the export button is available.