Why Microsoft Forms Downloads Responses as an Excel File
Question details
The user wants to understand why Microsoft Forms downloads an offline Excel workbook instead of opening responses in Excel for the Web, and how to change this behavior.
- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Exporting or reviewing survey response data from a Microsoft Form created on the web.
- Observed behavior
- Clicking 'Open in Excel' triggers a file download of an offline workbook rather than opening the data directly in the browser.
Note that downloaded offline Excel files contain a static snapshot of your responses at the time of download. If you intend to change the form's location to enable online viewing, ensure you have the appropriate group permissions.
Move the Form to a Microsoft 365 Group to Open in Browser
By transferring your personal web form to a Microsoft 365 group, the Excel response workbook will open directly in Excel for the Web.
By default, personal forms created directly on the Microsoft Forms website are designed to export data as an offline downloaded Excel workbook. This is expected behavior. To enable live browser viewing, the form must be associated with a Microsoft 365 Group.
Navigate to the Microsoft Forms web interface and locate the form you want to modify under 'My forms'.
Click on the three dots (More form options) on the top right corner of the form card and select 'Move to a group'.
Select the appropriate Microsoft 365 group you want to transfer the form to, then confirm the move.
Go to the 'Responses' tab of the moved form and click 'Open in Excel'. The data will now open in a new browser tab instead of downloading.
Easily View and Analyze Downloaded Form Responses with WPS Office
If you prefer keeping your Microsoft Forms personal and working with downloaded offline workbooks, WPS Office provides a lightweight, entirely free solution to open, analyze, and chart your Excel response data seamlessly.
- 1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on your computer.
- 2. Locate Your Exported Data: Find the offline Excel workbook that was downloaded when you clicked 'Open in Excel' in Microsoft Forms.
- 3. Open and Analyze: Double-click the file or right-click to 'Open with WPS Office' to view your survey responses, apply filters, and build visual charts instantly.
Frequently Asked Questions
Can I make a personal form open responses in the browser without moving it to a group?
No, forms created under 'My forms' in Microsoft Forms for the web are designed to download offline Excel workbooks by default. To get browser viewing, it must be moved to a Microsoft 365 group or initially created from OneDrive for Business or Excel for the web.
Will my offline Excel workbook update automatically when new responses arrive?
No. A downloaded offline Excel workbook is a static snapshot of the data at the exact moment you exported it. You will need to download a new copy to see any subsequent responses.
How do I create a form that automatically opens in Excel for the web from the start?
Instead of starting at the main Microsoft Forms website, begin in OneDrive for Business or Excel for the web. Click 'New' and select 'Forms for Excel' to ensure the responses are continuously synced to an online workbook.
