How to get missing data in Forms

How to get missing data in Forms

If you create your form in OneDrive for Business, SharePoint Online, Excel Online, Microsoft Teams, or using the Microsoft Forms web part, you can click Open in Excel to get an Excel workbook that is automatically stored on OneDrive for Business or SharePoint Online. This workbook contains a live data connection to your form, and any new response data in your form will be reflected in your workbook.

Get a new workbook with up-to-date data

In the event your live data connection is lost, you can still retrieve your most recent response data and sync it to a new workbook.

Note: This feature is only available for Office 365 Education and Office 365 Commercial users. To retrieve your most recent response data and sync it to a new workbook, please sign in with your work or school account.

  1. On the Responses tab, click More options More options button

  2. Click Sync all responses to a new workbook.

    Sync all responses to a new workbook option in Microsoft Forms

A new workbook will open in Excel with your most up-to-date responses. This new workbook will be stored next to your original workbook on OneDrive for Business or SharePoint Online.

How do I know if there's a live data connection between my form and workbook?

If you created your form in Forms on the Web (https://forms.office.com) and click on Open in Excel, an offline Excel workbook will open that has no relationship or connection to your form. Since this form has no live data connection, you won't see the Sync all responses to a new workbook option.

If you created your form in OneDrive for Business, SharePoint Online, Excel Online, Microsoft Teams, or using the Microsoft Forms web part, your Excel workbook contains a live data connection to your form. Any new response data in your form will be reflected in your workbook and you'll see the Sync all responses to a new workbook option.

Got feedback on Microsoft Forms?

We'd love to hear from you! Please visit the Microsoft Forms User Voice site to provide suggestions and vote on ideas others have already submitted.

See Also

Create a form with Microsoft Forms

Check your form results

Frequently asked questions about Microsoft Forms

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×