Microsoft Forms - Simply Explained

0:00 Microsoft Forms is the survey and quiz builder you already own. Welcome to the M365 FM podcast, where we explore the people, ideas and technologies shaping the future of work. It turns a blank page into a survey, a poll, or a quiz right in your browser. And you don't need a developer or a data team that matters, because chasing answers by hand is slow and the numbers go stale fast. After someone hits submit, the answers drop into a spreadsheet that keeps itself current, and a flow can run the follow up on its own. By the end, you'll see why a simple form is really the front door to an automated process the tool you already own. Let's start with the plain version, because the name makes it sound bigger than it is. Microsoft Forms is a web tool for building surveys, polls, and quizzes, and it runs in any browser.

0:41 On any device. You open it, you add your questions, and you send out a link. There's nothing to install, which comes as a relief. If you were expecting a download and a setup wizard, you'll find it at forms office dot com or by signing into Office Comm and clicking the forms icon. It lives inside a Microsoft three hundred sixty five work or school account, and it also works with a free Microsoft account like Hotmail or Outlook. Com so there's a good chance you already have it. The tool is small on purpose too. There's no dashboard to learn, no settings tree to get lost in, and no add on to buy. You sign in, you see your forms, and you start one. Two words get used as if they mean the same thing. So let's pull them apart. A survey collects opinions or information, like asking a team how a project went. A quiz checks whether someone knows something like testing a new hire on the security rules.

1:25 It's the same builder doing a different job. People reach for forms for ordinary things like gathering feedback after a workshop, signing people up for an event, or running a quick poll in a meeting. None of that needs an IT department, and none of it needs a budget line. Keep one idea from this section in mind for later, because it changes how you see everything that follows. You might think this is a survey tool and it's really a pipe for answers. Forms is the starting point of a bigger process, since the answers it collects can flow straight into Excel. Teams and Power Automate without anyone retyping a thing. Building your first form. Starting a form takes about a minute, and the first thing you do is give it a title. That title sits at the top of every screen and it's capped at ninety characters, so keep it short and clear. Then you add questions and the real choice lives in the question type because the type decides what the answer box looks like.

2:11 You also decide how each question behaves, since a choice question can allow one answer or several, and it can carry as many as two hundred options, which is more than most people will ever need. A choice question is the one you filled in one hundred times where you pick one option or several from a list? Text questions give people a box to write in either a single short line or a longer paragraph for open feedback. When you want a quick score, the rating question shows a row of stars, up to ten of them, and the date question opens a little calendar for scheduling ranking questions. Let people drag items into the order they prefer. For opinion surveys, the Likert question lines up several statements against one shared scale, like agree through disagree. So you can ask five things without writing five separate questions.

2:54 The Net Promoter score question is the famous zero to ten question that asks how likely someone is to recommend you, and it labels both ends for you. If you need documents, a file upload question lets people attach a file which then lands in your OneDrive or SharePoint. And the section isn't a question at all, because it's a divider that splits a long form into separate pages. That list sounds heavy, so take the shortcut with it. Choice and text cover most forms, and you only reach for the rest when the question actually calls for them. Two small touches make a form feel finished. You can shuffle the answer options so the order doesn't nudge people toward the first choice, and a theme makes the form match your team instead of looking like a default template. If your questions already live in a word document, some types can be imported instead of retyped.

3:36 When a survey becomes a quiz, a quiz looks exactly like a survey while you're building it. And then one setting changes everything. Switch on quiz mode and now you can mark which answers are correct. Assign points and let forms grade the whole thing for you. Think about what that unlocks. A teacher can turn a review sheet into a quiz that scores itself. A manager can build an onboarding check that proves a new hire. Read the policy. A trainer can drop in a short knowledge test at the end of a session and get the results without marking a single paper. You can attach feedback to each answer so someone who gets a question wrong learns why before they move on the scores and the individual answers show up in the same results view you use for surveys. And you can share a summary link so a colleague can see how the whole group did without opening each response.

