Others

How to Add Microsoft Forms Questions Without Losing Previous Responses

Maira Mehtab Sep 27, 2026 869 views

Question details

The user wants to know how to add questions to an active Microsoft Form over multiple days without erasing or losing the data from earlier submissions, and how to consolidate all the survey results.

Product: Microsoft Forms / Microsoft Excel
Device & OS: not provided
Scenario: Modifying a live survey or quiz by adding follow-up questions over time while keeping earlier response data intact.
Observed behavior: Respondents need to be able to answer new questions without the form owner losing existing response data, and the final results need to be combined in a spreadsheet.

Before you start

Before modifying an active form, download a backup copy of your current responses to Excel to ensure no existing data is accidentally lost during the editing process.

Solution 1Recommended

Create a Separate Form and Combine Results in Excel

The safest approach for multi-day question additions is creating separate forms for each stage and merging the data later using Excel's Get Data feature.

By using separate forms for follow-up questions, you completely eliminate the risk of altering existing response data. You can seamlessly merge the exported datasets in Excel using Power Query.

Create a new form

Go to Microsoft Forms, create a new form, and add your follow-up questions for the next stage of your survey.

Collect and export responses

Distribute the new form link. Once responses are collected, open both the original form and the new form, and click 'Open in Excel' to export the data for both.

Combine workbooks

Open Excel, navigate to the 'Data' tab, click 'Get Data', and use Power Query to merge the two workbooks based on respondent emails or unique IDs.

Solution 2

Add New Questions Directly to the Existing Form

You can add new questions to an active form to keep everything in one place, provided you do not touch the previously published questions.

Free Microsoft Office alternative

Seamlessly Manage Form Data and Spreadsheets with WPS Office

Need a powerful tool to consolidate survey responses and analyze data? WPS Office offers highly compatible spreadsheet tools that serve as a robust, free alternative to Microsoft Office. With intuitive data manipulation features, you can easily merge and analyze your exported form results.

1. Open WPS Spreadsheet: Launch WPS Office and create a new blank workbook in WPS Spreadsheet.
2. Import response data: Open your exported CSV or XLSX files containing the Microsoft Forms responses.
3. Merge the results: Go to the Data tab and use the 'Consolidate' feature or standard lookup functions to merge your respondents' answers into a single master sheet.

100% compatible with Microsoft Excel (.xlsx and .csv) formatsLightweight design ensures fast loading and smooth processing of large survey datasetsAdvanced data consolidation tools to quickly merge responses from multiple formsFamiliar, easy-to-use tabbed interface for a seamless transition

Frequently Asked Questions

Will editing an existing question in Microsoft Forms delete previous answers?

Yes, modifying the text, structure, or options of an existing question can alter or permanently delete the response data associated with it. It is always best to add new questions instead of changing old ones.

Can respondents edit their previous answers after I add new questions?

No, they cannot edit past submissions unless you specifically enabled the 'Allow respondents to edit their responses' setting before they submitted their initial answers.

How do I link a new Microsoft Form to the original Excel workbook?

You cannot directly link a new form to an old form's live Excel workbook. You must export the new form's results and use Excel's Power Query or data consolidation tools to manually combine the datasets.

Do newly added questions appear for people who already submitted the form?

If previous respondents open the form link again, they will see the new questions. However, they will have to submit an entirely new response unless the form is configured to allow editing of previous submissions.

Office Quick Solutions