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

3 Answers 3

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

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

You can right click on the overview screen and choose export to excel. A new window will pop up. Click on "show a graphical summary of responses" which should open the graphical response page with yellowish arrow tags click on the arrow shown in the picture and it should turn into a green check boxenter image description here This should select all of your survey questions and auto format them for excel. All you have to do is click import at the bottom of the page.

share|improve this answer

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.