Microsoft Forms stores the responses, but forms created inside a personal Microsoft account cannot receive them after the link is closed and no longer accept new entries once you stop collection. On a work or school account the same tool writes responses straight into Excel and pushes them to a SharePoint or OneDrive sync folder. That fork in behavior is the single biggest thing to know before you start, because it decides where you build the survey and what you can promise respondents about anonymity and retention.

Here's the practical path: sign in at forms.office.com, pick New Form, add questions, open the three-dot Settings menu, then send a link or QR code. The build takes roughly eight minutes for a ten-question form. The settings panel is where the real decisions live: who can respond, whether names are recorded, when the form closes, and what each respondent sees after submitting.

Step 1: Sign In and Choose Which Forms Account You Actually Need

Open forms.office.com in a browser. Microsoft Forms works in Edge, Chrome, Firefox, and Safari, and there's a mobile app for iOS and Android that lets you build and respond. Sign in with the account that owns the form; the owner is the person who can see responses, edit questions, and export data.

Account type governs almost everything downstream. A Microsoft 365 work or school license (Business Basic, Business Standard, Business Premium, or any Education plan) gives you co-authoring, automatic response sync to Excel, and sharing within an organization. A free personal Microsoft account gives you the same builder with fewer sharing controls and no organizational directory.

Check the plan before you invest time. Forms is included in Microsoft 365 Business and Enterprise subscriptions and in Microsoft 365 Education; consumer Microsoft 365 plans give personal-account forms limited collaboration. If your organization disabled Forms through the Microsoft 365 admin center, the app won't appear in your app launcher at all β€” that's a tenant setting, not a browser problem.

If you only need a quick quiz for a class, a personal account is fine. If you're collecting employee feedback that must stay inside the company and export to a shared workbook, get the work account first. Switching later means rebuilding the form from scratch, since forms don't transfer between account types.

Step 2: Start From Blank, a Template, or a Copilot Draft

On the Forms home page, click New Form. The blank canvas opens with an untitled form and a first question placeholder. You'll see three entry points: New Form, New Quiz, and a template gallery. Pick New Form for surveys; New Quiz adds grading, points, and correct answers that surveys don't need.

The template gallery is under the More templates tile. Microsoft ships templates for common jobs β€” event registration, customer satisfaction, employee onboarding feedback, and course evaluation. Teams also surfaces suggested forms when you add the Forms tab to a channel, which is faster than starting cold if your team already has a standard intake form.

Copilot in Forms drafts questions from a prompt when your license includes it. Microsoft's own documentation notes Copilot can suggest questions, rewrite them for clarity, and add answer choices; it can't choose your settings or distribution. Treat the draft as a starting skeleton and spend your time on the settings panel instead, where mistakes are harder to fix later.

A blank form is the safe default. Templates save typing but sometimes carry extra questions you don't need, and every unnecessary question lowers completion rates. If you use a template, delete aggressively before sharing.

Step 3: Add Questions With the Right Question Type

Click + Add new to insert a question, or + Add new with the section arrow to insert a section. The question type menu offers Choice, Text, Rating, Date, Ranking, Likert, File upload, Net Promoter Score, and Section. Choosing the wrong type is the most common rework cause, because changing a type later can wipe collected answers.

Set the question title, then use the ... menu on the question card for Required, Subtitle, Add branching, and answer-shuffle options. Choice questions support single or multiple answers and an optional "Other" write-in. Rating questions allow 5 or 10 stars or numbers, and Likert gives a 5- or 7-point agree/disagree grid.

Two mechanical limits matter. Forms caps a single form at 200 questions and a Choice question at 100 answer options; Microsoft documents these ceilings in its Forms service limits. Question titles have a practical limit around a few hundred characters, so long scenario text belongs in a section description instead.

Use Subtitle for instructions, not for the question itself. Screen readers announce the title, subtitle, and answer choices in sequence, so put the actual ask in the title. Mark only questions you truly need as Required β€” every required field is a drop-off point.

Step 4: Build Sections and Logical Order Before Adding Branching

Click the arrow beside + Add new and choose Section to create page breaks. Sections keep long surveys scrolling smoothly and let you branch around irrelevant blocks. Each section has a title, an optional description, and its own share link if you want to send people to a specific page.

Order sections the way a respondent experiences them: context first, core questions next, sensitive questions later, demographics last. Demographics at the end produce higher completion because trust builds before you ask for age, income, or tenure. Keep the first screen short; a single easy question lowers the abandon rate.

Number your thinking, not your questions. Forms numbers questions automatically with a sequence integer, and adding a section resets the visible numbering pattern in preview. Preview after every structural change by clicking Preview on the top bar, which shows the respondent's view and lets you submit a test response.

Collapse branches wherever a section doesn't apply to everyone. A customer satisfaction survey that asks churned customers why they left doesn't need the loyalty section. Building those paths now is cheaper than explaining awkward questions in the comments.

Step 5: Branch, Shuffle, and Shrink the Form With Settings

