📋 Free step-by-step guide

How to Make a Signup Sheet in Microsoft Forms

Build a signup sheet in Microsoft Forms in a few minutes, learn the per-slot limit it can't enforce on its own, and see the faster way when you need capacity and a waitlist.

How do you make a signup sheet in Microsoft Forms?

To make a signup sheet in Microsoft Forms, go to forms.office.com, select New Form, and add a title. Add a Choice question listing your slots or items, plus Text questions for name and email. Then open Settings to set who can respond and a response deadline. Note: Forms has no native per-slot capacity limit.

Make a signup sheet in Microsoft Forms: step by step

The genuine, free way to do it right inside Microsoft Forms.

1

Start a new form

Go to forms.office.com, sign in with a Microsoft account, and select New Form.

2

Add a title and description

Type a title and an optional description. The form auto-saves as you work.

3

Add your slots as a Choice question

Select Add new and choose Choice. Enter the question (“Which slot can you take?”) and use Add option to list each slot, shift, or item.

4

Add name and email questions

Add Text questions for name and email. On a work or school form you can turn on “Record name” instead of asking for it.

5

Set who can respond and a deadline

Open Settings. Under Who can respond, choose “Anyone can respond” for public signups, and set a Start/End date to open and close the form. (Note: the One response per person option only appears on “Only people in my organization” forms, since it needs a signed-in work or school account.)

6

Preview and share

Select Preview to test it, then use the Collect responses share link. Track results on the Responses tab or export to Excel.

What Microsoft Forms can't do as a signup sheet

Microsoft Forms handles the basics well, but it was built for surveys and quizzes. The signup-specific gaps are real:

No per-option capacity or waitlist. You can't limit a slot to N people or auto-close it when full without Power Automate or a connected Microsoft List. Branching can redirect people, but it doesn't enforce a cap.
Respondents can't see remaining slots. Options don't show a live count, so people keep picking a “full” slot until you intervene.
Turning responses into a roster is manual. Results live on the Responses tab or an Excel export; there's no built-in per-slot roster.
Creating a form needs a Microsoft account. You need at least a free personal Microsoft account, and respondents may be forced to sign in if the form is org-only.
Response limiting is all-or-nothing. The native limits apply to the whole form, not individual choices, and “one response per person” only works on org-only forms where everyone signs in with a work or school account.

The faster alternative: a purpose-built signup sheet

If you need per-slot capacity, a waitlist, or reminders without wiring up Power Automate, a purpose-built signup tool does it out of the box. Grasshopper Signup is free and needs no account to start.

  • Set a limit on each slot and it fills, then locks, automatically - no add-on or script needed
  • Automatic waitlist: when a spot opens up, the next person is offered it
  • Confirmation and reminder emails go out to everyone who signs up
  • People sign up from a link in seconds - no account, no editing a shared file
  • See a live roster and headcount, exportable to CSV any time
  • Describe your event and AI builds the whole form in about 30 seconds
Create a Free Signup Sheet

Free, no account needed to start.

Microsoft Forms vs. a dedicated signup tool

Signup taskMicrosoft FormsGrasshopper Signup
Cap each slot and close it automatically when fullNoYes
Automatic waitlist when a slot is fullNoYes
Automatic confirmation and reminder emailsNoYes
Shows remaining spots to people as they sign upNoYes
Keeps each person's entry private (no overwriting)YesYes

Microsoft Forms signup sheet FAQs

Not natively. Forms has no setting to cap how many people choose a specific option or to auto-close it when full. The only workarounds are monitoring responses manually, using Branching to redirect people, or building a Power Automate flow or Microsoft List to count and enforce limits.

You need a Microsoft account, but not necessarily a paid subscription. A free personal account ending in @outlook.com, @hotmail.com, or @live.com works, as do work and school accounts. Some organization-only settings appear only on work or school accounts.

Both are possible. Under Settings, “Who can respond” offers “Anyone can respond,” “Only people in my organization,” and “Specific people in my organization.” The org-only options are a work or school feature; choose “Anyone can respond” for public, no-sign-in signups.

No. Forms doesn't display a live count of remaining spots next to each choice, and it won't hide or disable an option once it's full. Respondents can keep selecting a full slot until you close the form or edit the options.

A dedicated signup tool like Grasshopper Signup does what Forms can't: capping each slot and closing it when full, running an automatic waitlist, and sending confirmation and reminder emails, with no Power Automate setup and no account needed to sign up.

Make a signup sheet in another tool

Google FormsGoogle DocsGoogle SheetsWordExcel

Or start with a ready-made signup sheet

Online Signup SheetsCreate a Signup SheetVolunteer Signup SheetsPotluck Signup SheetsAll Templates

Need per-slot limits without Power Automate?

Skip the Power Automate and Microsoft List workarounds: create a free signup sheet that caps each slot, waitlists the overflow, and reminds everyone automatically.

Create Your Free Signup Sheet