How to Use Microsoft Forms for Surveys and Data Capture

Microsoft Forms is the lightweight survey, quiz and data-capture tool included with virtually every Microsoft 365 Business plan. If you pay for Business Basic, Standard or Premium, you already have it — no extra licence. For most Melbourne SMEs it handles client intake, staff feedback and event RSVPs without touching SurveyMonkey or Typeform.

It is not a heavyweight platform, and it is not trying to be. The value is that it is already in your tenant, lands responses straight into Excel, and keeps data inside your Microsoft 365 environment rather than scattered across a free third-party account nobody owns.

What Microsoft Forms is, and what you already pay for

Forms is a browser-based tool for building online forms, surveys and quizzes. You build it at forms.office.com or in the Forms app, share a link, and responses flow back in real time. It works on any device with a browser, and respondents do not need a Microsoft account to fill in a public form.

Beyond the Business plans, it is bundled into the Microsoft 365 Enterprise (E) plans and most education and non-profit plans. If you are unsure what your subscription includes, our breakdown of what is included with Microsoft 365 support in Melbourne lays it out. The practical point: you are almost certainly already paying for Forms and not using it.

Form versus quiz: pick the right type

When you create something new, Forms asks whether you want a form or a quiz, and the difference matters.

• Form — for collecting information where there are no right or wrong answers: client intake, feedback surveys, RSVPs, incident reports, booking requests. This is what most businesses need.
• Quiz — for assessment. You set correct answers and point values, and Forms marks responses automatically and shows scores. Useful for staff training checks, onboarding tests, or compliance refreshers where you need to prove someone passed.

You cannot cleanly convert one to the other afterwards, so choose deliberately. If in doubt, a form is the safer default.

Question types and branching logic

Forms gives you a sensible spread of question types: choice (single or multiple), text (short or long), rating, date, ranking, Likert scales, file upload, and Net Promoter Score. Each question can be marked required, and text questions can enforce validation such as number ranges or email format.

Branching logic

The feature that lifts Forms above a flat questionnaire is branching. You can route a respondent to different questions based on their answers — answer “yes” to “Have you used our service before?” and they skip the new-client section entirely. To set it up, build all your questions first, then open the question menu, choose Add branching, and map each answer to the question it should jump to. Branching keeps forms short and relevant, the single biggest driver of completion rates.

A short how-to: building a client intake form

The end-to-end for a typical intake form:

1. Go to forms.office.com, sign in, and select New Form.
2. Give it a clear title and short description — respondents see both.
3. Add your questions. Use Choice for fixed options, Text for free responses, and mark essentials as Required.
4. Add branching where questions only apply to certain answers.
5. Click Settings (the three dots) to control who can respond, whether responses are anonymous, and whether to send a receipt.
6. Hit Preview to test it on desktop and mobile, then Collect responses, choose your sharing method, and copy the link.
7. Watch responses arrive under the Responses tab, and click Open in Excel to export.

The whole thing takes ten minutes once you know the layout.

Sharing: internal, external and the tenant setting that controls it

This is where businesses get caught out. How you share a form decides who can fill it in, and whether their data is captured securely.

The critical detail: the “Anyone can respond” option is controlled at the tenant level by your administrators. In the Microsoft 365 admin centre, under the Forms settings, there is a toggle for external sharing. If it is switched off — and in security-conscious tenants it often is — staff will not see the “Anyone” option at all, and every form is locked to internal-only.

That is a sensible default, but it bites when someone genuinely needs to collect responses from clients or the public and cannot work out why the option has vanished. Enabling external collection is a deliberate decision, weighing convenience against the fact that an open link can be forwarded to anyone. We treat it as part of broader tenant hardening, alongside our work on conditional access policies for Microsoft 365.

Collecting responses into Excel

Every form has a Responses tab with a live summary — charts for choice questions, individual responses, aggregate counts. For real analysis, click Open in Excel.

