Populate an excel spreadsheet from Office 365 Forms

Copper Contributor

Hi all.  New to the community. Appreciate any help.  I looked for this topic but did not see anything similar.

 

In the Google suite, when a form is completed by a user, responses are captured directly in a Google sheet.  As more responses come in, the number of rows increases.  This spread sheet can be accessed directly to check responses. 

 

I'd like to do the same using Forms and Excel.  Unfortunately, it seems that Form responses are captured in the Forms app itself.  Then, in a separate step, can be exported to a static Excel spread sheet. 

Does anyone know if it's possible to map Office questions to a specific Excel sheet so that the form submissions populate in the Excel doc? Then, I can check the Excel doc for responses? 

Thanks for the help. 

2 Replies

@JohnLane Forms automatically stores responses in an excel spreadsheet which you access from the Responses tab:

OpenInExcel2.png

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Thanks Rob. I take it that the answer to the use case I defined is “no”.