Data Import & Export

How to Import Microsoft Forms Responses Into Another Survey

Huda Qurayshi Oct 1, 2026 870 views

Question details

The user needs to know if existing responses from one Microsoft Form can be imported into a different survey.

How to Import Microsoft Forms Responses Into Another Survey

Product: Microsoft Forms
Device & OS: not provided
Scenario: Migrating data from an annual questionnaire or previous survey to a new one.
Observed behavior: Microsoft Forms lacks a native, direct feature to import responses from one survey to another.

Before you start

Ensure you have access to both the source and destination surveys in Microsoft Forms, as well as an active Power Automate account with permissions to create custom flows.

Solution 1Recommended

Migrate Responses using Power Automate and the Forms API

Since direct importing is not supported natively, you must use Power Automate to retrieve, process, and migrate the data via the Microsoft Forms API.

Microsoft Forms does not provide a one-click response import feature. To move survey data, you need to set up an automated workflow that extracts the data from the old form and pushes it to your new destination.

Access Power Automate

Log into Microsoft Power Automate using your Microsoft 365 account credentials.

Create a New Flow

Set up an instant cloud flow or an automated workflow depending on when you want the data migration to occur.

Retrieve Source Data

Add an action to call the Forms API. Use the 'Get response details' action or custom HTTP requests to pull the submitted responses from your previous form.

Process and Map the Data

Transform the retrieved data within Power Automate. Map the old response fields to the corresponding fields in your new storage location, such as a linked Excel workbook or SharePoint list.

Test the Workflow

Run a manual test of your flow to ensure the data is properly extracted and formatted without any loss of survey information.

Migrate Responses using Power Automate and the Forms API

API Limitations: Importing responses directly into the 'Responses' tab of a new Microsoft Form is heavily restricted. The standard practice is to route the migrated responses into the Excel workbook that backs the new form.

Free Microsoft Office alternative

Analyze and Manage Survey Data Easily with WPS Office

If setting up complex API workflows in Power Automate seems overwhelming, the simplest way to merge survey results is by exporting them to spreadsheets. WPS Office is a highly compatible, lightweight, and completely free alternative to Microsoft Office that makes editing and analyzing exported questionnaire data effortless.

1. Export Form Data: In Microsoft Forms, open your survey, go to the 'Responses' tab, and click 'Open in Excel' to download your data.
2. Open in WPS Office: Launch WPS Spreadsheet and open the downloaded .xlsx file to instantly access your survey responses.
3. Merge and Analyze: Copy and paste responses from different surveys into a single master spreadsheet to manually merge your data without needing API access.

Fully compatible with Microsoft Excel (.xlsx) formats for exported survey data.Free and lightweight, allowing fast access to large response datasets.Familiar user interface with zero learning curve for existing Excel users.Easily merge and analyze data from multiple forms offline.

microsoft office alternative - wps office

Frequently Asked Questions

Can I duplicate a Microsoft Form with its responses?

No. When you copy a Microsoft Form, only the structure, questions, and theme are duplicated. The responses from the original form will not be carried over to the new copy.

How do I export my Microsoft Forms responses to Excel?

Navigate to the 'Responses' tab within your selected Microsoft Form, then click the 'Open in Excel' button. This action downloads a complete spreadsheet containing all submitted answers.

Is there a native way to merge responses from two different Microsoft Forms?

There is no built-in feature to combine responses directly within the Microsoft Forms interface. You must export the results of both forms to Excel and manually combine the rows in a spreadsheet.

Excel & Data Problems