Branching is the feature most people miss. In the ... menu of a Choice question, choose Add branching. Forms then shows each answer option and lets you jump to any section or the end of the form. This is how you build a screening survey where unqualified respondents exit after two questions instead of wading through twelve.

The table below compares the response-facing toggles in the Settings pane. Open ... at the top of the form, then Settings, and read the options by the exact labels Microsoft uses.

Setting label What it changes Typical pick
Record name Saves respondent name with answers Off for anonymous feedback
One response per person Blocks repeat submissions by sign-in On for internal ballots
Shuffle options Randomizes Choice answer order On to reduce order bias
Accept responses Toggles the form open or closed Off when the window ends
Start and end date Auto-opens and auto-closes the form Set both for time-boxed surveys
Custom thank you message Replaces the default confirmation Always write one
Show results summary link Lets respondents see aggregate results Off unless you want transparency

Shuffle options hides position bias in rating and choice scales but also scrambles "Other" and "None of the above," which should sit last. Microsoft's help documentation confirms the shuffle applies to all options in that question, so keep those anchors in a separate question if order matters. Similarly, One response per person relies on sign-in; anonymous links can't enforce it.

For anything sensitive, turn Record name off before you send the first link. You can't retroactively anonymize responses already collected, and the toggle is buried one level deep, which is exactly why people forget it.

Step 6: Format the Header and the Thank-You Screen

Click the form title to add a title and description, then use the Theme button on the top bar to pick a color scheme or upload a banner image. Forms accepts images up to 5 MB in common formats; keep banners wide rather than tall so mobile respondents don't scroll past the first question to reach it.

The thank-you screen is edited under Settings β†’ Custom thank you message. Write one sentence confirming what happens next and one line naming a contact. "Thanks β€” results are shared with the team on Friday; questions to survey@yourdomain" beats the default "Your response was submitted."

If you plan to share results, toggle Show results summary link on the thank-you screen only when respondents should see aggregate data. For employee surveys, leaving it off is the safer default because small response counts make answers identifiable even without names.

Set expectations about anonymity here, not in the invitation email. If Record name is on, the thank-you screen shouldn't promise anonymity. Mismatched promises are the fastest way to lose trust and the slowest thing to repair.

Click Preview, answer every question as a respondent would, and submit. Then click Collect responses to open the sharing pane. You'll see four options: a link anyone with the URL can use, a short link, a QR code you can download, an embed code for a website, and an email invitation sent through Outlook.

The sharing choice interacts with the settings you just set. If Record name is off, the link is anonymous and Forms warns that only people in your organization can respond when the form is limited to your org β€” Microsoft's support notes that anonymous responses from outside the org require the "Anyone can respond" option. Share to external audiences only after deciding whether you want names attached.

For Teams, add a Forms tab to a channel or chat and pin the form. Respondents answer inside Teams and responses land in the same workbook as browser submissions. For events, the QR code is the fastest path: download the PNG from the sharing pane and paste it into a slide or printed sign.

Email the link to yourself first and open it on a phone. Mobile layout is where most forms break, and the preview inside the editor doesn't fully reflect the narrow screen. Fix answer-option line lengths before launch, not after forty responses.

Step 8: Read Responses in the Responses Tab and Sync to Excel

Open the Responses tab to see a live summary. For each question, Forms shows a chart by default; switch to the Responses view to read individual submissions, and use the arrow controls to page through. The tab also shows average completion time for the form, which is a useful signal for trimming questions.

Click Open in Excel to generate a workbook. Microsoft's documentation states responses sync to the workbook every few minutes; each question becomes a column, and multi-select answers arrive as semicolon-separated values rather than separate columns. That format detail trips up pivot tables, so split those columns with Text to Columns before analyzing.

In work or school accounts, the workbook lives in your OneDrive or a SharePoint document library and refreshes on open. The sync can fail if the workbook is renamed, moved, or opened in a way that breaks the connection; Microsoft's troubleshooting guidance says to re-create the Excel link from the Responses tab. Treat the original workbook as the connection anchor, not a copy.

For a quick read, the summary charts are enough. For anything you'll report, export to Excel and check for duplicate submissions, partial completions, and "Other" write-ins before quoting numbers.

Step 9: Export, Share Results, and Close the Survey Cleanly

Download responses from the Responses tab as an Excel workbook for offline analysis. If you need collaboration, share the form's response workbook through OneDrive or SharePoint rather than sending a static file, and give co-owners Edit permission on the form itself from the ... menu so they see live data.

Before you close, set the closing behavior in Settings. Turning Accept responses off, or setting an end date, stops new submissions and shows the thank-you message to anyone who still has the link. Announce the close date in the original invitation; respondents who click a dead link with no explanation assume the form broke.

Delete nothing yet. Keep the form and workbook in place for at least one reporting cycle, because follow-up questions and verification requests arrive after the survey closes. Forms retention follows the owner's OneDrive and SharePoint policies, so ask your administrator how long deleted forms persist.

Finally, note in your report what the export cannot answer. Anonymous responses can't be tied to departments unless you asked, and auto-saved partial responses appear in Excel only for respondents who use the same browser session. Report what the data supports.

