How to Remove Deleted Microsoft Forms Questions from Excel Results
Question details
The user wants to remove blank or obsolete columns in an Excel response workbook that remain after deleting or renaming questions in the linked Microsoft Form.
- Product
- Microsoft Forms and Excel
- Device & OS
- not provided
- Scenario
- Managing live form responses exported to an Excel workbook on OneDrive or SharePoint.
- Observed behavior
- Deleted or renamed questions leave permanent blank columns in the existing Excel workbook, and the file does not automatically remove them while continuing to receive updates.
Ensure you are logged into the Microsoft 365 account containing the original form and have access to the OneDrive or SharePoint folder where the current responses are stored.
Sync Form Responses to a New Excel Workbook
Generating a brand new synchronized workbook ensures that your column layout perfectly matches the current form questions while retaining all previous responses safely.
Manually deleting columns in an actively synced Excel workbook can corrupt the live data connection between Microsoft Forms and Excel. By creating a new sync, the system cleanly maps existing and future responses to the updated question set.
Log in to your Microsoft 365 account and open the specific form you need to update.
Click on the 'Responses' tab located at the top of the form editor.
Click on the 'More options' menu (the three dots) next to the 'Open in Excel' button, and select the option to synchronize or sync all responses to a new workbook.
Allow the system to process the request. The newly generated Excel workbook, now free of the deleted question columns, will be saved next to your original file in OneDrive or SharePoint.
Analyze and Edit Downloaded Form Data Seamlessly with WPS Office
While live cloud synchronization requires the Microsoft ecosystem, you can easily clean up, format, and analyze your downloaded form responses offline using WPS Office. It provides a highly compatible and lightweight alternative for all your spreadsheet needs.
- 1. Download Form Data: Export your Microsoft Forms responses as an offline .xlsx file.
- 2. Open with WPS Spreadsheet: Launch WPS Office and open the downloaded Excel file to view your data.
- 3. Analyze and Format: Use WPS Spreadsheet's robust tools to delete old columns, create charts, or build PivotTables without worrying about breaking live cloud syncs.
Frequently Asked Questions
Can I manually delete the blank columns in the original Excel response file?
It is highly discouraged if the form is still active. Manually modifying the columns in a live workbook can break the synchronization between Microsoft Forms and your Excel file, causing future responses to fail to record properly.
What happens to my past responses when I create a new synced workbook?
All of your existing responses are securely carried over into the new workbook. The data will simply be re-mapped to fit the updated, current layout of the form questions.
Where is the new response workbook saved after I create it?
The newly synced Excel workbook is automatically saved in the same OneDrive or SharePoint directory as your original response workbook.
Will the old Excel file continue to receive updates?
No. Once you establish a new synchronized workbook, the active data connection shifts to the new file. The old Excel file becomes a static backup and will no longer receive new form submissions.
