In January, Microsoft announced that it began adding support for syncing data collected from Forms tests and surveys to Excel for the web. This week, Microsoft revealed that it’s not only making this new feature generally available, but also adding some new functionality.

in a blog post, Microsoft says Excel web users can now create their own forms right in the app, without having to use the Forms app. He states:

Just click “Add” and select “Forms” in the ribbon. This will open a new form in Forms where you can add questions. All the questions you add and the answers you receive will be automatically synchronized to Excel.

This new feature also works if you want to save your Excel worksheets to your OneDrive or SharePoint account. Microsoft says saving worksheets to OneDrive is best if you want to keep the answers you get from Forms surveys private. Saving them in SharePoint is best if you want to share these answers with your teammates.

Speaking of checking form responses by other team members, Microsoft also supports creating group forms in Forms. It means:

When new responses come in, everyone on the team can see them syncing with Excel. The Excel worksheet for the group form will be saved to SharePoint.

Finally, you can share the link to the Excel spreadsheet with other employees or team members so they can analyze the answers to the form questions. When you share the link and they open the Excel file through the link, all responses to the form surveys will be automatically synced as new responses are received.

Microsoft says its commercial customers should see a full rollout of Forms data synchronization with Excel by mid-July. It is also working on adding support for Microsoft account users in the near future.