Fix Microsoft Forms Responses Missing Start and Completion Times in Excel
Question details
Users need to resolve an issue where start and completion timestamps are missing from Microsoft Forms data when exported to 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.
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.
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.
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'.
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.
Send the screenshots and a brief description of the issue to your organization's IT administrator.
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.

Use Power Automate to Record Submission Times
Create a Power Automate flow as an alternative method to automatically capture response times directly into an Excel table when the native export fails.
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. Download your data: Export and download your response data from Microsoft Forms as an .xlsx file.
- 2. Open in WPS Spreadsheet: Launch WPS Office, click on 'Spreadsheet', and open your downloaded file.
- 3. Analyze responses: Use built-in sorting, filtering, and pivot tables to review your form submissions quickly.

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.




