Creating a persistent Microsoft Forms response spreadsheet

If you use Microsoft Forms, you know that in order to see the responses you need to export them to Excel. However, having to export them *every single time* you want to see the responses can be a pain point. Did you know you can pre-create the Microsoft Forms response spreadsheet in OneDrive, and then you simply have to open it to see the most up-to-date responses to your Form? Here’s how that works…

Splitting up the Collect Responses and Collaboration options in Microsoft Forms

When Microsoft Forms first came out, there was a single button that had the options for both collecting responses from people and for letting others collaborate on building your form. Unfortunately, this often led to people getting links to collaborate when in reality they should have only been able to respond. Now, Microsoft has split those two options out to clarify the options. Here’s what that looks like…

Word Clouds in Microsoft Forms

Microsoft Forms is a great tool for getting feedback on a various topic. However, if you’re using open text questions, you may find it difficult to get a quick read on basic trends and key words that are appearing in the responses. That’s a bit easier now using the Word Cloud Insights feature. Here’s how that works…

Using the URL shortener for Microsoft Forms URLs

Microsoft Forms is a great tool for data collection, but one thing that has been pretty ugly are the URLs that are generated for sharing those Forms. Microsoft listened to user feedback, and they provided a built-in way to shorten the Forms URL into something that doesn’t cause headaches. Here’s how it works…