Tracy van der Schyff

#Office365Challenge – Now that we’ve successfully built a survey in SharePoint, as well as applied various settings / validations, we’ll focus on the output. There’s no point to surveys, if you can’t access the data or report on it. So how will we do this?

Related posts:
Around the Office in 365 Days: Day 26 – SharePoint Surveys = Creating the Survey
Around the Office in 365 Days: Day 27 – SharePoint Surveys Part 2 = Survey Settings
Around the Office in 365 Days: Day 28 – SharePoint Surveys Part 3 = Branching Logic
Around the Office in 365 Days: Day 29 – SharePoint Surveys Part 4 = Making changes to your survey

SharePoint has a couple of OTB options to extract the data from your completed surveys.
Export to Spreadsheet – Click on Actions (1), then on Export to Spreadsheet (2), if you’re not in the Overview view (3), you will not see the Export to Spreadsheet option.
This will allow you to export the data to Excel, where you can build Charts and Pivots on the data.
View RSS Feeds – Click on Actions (1), then on View RSS Feeds (4). This will open the RSS Feeds view where you can copy the URL to create a RSS Feeds in your Outlook or for a RSS Feeds Web part. Read my post Around the Office in 365 Days: Day 11 – RSS Feeds in Outlook for more detail.
Alert Me – Click on Actions (1), then on Alert Me (5) to setup an alert. Based on how you setup the alert, SharePoint will mail you every time someone completes the survey or give you daily updates.
Show graphical summary of responses (6) – These are pretty neat if you have a lot of choice / rating fields in your survey. It does not allow for download / print of the report – but I use Snipping tool to capture some of the images and use them in my reports.
Show all responses (7) – gives you a list of all the responses.

That’s all I have to say about the reporting. In tomorrow’s post I will give you tips on how to share your survey for responses and to pretty it up a bit.

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.

Keep in mind that these tips and tricks do not only apply to Office 365 – but to the overall Microsoft Office Suite as well as where applicable, SharePoint.