Others

Fix Missing Responses and Dates in Microsoft Forms

Maira Mehtab Sep 22, 2026 869 views

Question details

The user is unable to see complete text responses and submission dates for recent entries when viewing Microsoft Forms results online.

Product: Microsoft Forms
Device & OS: not provided
Scenario: Reviewing recently submitted form responses and checking timestamps in the online portal.
Observed behavior: Text in the response cells is truncated and not fully visible until expanded, and newer form submissions are missing their date stamps compared to earlier ones.

Before you start

Ensure you are logged into the Microsoft account that has ownership or editing permissions for the form in question so you can access the full response data.

Solution 1Recommended

Export Responses to Excel for Full Visibility

By exporting the form data to a spreadsheet, you bypass the online preview's display limitations and can view all complete responses and timestamps.

The online preview in Microsoft Forms can sometimes fail to display lengthy text responses or recent timestamp metadata due to interface limitations. All data is still securely recorded in the background.

To access the missing information, you need to download the raw data into a spreadsheet program where column widths can be manually expanded.

Open the form

Log into Microsoft Forms and open the specific form that contains the missing responses or dates.

Navigate to responses

Click on the 'Responses' tab located at the top of the form editing page to view the summary.

Export to Excel

Click the 'Open in Excel' button. This will download a complete spreadsheet containing every submission, including hidden text and precise start and completion times.

Expand cells to view data

Open the downloaded file in your spreadsheet software. Select the columns containing the responses and dates, and double-click the column boundary to expand the width so all text becomes fully visible.

Report Display Issues: If the online preview is consistently missing expected information, click the feedback option in Microsoft Forms to report the bug directly to Microsoft's development team.

Free Microsoft Office alternative

Analyze Microsoft Forms Data Easily with WPS Office

After exporting your Microsoft Forms responses, you need a reliable spreadsheet tool to view and analyze the data. WPS Office is a free, lightweight alternative that effortlessly opens Microsoft Excel files, allowing you to expand cells and read every response without formatting issues.

1. Download and install: Download WPS Office for free and install it on your computer.
2. Open the exported file: Launch WPS Spreadsheet and open the .xlsx file you downloaded from Microsoft Forms.
3. Adjust column widths: Highlight the columns with missing data and use the 'AutoFit Column Width' feature to instantly reveal all text and timestamps.

Fully compatible with Microsoft Excel (.xlsx) formats exported from Microsoft Forms.Easily expand rows and columns to read lengthy text responses.Lightweight and fast, handling large datasets without lag.Free to use with a familiar, easy-to-navigate interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the text cut off in my Microsoft Forms responses?

The built-in web preview for Microsoft Forms has character limits for its display cells. To read long answers in their entirety, you must export the responses to a spreadsheet application and widen the columns.

Are the missing dates in Microsoft Forms lost permanently?

No. Even if the web interface fails to display timestamps for recent submissions, Microsoft Forms still captures the start and completion times. You can retrieve these dates by clicking 'Open in Excel' and viewing the raw data.

Can I fix the Microsoft Forms online preview without exporting?

Currently, there is no direct setting to fix the web interface layout if it hides data. Exporting to a spreadsheet is the official workaround. You can submit a bug report via the Microsoft Forms feedback button to encourage a permanent fix.

Office Quick Solutions