How to Use Microsoft Forms for Surveys

Building a survey in Microsoft Forms takes about ten minutes. Building one that produces answers you can actually use takes a bit longer, and almost all of the extra time goes into decisions made before the first question is typed.

This guide is the practical version: how to design questions that get honest answers, how to use branching so people only see what applies to them, how to get responses into Excel and other systems, and how to handle respondents' information properly. If you're still deciding whether Forms is the right tool at all, start with what Microsoft Forms is good for and come back.

Step 1: decide what you'll do with the answers

The most common survey mistake is asking things you won't act on. Every question costs the respondent a few seconds, and completion falls as the survey gets longer. So before writing anything, finish this sentence for each question: "If the answer is X, we will..."

If you can't finish it, cut the question. A five-question survey that eighty people complete beats a twenty-five-question survey that thirty people abandon halfway through.

Step 2: write questions people can answer honestly

Forms gives you plenty of question types: choice, text, rating, date, ranking, Likert, Net Promoter Score and file upload. The type matters less than the wording. A few rules that make the difference:

• One thing per question. "How satisfied are you with our pricing and support?" is two questions. Someone who loves your support and hates your prices can't answer it.
• Don't lead. "How much did you enjoy our new service?" assumes they enjoyed it. "How would you rate our new service?" doesn't.
• Use closed questions for counting, open ones for understanding. Ratings and choices give you numbers to chart. A single optional "Anything else we should know?" at the end often produces the most useful insight of all.
• Offer a way out. Add "Not applicable" or "Prefer not to say" where it fits. Forced answers are usually made-up answers.
• Keep scales consistent. If 5 means "very satisfied" in one question, don't make it "very dissatisfied" in the next.

Step 3: use branching so nobody wades through irrelevant questions

Branching sends people to different questions based on their answers. In the form's menu, choose Branching, then for each answer pick where the respondent goes next.

A simple example: "Have you contacted our support team in the last three months?" Yes goes to a section about the support experience. No skips straight to the next topic. Respondents who haven't used support never see five questions they can't answer, so they're more likely to finish.

Two tips that save frustration. Group related questions into sections first, because branching to a section is far easier to manage than branching between individual questions. And test every path yourself using Preview before you send it. It's easy to create a branch that skips the end of the form, or loops back on itself.

Step 4: choose who can respond, and what you collect about them

Under Settings, Forms lets you choose who can fill out the form:

• Anyone can respond — customers, suppliers, the public. Responses are anonymous unless you ask for names.
• Only people in my organisation — staff must sign in, and you can choose to record their name automatically and limit them to one response each.
• Specific people or groups in my organisation — handy for a single team or committee.

This choice decides more than access. File upload questions only work for people inside your organisation, because uploaded files are saved to the form owner's OneDrive or SharePoint and respondents have to be signed in. If you need files from customers, Forms isn't the right tool for that part.

For staff surveys about culture or management, think hard about recording names. People answer more honestly when they believe a survey is anonymous, so if it's meant to be anonymous, switch off name recording and say clearly in the description that you have.

Step 5: get responses into Excel and keep them there

The Responses tab shows live summary charts, which are good for a quick look. For real analysis, choose Open results in Excel. Forms creates a workbook in your OneDrive with a row per response and a column per question.

One detail catches people: new responses sync into that workbook automatically when it's opened in Excel for the web. In the desktop app you can view the data, but the live sync is a web feature. Build your charts and PivotTables on a separate sheet that references the response table, rather than editing the response sheet itself, so new rows flow in without breaking anything.

From there, our guide to simple data visualisation covers turning the numbers into charts people read.

Step 6: automate what happens after someone submits

A survey is often the start of a process, not the end of one. Power Automate's Forms connector has a trigger, When a new response is submitted, which Microsoft 365 business plans can use without extra licensing because it's a standard connector. Common flows:

• Alert on bad scores. If a customer gives a rating of 2 or less, post it to a Teams channel straight away so someone calls them today, not when the survey closes.
• Create a task. An internal request becomes a task in Microsoft Planner, assigned to the right person.
• Add to a SharePoint list. When responses need tracking through stages (new, contacted, resolved), a list beats a spreadsheet.

For more ideas along these lines, see automating daily tasks without a huge budget.

Step 7: look after respondents' data

If your survey collects names, email addresses, health details or anything else that identifies a person, it's collecting personal information, and businesses covered by the Privacy Act have obligations about how it's collected, used and kept. A few practical habits help with that:

• Collect the minimum. If you don't need a phone number, don't ask for one. Data you never collect can't leak.
• Tell people why. Use the form description to say what the information is for and who will see it.
• Control who can see responses. When you share a form to collaborate, collaborators can see the results. Use a group form owned by the team rather than an individual, so responses don't disappear into one person's account when they leave.
• Tidy up. Delete responses and exported workbooks when you no longer need them, rather than keeping them forever by default.

The Australian Privacy Principles are the reference point if you're unsure. Organisations handling sensitive information, such as NDIS providers and non-profits working with clients, should be especially careful about what goes into a survey.

And, uh, a brief word of caution. It's very easy now to survey people about everything: after every call, every delivery, every login. We can. Whether customers want to rate their experience of rating their experience is, you know... a different matter. Survey less often and act visibly on what you hear, and response rates tend to look after themselves.

Step 8: get more people to finish it

• Say how long it takes in the description, and make it true. "Two minutes, five questions" is a promise people will hold you to.
• Send it at the right moment. A service survey the day after the job gets better responses than one a month later.
• Use a QR code for in-person situations: the counter, an event, a delivery docket. Forms generates one when you share.
• Close the loop. Tell people what you changed because of the last survey. It's the most effective way to get answers to the next one.

Frequently asked questions

How do I create a survey in Microsoft Forms?

Go to forms.office.com, sign in with your work account and choose New Form. Add questions with Add new, group them into sections, set up branching from the form menu, choose who can respond in Settings, then use Collect responses to share a link, QR code or embed code.

How do I get Microsoft Forms responses into Excel?

On the Responses tab, select Open results in Excel. Forms creates a workbook in OneDrive with one row per response. New responses sync automatically when the workbook is opened in Excel for the web.

Are Microsoft Forms responses anonymous?

Forms set to "Anyone can respond" are anonymous unless you ask for identifying details. For forms limited to your organisation, you can choose whether to record respondents' names in Settings. Turn that off and tell people if the survey is meant to be anonymous.

Can external people upload files to Microsoft Forms?

No. File upload questions only work when the form is restricted to people in your organisation, because files are saved to the form owner's OneDrive or SharePoint and respondents must be signed in.

Local IT and cyber security support across NSW

Chewing IT runs managed IT and cyber security for small and mid-sized businesses from our Wyong and Hornsby offices, covering the Central Coast, Newcastle, Lake Macquarie and Hornsby.

Want surveys and forms that feed straight into your systems? Talk to our Microsoft 365 team about setting up Forms, Excel and Power Automate properly.