Data Import & Export

Fix Microsoft Forms Quiz Results Missing Points in Excel

Phi Hung Vo Sep 28, 2026 869 views

Question details

Users are experiencing missing total points and per-question scores when opening or downloading Microsoft Forms quiz results in Excel.

Fix Microsoft Forms Quiz Results Missing Points in Excel

Product: Microsoft Forms and Microsoft Excel
Device & OS: not provided
Scenario: Exporting or downloading completed quiz results from Microsoft Forms into an Excel workbook for analysis.
Observed behavior: The generated Excel workbook is missing the columns or data corresponding to total points and individual question scores.

Before you start

Verify that your internet connection is stable and try refreshing the Microsoft Forms page before attempting to download the Excel file again.

Solution 1Recommended

Wait for Microsoft 365 Service Recovery and Re-download

This issue is most frequently caused by a temporary Microsoft 365 server-side problem affecting the Excel export feature.

Many users have reported this behavior as a known server-side glitch within Microsoft 365. When Microsoft experiences temporary service degradation, the Excel export function may fail to fetch specific data points, resulting in blank score columns.

In most cases, the issue resolves itself automatically within a few hours to a day once Microsoft's services are fully restored.

Check service status

Log in to your Microsoft 365 admin portal to check for any active service health alerts regarding Microsoft Forms or Excel Online.

Wait for resolution

Allow some time for the temporary server issues to be resolved, typically 12 to 24 hours.

Re-download the file

Go back to your Microsoft Forms quiz, navigate to the 'Responses' tab, and click the 'Open in Excel' button to generate a fresh file. The points should now appear correctly.

Wait for Microsoft 365 Service Recovery and Re-download

Data Integrity: Your actual quiz scores are safe within Microsoft Forms. The issue only affects the data being transferred during the export process.

Solution 2

Contact Your Microsoft 365 Administrator

If the export issue persists for multiple days, your organization's IT admin will need to escalate it by opening a service request with Microsoft Support.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If you are tired of unexpected Microsoft Office glitches or simply want a more lightweight, cost-effective solution, WPS Office is an excellent alternative. It offers powerful spreadsheet tools to manage and analyze your exported quiz data without the hefty subscription fees.

1. Download WPS Office: Visit the official WPS Office website and click the 'Free Download' button.
2. Install the software: Run the downloaded installer and follow the quick on-screen instructions to set up WPS Office on your computer.
3. Analyze your data: Launch WPS Spreadsheet and open your downloaded Forms results (.xlsx) to view and manage your data flawlessly.

Fully compatible with Microsoft Excel (.xlsx, .xls) and CSV formats.Free and lightweight alternative to Microsoft 365.Familiar user interface for a seamless transition and zero learning curve.Robust data analysis tools to manage quiz scores and forms data effectively.

microsoft office alternative - wps office

Frequently Asked Questions

Why are my Microsoft Forms quiz points completely blank in the exported Excel file?

This is typically caused by a known server-side glitch in Microsoft 365 where the export engine fails to fetch the point values from Forms. It is usually a temporary issue that resolves when Microsoft restores full service operations.

Can I manually recover the missing scores from the current Excel file?

Unfortunately, if the Excel file was generated during a server issue, the data for those points simply isn't contained in the file. You will need to wait for the servers to stabilize and click 'Open in Excel' again to generate a correct file.

Does this export issue mean the actual scores were not saved in Microsoft Forms?

No, your quiz scores are securely saved and correctly calculated within Microsoft Forms itself. The issue strictly affects how the data is transferred and formatted when generating the Excel workbook.

Excel & Data Problems