'%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 Fix Microsoft Forms Total Points Missing in Excel Reports
Question details
The 'Total Points' column is missing when viewing Microsoft Forms quiz reports in Excel for the web.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Exporting or opening quiz responses from a Microsoft Form into Excel for data analysis and grading.
- Observed behavior
- The Excel web report omits the Total Points column and individual question scores, particularly for forms belonging to a SharePoint group.
Ensure you have access to the original Microsoft Form in your 'My Forms' dashboard, and check if the form was recently moved to a group, as moving forms often breaks the live data connection.
Download a New Offline Excel Report
Downloading the report directly to your local device bypasses the web-based Excel limitations and restores the missing points column.
Log in to Microsoft Forms and navigate to the 'My Forms' dashboard. Click on the specific quiz or form you want to analyze.
At the top of the form editing page, click on the 'Responses' tab to view the summary of collected data.
Click the 'Open in Excel' button to download a fresh, offline copy of the report. Open the downloaded file on your desktop, and the Total Points column will be fully visible.
Use Formulas to Retrieve Data in Web Reports
If you must use the live web-based report, you can manually pull the required data into a new sheet using formulas.
Analyze Form Data Seamlessly with WPS Office
If you frequently encounter sync issues, missing data, or limitations with web-based spreadsheet tools, try WPS Office. It provides a robust, lightweight desktop environment to analyze downloaded CSV or Excel form responses without missing columns or broken web links.
- 1. Download your form data: Export your quiz or survey responses as an offline Excel file directly from Microsoft Forms.
- 2. Open with WPS Spreadsheets: Launch WPS Office and open the downloaded .xlsx file.
- 3. Analyze without limitations: View, sort, and analyze your quiz scores and total points seamlessly with full data visibility and zero web-sync errors.
Frequently Asked Questions
Why does Excel for the Web hide total points?
Excel for the Web may omit question points and total scores for forms hosted in a SharePoint group, or if the direct connection has been interrupted by moving the form from an individual OneDrive to a group.
How do I fix a broken Forms-to-Excel connection?
If moving the form broke the sync, you generally cannot re-establish the live web link for existing reports. You must download a new offline Excel report from the 'Responses' tab to access the complete data.
Are total points permanently lost if they do not show up in the web view?
No, the points are still securely recorded by Microsoft Forms. You can easily access them at any time by downloading the raw Excel file directly from your 'My Forms' dashboard to your local device.
