Recently, I had a chance to use Microsoft Lists at work. Needless to say, I was curious to learn more and how to import data into the platform.

April Dunnam shows us how to use Microsoft Forms data in Microsoft Lists.

Microsoft Forms is a great tool for creating simple input forms for scenarios such as surveys, sign ups, and quizzes. In this video you’ll learn how you can take your Microsoft Forms data and put it in Microsoft Lists for easy collaboration, automation and reporting.

I’ll show how you can leverage Power Automate to take new forms responses and add them to your Microsoft Lists, as well as how you can take existing forms responses and add those to your list.

Leila Gharani shows us how to use Microsoft Forms you can collect data from different people via fillable forms that you can control from Excel.

With Microsoft Forms you can easily create surveys, quizzes and polls. You can export the data to Excel to analyze and share the results with your audience. No programming is necessary, no VBA, no add-ons. Just a Microsoft 365 account (free or paid).

We’ll cover how you can use Microsoft forms to add dropdowns, multiple choice, calendar date selection, number checks, net promoter score, and even star ratings.

Time Stamps

  • 00:00 How to Use Microsoft Forms
  • 01:19 How to Get Started with Microsoft Forms
  • 01:50 Automatic Connection between Excel and Microsoft Forms
  • 02:58 Create Data Entry Form with Microsoft Forms
  • 04:10 Star rating in Microsoft Forms
  • 04:35 Choice in Microsoft Forms
  • 05:08 How to add a drop-down to Microsoft Forms
  • 06:10 Date picker with calendar pop-up
  • 06:30 Add a text box and validate numbers
  • 06:50 Add a Likert scale to Microsoft Forms
  • 07:15 Net Promoter score in Microsoft Forms
  • 07:50 How to Add a Theme to Microsoft Forms
  • 08:09 How to Share a Data Entry Form with Microsoft Forms
  • 09:24 How to Fill Out a Data Entry Form
  • 10:34 Analyze the Responses from Microsoft Forms in Excel
  • 13:39 Grid