Group Form Data

Not applicable

Hi all,


Apologies if this question has been covered, I was unable to find it.


I have a Group Form.


How can an external Excel sheet pull the data from that Group Form Data Sheet?


I'm unsure which 'Get Data' option to choose, all the ones I try simply cannot 'see' the Group Form Data sheet within the SharePoint directory.


Many thanks for any time with a response.

1 Reply

If your Form was made through the Applet and not from a Group/Team site, I'm not sure if there is a way to get to the source sheet directly, you'd have to rely on downloading it.


One thing you could try to get to the data more easily would be creating a List replicating the structure of your Form, copying over what submissions you already have, and creating a Flow to direct responses to your List. This makes working with Form data a little more reliable in my mind, and would accomplish your need if the source sheet proves elusive.