Data Import & Export

Fix Microsoft Forms Creating Extra Columns in Excel

WPS Editor Oct 7, 2026 869 views

Question details

The user needs to resolve an issue where a Microsoft Form generates duplicate fields, question columns, or unexpected headings in its linked Excel workbook.

How to Fix Microsoft Forms Creating Extra Columns in Excel

Product: Microsoft Forms and Microsoft Excel
Device & OS: not provided
Scenario: Syncing Microsoft Forms responses to an Excel workbook for data collection and analysis.
Observed behavior: The linked Excel workbook displays duplicate questions, unexpected headings, or extra columns that do not match the actual fields present in the active Microsoft Form.

Before you start

Ensure you have owner or administrator access to the Microsoft Form in question, and avoid deleting the active form to prevent permanent data loss while troubleshooting.

Solution 1Recommended

Sync Responses to a New Excel Workbook

Creating a new workbook connection forces Microsoft Forms to generate a fresh, uncorrupted response sheet with the correct column structure.

When the background connection between Microsoft Forms and Excel becomes corrupted, it often results in duplicated or misaligned columns. By syncing the responses to a brand new Excel sheet, you can bypass the corrupted formatting without losing the existing form data.

Open the affected form

Navigate to Microsoft Forms in your web browser and open the specific form that is generating extra columns in Excel.

Go to the Responses tab

Click on the 'Responses' tab located at the top of the form editing page to view your data collection status.

Access more options

Click on the three horizontal dots (More options) menu located next to the 'Open in Excel' button.

Sync to a new workbook

Select 'Sync all responses to a new workbook' from the drop-down menu. This will generate a fresh Excel file in your OneDrive or SharePoint.

Verify the new columns

Open the newly created Excel workbook to confirm that the duplicate fields and extra columns have been successfully resolved.

Data Preservation: This process safely copies all existing responses to the new workbook without interrupting the form's ability to collect new data from users.

Solution 2

Duplicate the Microsoft Form

Duplicating the form creates a clean slate with a new backend ID, which can resolve persistent syncing bugs when creating a new workbook fails.

Free Microsoft Office alternative

Analyze and Clean Your Form Data Seamlessly with WPS Office

Since Microsoft Forms syncing bugs are strictly tied to the Microsoft 365 cloud infrastructure, you may find it easier to download the raw data and clean it up offline. WPS Office provides a lightweight, highly compatible alternative to Microsoft Office, allowing you to easily open, edit, and reorganize your downloaded Excel response sheets for free.

1. Download the raw data: Download your raw response sheet directly from Microsoft Forms as an .xlsx file to your local computer.
2. Open with WPS Spreadsheet: Launch WPS Office, select 'Spreadsheet', and open your downloaded file to view the form responses.
3. Clean the extra columns: Use WPS Spreadsheet's intuitive column management tools to quickly highlight, right-click, and delete any duplicated or broken columns.

Fully compatible with Microsoft Excel (.xlsx) formats and exported form dataLightweight application that opens large data sets and spreadsheets rapidlyFree to use with a familiar, user-friendly interface for effortless data cleaningPowerful built-in tools for removing duplicate columns and organizing responses

microsoft office alternative - wps office

Frequently Asked Questions

Why does my downloaded Excel sheet show duplicate columns from Microsoft Forms?

This usually happens when form questions are modified, renamed, or deleted after responses have already started collecting. The backend connection between Forms and the Excel workbook retains the old column data and adds new columns for the updated questions, causing duplicates.

Will deleting extra columns in Excel affect my live Microsoft Form?

If you are editing a downloaded, offline copy of the Excel file, it will not affect the live form. However, if you are editing the live-synced cloud workbook via SharePoint or OneDrive, manually altering the table structure can break the sync connection entirely.

How do I recover missing Forms data if the new workbook doesn't show it?

If syncing to a new workbook fails to retrieve all responses, the data synchronization might have failed permanently on the server side. You will need to contact your Microsoft 365 administrator to open a direct support ticket with Microsoft for potential backend recovery.

Excel & Data Problems