Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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?

share|improve this question
    
i tried it through the View All site contents method but still dont' the export to excel option, any ideas please? –  user15359 Mar 6 '13 at 13:14
add comment

2 Answers 2

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.

share|improve this answer
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.