4:16 That means you learn one tool instead of two, and you keep everything in one place. If you're running training, this replaces a paid quiz tool and a separate grading step. The same link you'd send for a survey works for a quiz, and the answers land in the same place. So there's nothing new to learn. A quiz can branch as well, which is the feature we're walking into next, so a strong student can skip ahead while everyone else gets more practice. This part catches people off guard because quiz software usually costs money in forms. It's a toggle inside a tool you already have branching the form that rewrites itself. Branching is the feature that makes a form feel smart, and it's easier than the word suggests. Branching means the form shows different questions depending on the answer someone gives, so nobody has to read a question that doesn't apply to them.

4:58 Picture an onboarding form that asks one simple thing whether the new hire needs a company phone. If they answer yes, the form walks them through the phone details. If they answer no, the form skips those questions completely and moves them along. It's the same form serving two different paths, and each person only sees what's relevant to them. You can add branching to a single question or to a whole section. When your form is split into pages, a section is just a page. So branching on a section means someone can skip an entire page of questions in one move. If you've ever clicked through a form that felt like it was reading your mind, this is usually the trick behind it. There's one rule that trips up almost everyone, and it's worth saying twice. Branching only moves forward. A question can send someone to a later question or to the end of the form, and it can never send them backward.

5:41 If you try to branch to a question that sits earlier in the form, you'll break the whole experience because the form will jump that person straight to the submit button and skip everything in between. Keep your branches pointing forward and the form behaves the way you expect. The effort pays for itself because a short form that only asks what's relevant gets finished, and a long form full of questions that don't apply gets abandoned halfway. Branching is how you make one form. Serve several kinds of people without asking anyone to wade through the rest. You can also reset branching in one click if you change your mind. So there's no risk in experimenting while you build all that extra. Branching is how forms grow. Large and large forms run into a hard ceiling. Keep that in mind, because we'll come back to it when we talk about limits.

6:22 Collecting answers without the headache. Once your form is ready, you have to get it in front of people and forms gives you three audiences to choose from. The first is anyone can respond, which means anyone inside or outside your organization can fill it in without signing in. The second is, only people in my organization can respond, which asks people to sign in with their work or school login. The third is a specific list of people or groups, which is exactly what it sounds like, and it caps out at one hundred names or groups with the two organization options. You also get a say in privacy. You can record each person's name, or you can keep the answers anonymous. And one response per person is an option. If you don't want repeat votes, then you pick how to send it, and there are more ways than you'd guess. You can copy a plain link or a shortened one.

7:03 An invitation can go out by email through outlook, or you can post it in a team's group or channel. There's a QR code to download for a poster or a slide, and an embed code to copy when you want the form inside a web page, one invitation can reach up to five hundred people at once. You can send the same form more than once, too. Nothing stops you from emailing it on Monday, posting it in teams on Wednesday, and printing the QR code for a sign up sheet, and every one of those paths points at the same form and the same set of answers. Two assistants can help you finish the job. Copilot can draft the invitation message for you, and smart reminders can nudge the people who haven't answered yet. The organization only options are the ones that need a work or school login. So if you're on a personal account, plan on the anyone can respond route. Either way, the answers start arriving and this is where it starts to matter for you.

7:47 The next question is where they all go. Answers that land in Excel by themselves. Inside forms, you get a live view of every answer. Summary charts update as responses arrive, each question gets its own breakdown, and there's a way to page through one person's answers at a time. For a quick look at how things are going, that's often all you need. The bigger move is the Excel button, and it's the feature that changes how people think about forms. When you choose open results in Excel, forms, creates a workbook and saves it in your OneDrive or in SharePoint for a group form. That workbook holds a live connection to your form, which means every new answer appears in the spreadsheet without you lifting a finger. This is where the confusion starts, and it pays to slow down. Here, the phrase export to Excel makes people picture a one time copy, a frozen snapshot they'll have to redo next week.

8:30 The live workbook is the opposite of that because it keeps itself current while you touch nothing at all. If you do want a frozen copy, there's a separate option for that download. A copy gives you an offline file with no connection. Back to the form. Open the live workbook and the layout is friendly. The first five columns hold the respondent's ID, the time they started, the time they finished the name and the email, and the rest of the columns are their answers. Anonymous responses simply leave the name and email blank. There's one rule to remember about the live link. Only the form owner and people in your organization with edit access to the workbook can refresh the data. Someone outside your organization can't trigger that update. Letting power automate do the follow up. This is the part that turns a form into a system.

