How to export Survey results to Microsoft Excel

I regularly create surveys in SharePoint for various things but today I was asked to export the results of an old survey into Excel so that the data can be used elsewhere.  I haven’t done this before but after a quick look around I realised how easy it is to do.  If you need to know how, just follow these follow the steps below:

1.    Open the list of surveys

2.    Click on the required survey

3.    From the Actions menu choose Export to Spreadsheet


4.    Click OK to the message about having a compatible application


5.    Click Open to view the exported file


6.    If warned about a potential security concern, click Enable


7.    You can now manipulate your survey results in Excel

[BlogBookmark] [Blogsvine] [] [Digg] [Facebook] [Furl] [Google] [LinkedIn] [MySpace] [Reddit] [Slashdot] [StumbleUpon] [Twitter] [Windows Live] [Yahoo!] [Email]