Forms data sync to Excel is now fully available with more functionality

Excel

Forms data sync to Excel is now fully available with more functionality

https://techcommunity.microsoft.com/blog/microsoftformsblog/forms-data-sync-to-excel-is-now-fully-available-with-more-functionality/4177152

We’ve been gradually rolling out Forms data sync to Excel since early this year. During this process, we actively collected user feedback and iterated to enhance the feature for various use cases. I’m excited to announce that this feature is now fully available for all customers, complete with additional capabilities. Let’s explore these updates together. You can also try it from this template.

Create from Excel for the web

If you prefer to keep all your data in Excel and are used to starting your data collection journey there, you can now create a form directly from Excel for the web – no need to visit Forms. Simply click “Insert” 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 responses you receive will automatically sync to Excel.

Create from Excel for the webCreate from Excel for the web

Create from worksheets in OneDrive and SharePoint

The “create from Excel” experience supports worksheets saved in OneDrive and SharePoint. Depending on your needs, you can choose where to start. For personal forms that you want the answers accessible only to yourself, start from OneDrive. For collaborative forms involving your team, start from SharePoint to ensure all team members stay updated.

Start from Excel saved in OneDriveStart from Excel saved in OneDrive

New data sync experience for group form

We’ve also updated the group form data sync experience to be smoother and more stable for greater reliability. For forms where you need all team members to easily check responses, you can create a group form in Forms. As new responses come in, everyone on the team can see them sync to Excel. The Excel worksheet for the group form will be saved in SharePoint.

Create a group form in FormsCreate a group form in Forms

Share the Excel link to collaborate on up-to-date data

If you want your coworkers to check the new responses and do some further analysis, you need to share the Excel link. When they open it, responses will automatically sync whenever responses are received. (Please note that Forms collaborators don’t have access to the syncing Excel sheets from response page – you must share the Excel link.)

Share the Excel link with othersShare the Excel link with others

We are currently rolling out to commercial customers and expect to be fully deployed to commercial by mid-July. We’ll also start rolling out to Microsoft account holders in the near future.

Excel consulting ; Excel Consulting – Consultoria em Excel e Office 365

Partilhar:

Mais publicações

Excel

Announcing Clean Data with Copilot in Excel

We’re thrilled to introduce a new AI-powered feature in Excel – Clean Data. With Copilot in Excel, you can clean data with just one click. Clean Data detects and offers solutions for text inconsistencies, number format issues, and extra spaces. This feature is now available to Excel for the web users and will be rolling out to Windows desktop users in the coming months.

First Excel

Excel just entered its 40th year

More senior than Windows itself, and still runs the world

Microsoft Excel, the true successor to the throne of COBOL. Version 1.0 was released on the last day of September 1985, four decades ago.

Since the original US English version of Windows 1.0 went to manufacturing at the end of November that year, this means that the default spreadsheet for Microsoft Windows is itself older than Windows. (The European version of Windows didn’t appear until May 1986, but that doesn’t really matter, nobody cared about it either.)

© 2024 Created by wpexperts.pt