'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to View Microsoft Forms Survey Results Online Without Downloading Excel
Question details
The user needs a way to view live or updated Microsoft Forms survey results online instead of repeatedly downloading local Excel files.
- Product
- Microsoft Forms
- Device & OS
- not provided
- Scenario
- Monitoring ongoing survey or quiz responses where data updates frequently.
- Observed behavior
- Microsoft Forms defaults to downloading a static, offline Excel workbook for detailed results, forcing the user to repeatedly download new files to see updated data.
Ensure you are logged into the Microsoft account associated with your forms and that you have sufficient OneDrive storage space to host the survey data workbook.
Use OneDrive and Excel for the Web for Live Viewing
By syncing your Microsoft Forms data to an Excel workbook hosted on OneDrive, you can view real-time updates directly in your browser without downloading files.
Microsoft Forms does not provide a built-in live spreadsheet viewer natively on its dashboard. To see your continually updating data without downloading a new file every time, you need to rely on Excel for the web combined with OneDrive.
Navigate to the Microsoft Forms dashboard, open your specific survey or quiz, and click on the 'Responses' tab at the top of the page.
Click the 'Open in Excel' button. If the form was created in a OneDrive or SharePoint group, it will automatically open a live-syncing workbook in Excel for the web.
If clicking the button forces a local file download, log in to your Microsoft OneDrive account, click 'Upload', and upload the downloaded Excel file to your cloud storage.
Open the uploaded workbook in OneDrive using Excel for the web. To allow others to view the updated survey data, click the 'Share' button in the top right corner and grant them 'view-only' permissions.
Analyze Downloaded Survey Data Effortlessly with WPS Office
If you prefer analyzing your exported Microsoft Forms survey results offline, or simply want a faster, more resource-friendly office suite, WPS Office is an excellent free alternative. It easily handles complex data analysis, offers a highly familiar interface, and provides excellent compatibility with all your spreadsheet files.
- 1. Download and Install: Download WPS Office for free from the official website and install it on your device.
- 2. Open Your Survey Data: Launch WPS Spreadsheets, click on 'Open', and select the Excel file downloaded from Microsoft Forms.
- 3. Analyze and Share: Use WPS Office's powerful charting, filtering, and pivot table features to analyze your survey data effortlessly.
Frequently Asked Questions
Can I share my live Microsoft Forms responses with people outside my organization?
Yes. By syncing the results to Excel for the web via OneDrive, you can generate a 'view-only' sharing link. Anyone with this link can monitor the updated survey data online without needing a Microsoft account.
Why does my Microsoft Form only offer a downloaded Excel file?
This typically happens if the form was created as a personal form directly on the Microsoft Forms website rather than from within a SharePoint group or OneDrive. To establish a live connection, you can move the form to a Group.
Will the OneDrive Excel file automatically update when new survey responses come in?
Yes, if the form was created through OneDrive, Excel Online, or SharePoint, the connected Excel for the web file updates automatically in real-time as new responses are submitted.
