Microsoft Forms: Sharing access to form data

Was playing around with MS Forms yesterday when I came across a feature I wasn’t aware of.   Basically you can create a link which will allow others to access the a summary of responses to a particular from.    I have been looking for this functionality for a while as it is often useful to allow multiple people to be able to review responses without allowing them access to change the form.

To do this simply create your form then click the responses tab.    On the responses tab click the … icon to reveal the option to “Get a summary link”.

You will then see a dialogue complete with a link to share with those who you wish to be able to access the data.

Now the above is useful however I must admit I would prefer the ability to access the data as a spreadsheet as opposed to as a summary list.   It would also be better if forms could provide specific access rights on a user level as opposed to in a link.   This is a feature I would also like to see where you are providing collaborative access to a form.   Here you are also able to create a link only, rather than to assign individual user level access.   Hopefully Microsoft are working on this.   For now, however, if you want to share responses as a spreadsheet or if you need user level access control you will need to look at using Google forms instead.

Author: Gary Henderson

Gary Henderson is currently the Director of IT in an Independent school in the UK.Prior to this he worked as the Head of Learning Technologies working with public and private schools across the Middle East.This includes leading the planning and development of IT within a number of new schools opening in the UAE.As a trained teacher with over 15 years working in education his experience includes UK state secondary schools, further education and higher education, as well as experience of various international schools teaching various curricula. This has led him to present at a number of educational conferences in the UK and Middle East.

Leave a comment