SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

None of the above should be necessary. The "Action" options are dependent on the view used. Open the "Overview" view, click "Actions" and the export option magically appears. There's no way anyone would know this so this is a good example of the bad design / UX that plagues Sharepoint.

share|improve this answer
It helped...Thanks.. – P S Nov 16 '15 at 9:19

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

Hint: make sure to use the Internet Explore Browser the it works!

share|improve this answer

Here is the solution.

I will now follow this fellow's blog!

share|improve this answer

We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.

Your Answer


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.