How to Change Question Type in Microsoft Forms Without Losing Responses
Question details
The user wants to change an existing Text question into a Choice question without erasing the responses already submitted by participants.
- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Updating an active form that has already collected responses and requires a question format modification for future submissions.
- Observed behavior
- Microsoft Forms restricts changing the question type once created, meaning users cannot convert a Text question to a Choice question while preserving historical data natively.
Before modifying your active form, always navigate to the Responses tab and click 'Open in Excel' to create a secure backup of your currently submitted data.
Keep the Original Question and Create a New Choice Question
Since direct conversion is unsupported in Microsoft Forms, the safest workaround is to retain the original question for historical responses and introduce a new Choice question for future respondents.
Microsoft Forms locks question types upon creation to protect database integrity. Deleting the original question will permanently delete all associated responses.
To avoid data loss, you must keep the old question intact while redirecting new users to the newly formatted question.
Open your form in Microsoft Forms and locate the original Text question. Turn off the 'Required' toggle at the bottom right of the question box so future respondents do not have to answer it. Optionally, append '(Deprecated)' or '(Do Not Answer)' to the question title.
Click the '+ Add new' button immediately below the original question and select 'Choice'. Build your new question with the desired options and toggle on 'Required' if necessary.
Once new responses are collected, go to the 'Responses' tab and click 'Open in Excel' to export the data. You can then use spreadsheet functions to merge the column containing the old text answers with the column containing the new choice answers.
Easily Merge and Clean Exported Form Data with WPS Office
Since Microsoft Forms requires exporting data to a spreadsheet to combine your old and new question responses, WPS Spreadsheet is the perfect tool for the job. It is a free, lightweight, and highly compatible alternative to Microsoft Office that makes data cleaning effortless.
- 1. Open your exported data: Launch WPS Office, select 'Spreadsheet', and open the .xlsx response file you downloaded from Microsoft Forms.
- 2. Create a consolidated column: Insert a new blank column next to your question data. Use formulas like IF or CONCATENATE to merge the historical Text responses with the new Choice responses.
- 3. Save your progress: Click 'Save' to keep your data securely stored in the fully compatible Microsoft Excel format.
Frequently Asked Questions
Why can't I directly change a Text question to a Choice question in Microsoft Forms?
Microsoft Forms permanently locks the question type upon creation to ensure the structural integrity of the form's backend database. This prevents accidental corruption or deletion of data submitted by previous respondents.
If I delete the original Text question, what happens to the previously submitted responses?
Deleting any question in Microsoft Forms will permanently delete all historical responses associated with that specific question from the form's results and database. Always export your data before deleting questions.
Is there a way to hide the old question from future respondents?
Microsoft Forms does not feature a direct 'hide' button for questions. The most effective approach is to mark the old question as not required, change its title to indicate it should be skipped, or use branching logic to bypass it entirely.
How do I combine the old text data and new choice data after exporting?
Once you export the form results to an Excel workbook, the old and new questions will appear as two separate columns. You can use standard spreadsheet functions, such as text concatenation or conditional IF statements, to map both columns into a single unified column for easier analysis.
