SharePoint Document Issues

How to Move a Microsoft Forms Response Spreadsheet to SharePoint

Maira Mehtab Sep 21, 2026 869 views

Question details

The user needs to move the Excel response spreadsheet associated with a Microsoft Form to a group's SharePoint or Teams document library.

Product: Microsoft Forms / SharePoint
Device & OS: not provided
Scenario: A user has moved a Microsoft Form from their personal OneDrive to a group, expecting the associated response spreadsheet to follow, but it did not.
Observed behavior: The Microsoft Form successfully moves to the selected group, but the connected Excel workbook containing the responses remains in the user's personal OneDrive.

Before you start

Ensure you have the necessary edit permissions for both the original OneDrive location and the destination SharePoint document library before attempting to move the spreadsheet.

Solution 1Recommended

Manually Move the Workbook to SharePoint

Use the standard file moving feature in OneDrive to manually relocate the response workbook to the desired SharePoint library.

Since recent updates to Microsoft Forms, moving a form no longer automatically relocates its response workbook. You must move the file separately to ensure it resides in the correct group library.

Locate the workbook in OneDrive

Open your OneDrive and navigate to the folder where the Microsoft Forms response Excel workbook is currently saved.

Select the Move option

Click the three dots (ellipsis) next to the workbook file name and select 'Move to' from the dropdown menu.

Choose the SharePoint destination

Browse your sites, select the target SharePoint group and document library, and click 'Move here'.

Verify the connection

Open the form in Microsoft Forms, go to the 'Responses' tab, and open the Excel file to confirm it correctly links to the new SharePoint location.

Maintain File Link: Using the 'Move to' function generally preserves the file ID, allowing the form to continue syncing new responses to the relocated workbook.

Solution 2

Disconnect and Sync to a New Workbook

If manually moving the file fails to keep the sync active, you can disconnect the old workbook and generate a new one directly in the SharePoint group.

Free Microsoft Office alternative

Edit Your Response Spreadsheets with WPS Office

If you need a lightweight, cost-effective way to analyze Microsoft Forms data, WPS Office is an excellent choice. It serves as a powerful, free alternative to Microsoft Office, letting you open, view, and analyze exported Excel spreadsheets seamlessly.

1. Download the Spreadsheet: Export or download the response spreadsheet from your SharePoint library to your local computer.
2. Open with WPS Spreadsheet: Launch WPS Office, select 'Spreadsheet', and open your downloaded .xlsx file.
3. Analyze your data: Use WPS Office's built-in tools to filter, format, and analyze your form responses just as you would in Microsoft Excel.

Fully compatible with Microsoft Excel (.xlsx) formats exported from Microsoft Forms.Free and lightweight, allowing for rapid opening of large response datasets.Familiar tabbed interface makes migrating from Microsoft Office effortless.Includes robust data analysis tools like PivotTables, advanced formulas, and charts.

microsoft office alternative - wps office

Frequently Asked Questions

Why didn't my Excel response spreadsheet move with my Microsoft Form?

Following a Forms upgrade, moving a form to a new group only moves the form itself. The associated Excel workbook remains in its original OneDrive location and must be moved or re-synced manually.

Will I lose my form data if I disconnect the workbook?

No, your form responses are stored in Microsoft Forms. Disconnecting the workbook simply severs the link to that specific Excel file. When you sync to a new workbook, all past and present data will populate the new file.

How can I verify where my current form responses are being saved?

Open your form in Microsoft Forms, navigate to the 'Responses' tab, click the three dots next to the Excel icon, and hover over or select the option to view the file location. It will display the current SharePoint or OneDrive path.

Document & File Issues