📊 Free step-by-step guide

How to Make a Signup Sheet in Google Sheets

Build a structured signup sheet in Google Sheets with dropdown slots and a protected header row, see where a shared spreadsheet still falls short for signups, and a faster free option.

How do you make a signup sheet in Google Sheets?

To make a signup sheet in Google Sheets, open a new spreadsheet at sheets.new, add column headers like Name, Time Slot, and Email in the first row, and optionally use Data > Data validation to create a dropdown of available slots. Then click Share, set General access to “Anyone with the link,” and choose “Editor” so people can add their names.

Make a signup sheet in Google Sheets: step by step

The genuine, free way to do it right inside Google Sheets.

1

Create a blank spreadsheet

Go to sheets.new (or Google Drive > New > Google Sheets) and give it a name at the top left.

2

Add your column headers

In row 1, type headers like Name, Time Slot, Email, Notes. Put one signup per row underneath.

3

Add a dropdown of slots (optional)

Select the slot column, click Data > Data validation > Add rule, choose Dropdown, type each slot, and click Done.

4

Protect your header row (optional)

Select the header row, click Data > Protected sheets and ranges, add the range, and restrict who can edit it so people don't overwrite your headers.

5

Share with edit access

Click Share, change Restricted to Anyone with the link, set the role to Editor.

6

Send the link

Click Copy link, then Done, and share it with your group so they can add their names.

Where a Google Sheets signup sheet falls short

Sheets is more structured than a Doc: you can constrain slots with dropdowns and lock your headers. But it's still a shared-edit spreadsheet, and these gaps are real:

No automatic capacity limit or waitlist. Nothing stops 20 people from choosing the same slot; enforcing a cap needs custom Apps Script most people won't write.
Everyone needs edit access to the whole sheet. To type their name, each person must be an Editor, so anyone with the link can alter the entire file.
People can edit or delete others' entries. Editors can overwrite rows that aren't theirs. Protected ranges only shield the specific cells you lock, like the headers.
No confirmation or reminder emails. Sheets sends no receipt when someone signs up and no nudge before the event.
Dropdowns don't shrink as slots fill. A dropdown always shows every option; it can't remove a slot once it's taken.

The faster alternative: a purpose-built signup sheet

If you want dropdown-style slots that actually enforce a limit - and entries people can't overwrite - a signup tool does it without Apps Script. 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.

Google Sheets vs. a dedicated signup tool

Signup taskGoogle SheetsGrasshopper 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)NoYes

Google Sheets signup sheet FAQs

Yes. Select the cells, click Data > Data validation > Add rule, and under Criteria choose Dropdown (type each slot) or Dropdown from a range. Click Done and each cell becomes a clickable menu. Note the dropdown shows every option even after a slot is claimed.

There's no true per-row protection. You can protect fixed areas like the header row with Data > Protected sheets and ranges, but any Editor can still change the open signup rows. Version history lets you undo unwanted changes after the fact.

Not on its own. Sheets has no built-in capacity cap or waitlist, so multiple people can select the same slot. Enforcing a limit requires custom Apps Script. If auto-closing slots matters, a dedicated signup tool handles it natively.

Forms collects responses privately (people can't see or edit each other's answers) and feeds a linked spreadsheet. Sheets shows everyone the live list, handy for “who's bringing what.” Neither enforces slot capacity or runs a waitlist without add-ons or scripting.

Not necessarily. With “Anyone with the link” set to Editor, people can edit without signing in. The trade-off is anonymous editors are harder to identify and can change anything in the file.

Make a signup sheet in another tool

Google FormsGoogle DocsMicrosoft FormsWordExcel

Or start with a ready-made signup sheet

Online Signup SheetsCreate a Signup SheetVolunteer Signup SheetsPotluck Signup SheetsAll Templates

Want slot limits without writing a script?

No Apps Script, no dropdowns that ignore capacity: create a free signup sheet where each slot has a real cap, overflow goes to a waitlist, and entries stay protected.

Create Your Free Signup Sheet