What Changes Between Personal and Work Accounts

The builder looks identical, but the behavior splits at share time. Personal-account forms support the anyone-can-respond link, QR code, and Excel export; they don't integrate with SharePoint libraries, Teams tabs within an organization, or admin-managed retention. Work and school accounts add co-authoring, org-only links, and responses stored in a OneDrive or SharePoint workbook that admins can monitor.

That storage difference has a privacy consequence. In an organization, an administrator can access the response workbook through eDiscovery and retention tooling even when Record name is off. If your survey includes comments about management or workplace conditions, tell respondents where the data lives; claiming anonymity when admin access exists is the wrong promise to make.

Licensing is the other fork. Forms is bundled with Microsoft 365 Business and Enterprise subscriptions and education plans, and the consumer app has its own limits on collaboration. Check your plan's included apps in the Microsoft 365 admin center before promising a colleague co-edit rights they won't have.

Size limits behave the same way in both worlds: 200 questions per form and 100 answer choices per Choice question, per Microsoft's Forms service limits. Those ceilings rarely bite in surveys and regularly bite in quizzes with large answer banks.

Common Mistakes That Force a Rebuild

The first rebuild trigger is changing a question type after responses arrive. Forms warns that switching type deletes existing answers; people click through the warning, then find the data gone. Lock your question types before you share.

The second is forgetting Record name is on when you intend an anonymous pulse survey. Only the form owner sees names, but that group usually includes an executive assistant or analyst. Decide who should see names before the first response, not after the first complaint.

The third is assuming One response per person works on a public link. It requires sign-in, and anonymous links have no sign-in to check against. For anything resembling a vote, use an org-only link or a different mechanism entirely.

The fourth is editing a live form. Late-added required questions create a gap where earlier respondents have nothing in that column, and deleting questions removes their answers from the workbook on the next sync. Freeze the structure once you have real responses, or build a v2 form.

How Long Does a Basic Survey Take to Build

Expect about eight minutes for a ten-question form with a title, theme, and thank-you message, based on the click counts in the nine steps above. Add two or three minutes per branching rule and one minute per section, because each branching decision needs a jump target and a test submission.

Testing is the step people skip and the one that costs the most time. Plan on submitting three test responses: one on desktop, one on mobile, and one through the share link rather than preview. Preview doesn't reproduce the sign-in requirement or the anonymous-response warning, and those are exactly what respondents hit first.

Distribution and collection add calendar time, not effort. A typical internal survey runs five to ten business days; closing earlier lowers response counts and closing later delays your report. Set the end date when you send the first link.

Compare the alternatives honestly. A shared Excel workbook with a table can't enforce required questions or branching, and email questionnaires require manual collation that costs far more than eight minutes. Forms wins when you need structured responses and an export; a plain document wins when the "survey" is really two open-ended questions to three people.

FAQ

What is the difference between New Form and New Quiz in Microsoft Forms?

New Quiz adds an answer key, points per question, automatic grading, and a results-return option for respondents. Surveys lack grading and instead focus on anonymous or named response collection. Choose Quiz when you're assessing knowledge; choose Form when you're gathering opinions or data.

Can I collect responses anonymously while still knowing the department?

Yes β€” leave Record name off and add a required Choice question asking for department or team. The response stays unnamed, but the department column lets you segment results in Excel. Keep in mind that small departments can make responses identifiable by inference even without names.

Why did my Excel sync stop updating with new responses?

Renaming, moving, or replacing the linked workbook breaks the connection. Microsoft's guidance tells you to reopen the Responses tab and click Open in Excel again to re-establish the link, then use the newly generated workbook going forward. The original file can't be reconnected in place.

Does branching work with multiple-choice questions that allow more than one answer?

Branching only works on Choice questions set to single-answer mode. Multi-select questions can't drive a single path because the respondent's answers could point to different sections. Split a multi-select screening question into single-select questions when you need different routes.

What happens to responses if I change a question after sharing the form?

Switching a question's type deletes its existing answers after a confirmation warning. Deleting a question removes its column from the synced workbook on the next refresh. Adding new required questions leaves earlier responses blank in that field, creating a data gap worth flagging in your report.

Is Microsoft Forms available without a Microsoft 365 subscription?

A free personal Microsoft account can build and share surveys through forms.office.com, and the mobile apps work on iOS and Android. Organizations that disabled Forms in the admin center won't see the app at all, regardless of the user's individual license.

How many questions can one Microsoft Forms survey hold?

Microsoft documents a 200-question ceiling per form and 100 answer options per Choice question. Rating and Likert grids use their own limits on rows and points, so long matrix questions hit the row cap before the 200-question cap applies. Confirm current limits on Microsoft's Forms service limits page, since Microsoft controls them.

Can I see who submitted a response if I turned name recording off?

No. With Record name off, Forms doesn't store the identity of the respondent, and nothing in the Responses tab or the Excel export recovers it. In work accounts an administrator could still see that a submission came through a particular account under some configurations, so don't promise strict anonymity you can't guarantee.