9:10 So let's take it slowly. Power automate is Microsoft's tool for building. When this happens, do that rules without writing code, you pick something that starts the flow, and then you line up the actions that follow with forms. The starting point is a trigger called. When a new response is submitted, you point it at your form and now the flow wakes up every time someone hits submit. Next, you add a step called Get Response Details, which reads the actual answers, and from there you can send them anywhere you like. The trigger only cares that a response arrived and the rest is yours to shape. So a flow can be as short as two steps or as long as the job needs. The common patterns are easy to picture. A new response can email you or your whole team the moment it arrives. The person who answered can get a copy or a confirmation automatically.

9:51 You can push the response into an approval so a manager signs off before anything else happens. Each answer can drop in as a new row in an Excel table, which keeps a running log, and if someone uploaded a file, the flow can email a link to it. One flow ties all of that together. So let's walk through it. Picture a vacation request form. Someone fills in their name and their dates and hits submit. The flow. Catches the response, sends it to a manager for approval, and only when the manager approves does it write the row into the Excel table. Nobody copies and pastes anything, and the record builds itself. If that sounds like developer work, it isn't. You can describe the flow in a plain sentence and let copilot draft it, and ready made templates already handle the common jobs, so you can start from one and adjust it. A Microsoft three hundred sixty five account includes access to Power Automate, so there's no new purchase sitting between you and this.

10:35 That's the moment the form stops being a survey. It becomes the first step of a process that keeps going without you. The limits worth knowing. Every tool has edges and knowing them up front saves you a rebuild later. The first edge is the question ceiling. A single form can hold up to two hundred questions, and that sounds like plenty until you remember the Likert trick. Every statement in a Likert grid counts as its own question, so ten statements eat ten of your two hundred. The second edge is how many forms you can keep. One person can hold four hundred forms and a separate four hundred. Polls and team forms add more room on top of that. The recycle bin counts too. So old forms you meant to delete still take up space. The third edge is the number of answers a form can collect.

11:15 A business or education form can take up to five million responses, which is far beyond what a team survey would ever need. Personal accounts sit much lower, around two hundred responses on a free account and a thousand on a paid one. Character limits matter as well, and two of them show up in daily use. A single question can hold four thousand characters, and one person's whole set of answers can hold two hundred thousand characters across the form. The form title stops at ninety characters, which is why short titles work best. The edge that surprises people is the one at fifty thousand responses past that mark. The summary charts the individual response view, the printing and the summary link all stop working though you can still export everything to a file. That's a real ceiling, and it's the kind of thing you'd rather know before you build a giant survey.

11:56 Then there's the branching rule from earlier, which is a limit in its own way. Branches only move forward, and a form that ignores that rule breaks the moment someone answers. Where forms fits in your Microsoft world, Zoom out for a moment, because the point of all this isn't the form itself. Forms is one piece of a connected set of tools. It sits next to teams where you can share it. SharePoint where group answers can live. Excel where the numbers land, and OneDrive where the files go. Power automate is the glue that moves things between them. Read it as a chain and the whole thing makes sense. A form is the front door. Excel is where the answers settle, and Power Automate is what acts on them. You don't have to learn all of Microsoft in one go. You can start with one form, follow the answers into a spreadsheet, and add the automation later.

12:38 Once you see the shape of your own process. Copilot is woven through it now too, which means forms can suggest questions and even draft an automation for you that keeps the tool friendly. For someone who has never built anything like this before. That's also why form shows up in so many beginner guides. It's the easiest on ramp to the power platform, the family of tools that includes Power Automate, and once you've built one flow, the next one comes faster. That's the real reason forms earns your time. It's the smallest possible step into a much larger world, and it happens to be a step you can take today. Microsoft Forms comes with an account you likely already have. It builds surveys and quizzes in your browser, and it hands answers straight to Excel and Power Automate. If you want more tools made this simple, subscribe to M365 FM.

13:19 One question to leave you with. If a form could take over one boring task in your week, which task would you hand it first?