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

RobElliott

Silver Contributor

Apr 09, 2021

RossChevalier the spreadsheet is stored somewhere on Microsoft's servers and you cannot access that location. If you want to share it without giving collaborate access just click on the Open in Excel link and then save it to your file system.

Rob
Los Gallardos
Microsoft Power Automate Community Super User

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)