Microsoft 365 Migration

How to Move Microsoft Forms Responses From OneDrive to SharePoint

Maira Mehtab Sep 22, 2026 868 views

Question details

The user needs to change the save location of Microsoft Forms response data from a personal OneDrive workbook to a shared SharePoint library to ensure continuity if form ownership changes.

Product: Microsoft Forms
Device & OS: not provided
Scenario: Migrating form response data to a shared workspace to prevent data loss or access issues upon ownership changes.
Observed behavior: Forms responses are currently being saved to a personal OneDrive Excel workbook by default instead of a centralized, shared location.

Before you start

Ensure you have edit permissions for both the Microsoft Form and the destination SharePoint document library before attempting to move the response workbook.

Solution 1Recommended

Move the Excel Workbook Directly to SharePoint

You can move the connected response workbook from your personal OneDrive to a SharePoint library using Excel for the Web's built-in file location menu.

This is the most straightforward method. By moving the workbook via the web interface, the sync connection between the form and the Excel file is maintained, allowing new responses to flow directly into the SharePoint location.

Open the Response Workbook

Go to Microsoft Forms, open your form, click on the 'Responses' tab, and select 'Open in Excel' to launch the workbook in Excel for the Web.

Access the File Location Menu

Click on the file name located at the top center of the Excel for the Web interface to open the file details and location dropdown.

Move the File

Select 'Move to' from the menu, then navigate through your sites to select the preferred SharePoint document library. Click 'Move here' to finalize the transfer.

Sync Maintenance: Moving the file this way preserves the live connection. Do not download and manually re-upload the file to SharePoint, as that will break the sync.

Solution 2

Use Power Automate for Custom Response Workflows

For a more advanced and repeatable workflow, you can set up a Power Automate flow to write new Forms responses to a SharePoint Excel file or list.

Free Microsoft Office alternative

Manage Your Team's Spreadsheets with WPS Office

Looking for a simpler, lightweight way to manage shared workbooks and team data? WPS Office provides a highly compatible and cost-effective alternative to Microsoft Office. Enjoy seamless teamwork and high compatibility with Microsoft Excel formats without the heavy subscription costs.

1. Download and Install: Download WPS Office from the official website and follow the installation prompts.
2. Open Your Spreadsheets: Launch WPS Spreadsheets to easily open, edit, or create .xlsx workbooks.
3. Save and Share: Save your data and share the file directly with your team using built-in sharing features.

Highly compatible with Microsoft Excel (.xlsx) formatsLightweight application that runs smoothly on most devicesBuilt-in tools for seamless document sharing and collaborationFree to use for essential office and spreadsheet tasks

microsoft office alternative - wps office

Frequently Asked Questions

Can I change the default save location for a personal Microsoft Form?

Personal forms created in OneDrive will always default to saving in OneDrive. To have a form default to SharePoint, you must create it directly within a SharePoint site or Microsoft 365 Group instead of from your personal dashboard.

What happens to the form data if the owner leaves the company?

If a form is tied to a personal OneDrive and the user's account is deactivated or deleted, the form and its data may be lost. Moving the response workbook to SharePoint or transferring the form's ownership to a Group prevents this data loss.

How do I create a form directly in SharePoint?

Navigate to the desired SharePoint document library, click on 'New' in the top menu, and select 'Forms for Excel'. This ensures that the linked response workbook is generated and stored in SharePoint from the beginning.

Will downloading and uploading the Excel file to SharePoint keep the live sync?

No. If you download the workbook to your computer and then upload it to SharePoint, the live connection to Microsoft Forms will break. You must use the 'Move to' function in Excel for the Web to preserve the sync.

Migration & Recovery