The integration between Microsoft Forms and Excel is very poor. It’s almost as if the Forms and Excel developers haven’t worked together, even though they work for the same company! Just a few things you’d expect from a proper integration of a Microsoft product with Microsoft Excel and Power, and query.
We know about Microsoft Forms, the Office 365 quiz and polls tool. We know this can be easily exported to Excel. However, if you have an existing Excel file, you can use Forms to import directly into your existing Excel file! I find this as a big deal.
Wherein we can utilize the Microsoft forms to search for a particular set of data from an excel document and present it. Loading I don’t believe that’s possible (havent looked in a couple of months). Forms is purely intake, for surveys, etc.
What is forms for Excel and how to use it?
@Ivan Unger, Forms for Excel is the new experience for legacy Excel survey. As @Steven Collier has mentioned, it is just Microsoft Forms, but when you create the form, it connects to an Excel workbook on your One. Drive for Business / Share. Point Online by default.
One article stated that you can easily view all of the response data for your form in Microsoft Excel. Select Open in Excel on the Responses tab to capture a snapshot of your current response data in a workbook.
What can you do with Microsoft forms?
With Microsoft Forms you can create a form, such as a survey or quiz, invite others to respond to it using almost any web browser or mobile device, see real-time results as they’re submitted, use built-in analytics to evaluate responses, and export results to Excel for additional analysis or grading.
Microsoft Forms has a rich user interface and real-time analytics to display summary details and individual results from surveys. You can export responses data to Microsoft Excel for further analysis. It has features to delete the responses and print the summary of the form.
Microsoft Forms can be customized and embedded on any other web page or blogger website. Microsoft Forms can be shared with anonymous users to collect data . Results can be shared. It has features to modify and delete forms data easily. It allows duplicate forms to be created using an existing one as a template.
Microsoft Forms includes rich, real-time analytics that provide response summary information and individual results for surveys and other types of forms. You can export the results to Microsoft Excel for more in-depth analysis, as well as delete or print a summary of responses.
How does Smartsheet integrate with Microsoft Office 365?
Smartsheet easily connects with Microsoft Office 365 to streamline work processes. Connect Smartsheet with the Microsoft Office 365 tools your teams use to get work done, so they can be even more productive. Smartsheet seamlessly integrates with Microsoft Office 365.
Smartsheet and Microsoft reduces complexity and helps our joint customers work smarter. Transform conversations into action with Microsoft Teams and Smartsheet.
From Microsoft Teams, in the search bar at the top of the Teams window, type “Smartsheet” and select the Smartsheet app. NOTE: To be able to use the Smartsheet for Microsoft Teams integration, you may need to submit a request to your Office 365 Admin to enable the bot with the steps in this Microsoft Help Article.
How does the IM integration work in Smartsheet?
Smartsheet users can initiate secure conversations with team members directly from Smartsheet through instant messaging (IM). The integration enables IM chat conversations to be saved directly to Smartsheet as a series of comments so conversations about the status of tasks or projects can be retained and searched.