Others

Fix Microsoft Forms Responses Missing Start and Completion Times in Excel

John WilsonJohn Wilson Nov 2, 2026 869 views

Question details

Users need to resolve an issue where start and completion timestamps are missing from Microsoft Forms data when exported to Excel.

How to Fix Microsoft Forms Responses Missing Start and Completion Times in Excel
Product
Microsoft Forms
Device & OS
not provided
Scenario
Exporting collected form responses to an Excel workbook for data analysis and tracking.
Observed behavior
The start and completion time columns in the exported Excel spreadsheet are completely blank. This issue persists across different browsers, affects newly created forms, and impacts multiple users within the organization.
Before you start

Verify that you have creator or co-author permissions for the affected form and ensure that your organization's Microsoft 365 subscription is currently active.

Solution 1Recommended

Compare Form Settings and Escalate to IT Administrator

Because this issue often impacts multiple users and persists across browsers, it typically indicates a tenant-level synchronization glitch that requires an IT administrator to resolve.

When basic troubleshooting (like clearing browser cache or creating a new form) fails to restore the missing time data, the root cause is usually located at the Microsoft 365 tenant level. Only individuals with administrative access to the Microsoft 365 admin center can raise the necessary support tickets with Microsoft to fix tenant-wide export failures.

1
Open form settings

Navigate to Microsoft Forms, open the affected form, and click the three-dot icon (More form settings) in the top-right corner, then select 'Settings'.

2
Capture screenshots for comparison

Take a screenshot of these settings. If possible, compare them with the settings of an older form where the start and completion times are exporting correctly.

3
Contact your IT department

Send the screenshots and a brief description of the issue to your organization's IT administrator.

4
Request a Microsoft 365 support ticket

Ask the administrator to log into the Microsoft 365 admin center and create a formal support request under the 'Support' section to investigate the tenant-level forms syncing issue.

Compare Form Settings and Escalate to IT Administrator
Past data recovery: Microsoft Support may be able to force a back-end sync, but in some cases, timestamps that failed to record at the time of submission cannot be retroactively recovered.
Free Microsoft Office alternative

Analyze Exported Form Data Seamlessly with WPS Office

While resolving Microsoft Forms syncing issues requires Microsoft 365 admin support, analyzing the resulting data doesn't have to tie you to expensive software. WPS Office provides a robust, lightweight, and free alternative to easily manage, filter, and edit your exported Excel (.xlsx) response files.

  1. 1. Download your data: Export and download your response data from Microsoft Forms as an .xlsx file.
  2. 2. Open in WPS Spreadsheet: Launch WPS Office, click on 'Spreadsheet', and open your downloaded file.
  3. 3. Analyze responses: Use built-in sorting, filtering, and pivot tables to review your form submissions quickly.
100% compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsLightweight architecture ensures large data files open almost instantlyIncludes comprehensive data analysis tools, pivot tables, and charting featuresFamiliar tabbed interface allows for an effortless transition from Microsoft Office
microsoft office alternative - wps office

Frequently Asked Questions

Why are start and completion times missing from my downloaded Excel file?

This usually happens due to a data synchronization bug at the tenant level within Microsoft 365, particularly if the issue is occurring across multiple different forms and affecting several users within the same organization.

Can I manually find the completion time for individual responses?

Yes. If you go to the 'Responses' tab in Microsoft Forms and click 'View results', you may be able to see the time taken to complete the form for individual respondents, even if it fails to export properly.

Will clearing my browser cache fix the missing timestamps?

Generally, no. If the timestamps are completely absent from the exported Excel file, it is a server-side data compilation error rather than a local browser caching issue.

Does this issue happen with anonymously submitted forms?

Yes, start and completion times can disappear from both anonymous forms and those requiring internal organizational logins when a tenant-wide export issue occurs.