For forms created inside a SharePoint or Teams group — which is how business forms should be set up — you get a live workbook in the group’s SharePoint library that updates as responses arrive. The data lives in a shared, owned location rather than tied to one person’s profile, so it survives that person leaving. Getting Forms created in the right place is a small governance decision we set up as part of a managed Microsoft 365 environment.

Real SME use cases

A few patterns we see work well:

• Client intake — a new-client form capturing contact details, requirements and consent before the first meeting, replacing the email chase.
• Staff feedback — anonymous internal pulse surveys where honesty depends on people trusting it is genuinely anonymous (set “Record name” to off and tell them).
• Event RSVPs — a public link for a client function or open day, with branching for dietary needs and plus-ones.
• Incident reporting — an internal form for staff to log near-misses, IT issues or workplace incidents into a tracked Excel list someone reviews.

A professional services firm in Hawthorn we work with replaced a tangle of Word-document intake sheets with a single branching Forms intake. New enquiries now land structured and complete in a SharePoint-backed spreadsheet their reception team works from each morning — no retyping, no chasing missing fields, no cost beyond licences they already held.

Data residency and privacy

Because Forms is part of Microsoft 365, response data sits within your tenant’s cloud storage, governed by the same agreements as the rest of your environment. Commercial tenants provisioned for Australia store core customer data in Australian data centres, which matters where clients or regulators have data residency expectations.

That said, a tool being inside Microsoft 365 does not make your collection compliant by itself. If you are gathering personal information, the Privacy Act and the Australian Privacy Principles still apply — you need a lawful reason to collect it, you should tell people what you are collecting and why, and you must store and dispose of it responsibly. For health information the OAIC’s expectations are stricter again. Keep forms to the minimum data you need.

Limits, and when to step up

Forms is deliberately simple, and you will hit its ceiling if you push it. Worth knowing the edges:

• It is built for straightforward surveys and capture, not multi-stage workflows, approvals, or apps with stored logic and dashboards.
• Styling and branding are limited — you get themes, not full design control.
• No built-in payment collection, no complex conditional calculations, no relational data model.
• Response and question counts are generous for SME use but capped; very high-volume surveys can hit limits.

When you outgrow it, the upgrade path is clear. Microsoft Dynamics 365 Customer Voice (the successor to the old “Forms Pro”) adds richer survey distribution, follow-up automation and CRM integration. Power Apps is the answer when you need a genuine application — stored data, business logic, role-based access, dashboards — rather than a flat survey, often paired with Power Automate to trigger workflows off submissions. Both are bigger commitments, so use Forms until it genuinely stops fitting.

Frequently asked questions

Is Microsoft Forms free?

It is included at no extra cost with Microsoft 365 Business Basic, Standard and Premium, the Enterprise plans, and most education and non-profit plans. There is a limited version tied to free personal accounts, but business use should run through your paid tenant so data stays governed and owned.

Can people outside my organisation fill in a form?

Yes, if you share it with the “Anyone can respond” option — but that option is controlled at the tenant level by your administrators. If external sharing is switched off in your admin settings, staff can only share forms internally. Enabling external responses is a deliberate administrative decision.

Are responses to a Microsoft Form really anonymous?

Only if you set them up that way. Internal forms can record the respondent’s name unless you turn that off. Public forms are anonymous by default unless you add a question asking for identifying details. If you promise staff anonymity on a feedback survey, confirm the “Record name” setting is off first.

When should we move off Forms?

When you need workflows, approvals, stored business logic, payments or a proper application rather than a survey. At that point Dynamics 365 Customer Voice or Power Apps with Power Automate is the right step up — both bigger commitments worth scoping properly.

Getting it set up right

Forms is one of the most under-used tools in a typical Microsoft 365 subscription. The setup that matters is the bit most businesses skip: forms created in shared SharePoint-backed locations so data is owned not orphaned, the external-sharing and anonymity settings configured correctly, and collection kept within your privacy obligations. We are a Melbourne-based MSP with 13 Australian-employed engineers, and getting clients full value from the Microsoft 365 they already pay for is core to what we do. If you want your tenant configured so tools like Forms are safe and useful out of the box, get in touch and we will sort it.