Others

Fix Microsoft Forms Branching and Duplicate Excel Responses

Huma Ashraf Ch Sep 28, 2026 868 views

Question details

The user needs to fix unexpected "Other" categories and duplicate/triplicate responses appearing in an Excel workbook synced from Microsoft Forms.

How to Fix Microsoft Forms Branching and Duplicate Excel Responses

Product: Microsoft Forms
Device & OS: not provided
Scenario: Rebuilding a form where staff must answer specific questions based on an activity type without triggering branching loops that duplicate data.
Observed behavior: The synced Excel workbook displays an unexpected "Other" category not present on the live form, alongside duplicated and triplicated answers due to branching returning respondents to earlier questions.

Before you start

Before modifying your form's branching logic, pause response collection and download a backup copy of your current Excel responses to avoid losing any existing data.

Solution 1Recommended

Reorganize Form Flow by Duplicating Questions

Instead of using branching to send respondents backward to an earlier question (which creates data loops), duplicate the question and place it later in the form flow.

When branching rules redirect a user to a question they have already passed, Microsoft Forms interprets this as a loop. This often results in duplicate or triplicate columns and answers in the synchronized Excel workbook. Duplicating the question prevents this backward redirection.

Locate the target question

Open your Microsoft Form in edit mode and scroll to the specific question that you want respondents from different branches to answer.

Duplicate the question

Click anywhere on the question to expand it, then click the 'Copy question' icon (two overlapping pages) at the top right of the question box.

Reposition the copied question

Drag the newly copied question and drop it immediately after the relevant branching point so the respondent continues moving forward.

Update branching logic

Click the 'More options' (three dots) icon at the top right of the screen, select 'Add branching', and update the flow to point to the newly duplicated question instead of the original one.

Reorganize Form Flow by Duplicating Questions

Linear Flow Maintained: By keeping the form flow strictly linear, you prevent the Microsoft Forms backend from generating duplicate response columns in your Excel export.

Solution 2

Clear Unexpected Categories by Syncing to a New Workbook

If an unexpected "Other" category appears in your Excel data but not on the live form, it is likely a leftover artifact from an older form version. Syncing to a new workbook clears this.

Powerful Excel Alternative

Clean Up Duplicate Form Responses Using WPS Spreadsheet

If your exported Microsoft Forms workbook is already filled with duplicate and triplicate entries due to past branching errors, use WPS Spreadsheet to instantly clean and organize your dataset.

1. Open your downloaded responses: Launch WPS Office and open the .xlsx file you downloaded from your Microsoft Forms Responses tab.
2. Select your response data: Highlight the specific columns or the entire data range that contains the duplicate or triplicate respondent entries.
3. Use the Deduplication tool: Navigate to the 'Data' tab on the top ribbon and click on 'Highlight Duplicates' to review them, or choose 'Remove Duplicates' to permanently delete redundant rows.
4. Save the cleaned workbook: Once your data is clean, press Ctrl+S to save the updated Excel file safely on your device.

Fully compatible with Microsoft Excel (.xlsx) downloaded from Microsoft Forms.One-click 'Remove Duplicates' feature to instantly clean up messy data.Advanced filtering and sorting to help you identify unexpected 'Other' categories.Free, lightweight, and features a familiar user interface for seamless workflow.

microsoft office alternative - wps office

Frequently Asked Questions

Why is an 'Other' category appearing in my Excel export when it isn't on the live form?

This usually happens if the 'Add "Other" option' was enabled during the initial form creation and later removed. The synced Excel workbook often retains legacy data columns. Syncing your form to a brand new workbook will remove this artifact.

Can I use branching to send respondents backward to an earlier question?

While technically possible, branching backward creates a loop that confuses the form's data processing. This is the primary cause of duplicate or triplicate response entries in your Excel workbook. It is highly recommended to duplicate the question instead.

How do I stop duplicate responses from saving to my spreadsheet?

You must rebuild your form's branching logic to ensure a strictly linear progression. Avoid directing different branches back to the same earlier question. Instead, copy the necessary question and place it at the end of each respective branch.

Do I need to create a new Excel workbook after fixing the form's branching logic?

Yes. If your old workbook is already corrupted with duplicate columns from branching loops, syncing your updated form to a new Excel workbook is the best way to ensure the fresh data structure is correctly applied.

Office Quick Solutions