Does MS Forms Show Submit Time? Does Submission Time Matter?

By Grace

When managing online forms, tracking the time of submission can be crucial for various reasons, such as understanding user engagement, identifying performance issues, or complying with regulatory requirements. Microsoft Forms, as a popular tool for creating surveys and quizzes, offers a range of features, but the question remains: does Microsoft Forms show the time of submission?

Create forms faster and more professionally | What’s new in June-July 2019 in Microsoft Forms
Create forms faster and more professionally | What’s new in June-July 2019 in Microsoft Forms

In a nutshell, Microsoft Forms does indeed record and allow you to view the submission timestamps. However, this feature is not prominently displayed and requires a bit of navigation to access. Let's delve into how to find and use this information.

How to Use Microsoft Forms to Create Professional Surveys
How to Use Microsoft Forms to Create Professional Surveys

Microsoft Forms and Submission Timestamps: An Overview

Microsoft Forms stores a wealth of data about each response to your forms, including the submission timestamp. This data is available even with the free version of Microsoft Forms, making it accessible to all users.

Tips for using Microsoft Forms
Tips for using Microsoft Forms

However, Microsoft Forms does not display the timestamps directly in the responses view. Instead, you'll need to dig a little deeper to access this information.

Accessing Submission Timestamps in Microsoft Forms

How to Sync Microsoft Forms Responses to Excel
How to Sync Microsoft Forms Responses to Excel

To view the submission timestamps in Microsoft Forms, you'll need to use the 'download results' feature. This allows you to export your responses as an Excel spreadsheet, where you can easily access the timestamps.

Here's a step-by-step guide on how to do this:

  1. Open the Microsoft Form you want to access the submission timestamps for.
  2. Click on 'Manage' in the top right-hand corner of the page.
  3. Scroll down and click on 'Export results'.
  4. Choose either 'New Excel workbook' or 'New Excel workbook (with headings)' to download the results.
Capture data in Microsoft Forms to create a new template agreement in SharePoint
Capture data in Microsoft Forms to create a new template agreement in SharePoint

Reading the Timestamp in the Exported File

Once you've exported your results to an Excel file, you can easily find the timestamps. By default, Microsoft Forms includes a 'Submitted Date' column in the exported file, making it easy to see when each response was submitted.

The 'Submitted Date' column contains timestamps in the 'mm/dd/yyyy hh:mm AM/PM' format. For instance, you might see something like '03/15/2022 04:30 PM', indicating that the response was submitted on March 15, 2022, at 4:30 PM.

Quick tips in Microsoft Forms for Education
Quick tips in Microsoft Forms for Education

Additional Features for Tracking Form Submissions

While Microsoft Forms does provide submission timestamps, it's worth noting that other platforms might offer more advanced features for tracking form submissions. For example, some tools allow you to set up real-time notifications whenever a form is submitted, or even automatically send out follow-up emails to respondents.

Saving data from Microsoft Forms into Excel using Power Automate (Flow)
Saving data from Microsoft Forms into Excel using Power Automate (Flow)
How to Create a Survey Using Microsoft Forms
How to Create a Survey Using Microsoft Forms
How to Close the Survey in Microsoft Forms
How to Close the Survey in Microsoft Forms
Microsoft Forms Template Gallery Explained
Microsoft Forms Template Gallery Explained
What are Microsoft Forms?
What are Microsoft Forms?
the microsoft forms guide is shown in front of a green background with yellow and blue letters
the microsoft forms guide is shown in front of a green background with yellow and blue letters
Use Microsoft Forms to collect data right into your Excel file
Use Microsoft Forms to collect data right into your Excel file
Top 25 Microsoft Forms tips and tricks
Top 25 Microsoft Forms tips and tricks
How to Do Branching in Forms
How to Do Branching in Forms

Furthermore, if you're using Microsoft Forms for business purposes, you might want to consider upgrading to Microsoft Forms for Teams or Microsoft Forms for Education, both of which offer additional features and analytics tools.

In conclusion, while Microsoft Forms might not prominently display submission timestamps, they are available and can be accessed via the 'download results' feature. Whether you're using Microsoft Forms for personal or business purposes, being able to see when responses were submitted can provide valuable insights and help you make the most of your forms data.