Forum Discussion

Brass Contributor

Apr 08, 2021

Location of Excel sheet holding Forms responses

Hello If a user creates a form and shares it, responses go to an Excel sheet that the user can access through Forms. Where SPECIFICALLY is the Excel file located, not from a country perspective ...

microsoft forms

RossChevalier

Brass Contributor

Apr 13, 2021

Thank you for your reply. What is not clear is if I save the Excel file to my file system (One Drive or Teams share) if additions from new submissions will show up on the sheet now in the filesystem or if it becomes a static copy. If not, my issue remains open.

ihubay

Copper Contributor

Sep 05, 2023

RossChevalier Hello, I have the same question 2 years later. Were you ever able to solve the issue?

DingkunXie
Microsoft
Sep 06, 2023
ihubay

Check this KB, it depends on how you create your form, it may be stored as a local file or an online file in OneDrive/SharePoint.

https://support.microsoft.com/en-us/office/microsoft-forms-and-excel-workbooks-c61b5751-8128-4434-abb0-246f5e2a3b01#:~:text=In%20Microsoft%20Forms%2C%20you%20can,of%20your%20form%20or%20quiz.
Rob_Elliott
Bronze Contributor
Sep 05, 2023
ihubay if you create a copy of the spreadsheet, new submissions will not be added to it. YOu might be better to create a Group form which will then store the spreadsheet in SharePoint.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)