How to Make a Sign Up Sheet in Google Forms, Sheets, or Docs
Full steps for each, and the settings most tutorials skip
Google Sheets is the quickest Google sign up sheet: a table of slots that people edit from a shared link. Google Forms keeps entries private and tidy but cannot close a slot when it fills. Google Docs is best for a sheet you print. None of them send reminders. Here is how to build each one properly.
Last updated
Google Forms vs Sheets vs Docs for sign-ups
| Google Sheets | Google Forms | Google Docs | |
|---|---|---|---|
| People see who signed up | Yes | No | Yes |
| Limit spots per slot | One row per spot | Only with an add-on | One row per spot |
| Someone can erase another name | Yes, unless you protect ranges | No | Yes |
| Needs a Google account to sign up | No, with link editing on | No | No, with link editing on |
| Reminders | No | No | No |
| Best for | Shifts, potlucks, time slots | Collecting details privately | A sheet you print |
How to make a sign up sheet in Google Sheets
- 1
Create a new spreadsheet
Go to sheets.new. In row 1, type headers: Slot, Name, Email or phone, Notes.
- 2
List one row per spot
Put each time, dish, or job in column A. If a shift needs three people, give it three rows with the same slot name.
- 3
Lock the slot column
Select column A and row 1, then Data > Protect sheets and ranges, and set it so only you can edit. People can fill in names but cannot rename or delete the slots.
- 4
Freeze the header row
View > Freeze > 1 row, so the headers stay visible on a phone.
- 5
Share for editing
Share > General access > Anyone with the link, role Editor. Copy the link and send it.
- 6
Check version history if a name disappears
File > Version history shows earlier versions, so you can restore an overwritten name.
How to make a sign up sheet in Google Forms
- 1
Create a blank form
Go to forms.new and give it the event name and date as the title.
- 2
Add name and contact questions
Short answer for name, set to required. For email, use Settings > Responses > Collect email addresses.
- 3
Add the slots as a multiple choice question
One option per slot, like "Saturday 9–11 am" or "Dessert". Use checkboxes if people may pick more than one.
- 4
Link responses to a sheet
Responses tab > Link to Sheets, so every sign-up lands in a spreadsheet you can sort.
- 5
Share the link
Send > the link icon > Shorten URL, then post it in email, a group chat, or a QR code.
Forms has no setting to close an option once enough people pick it. A third-party add-on can remove a choice when it hits a limit, but people still cannot see who else signed up, and nothing reminds them before the day.
How to make a sign up sheet in Google Docs
Want the table already made? Download a free sign up sheet template in Word, PDF, or Excel.
- 1
Start a document
Go to docs.new. Add the event name, date, time, and place at the top.
- 2
Insert a table
Insert > Table, with columns for Slot, Name, and Phone or email, and one row per spot.
- 3
Print it or share it
File > Print for a clipboard sheet, or Share > Anyone with the link as Editor so people type their names in.
Docs tables are fine on paper and awkward on a phone, and anyone with edit access can change the whole document. Prefer Sheets for anything people fill in online.
Where a Google sign up sheet breaks
- Two people grab the same last spot within seconds of each other, and one overwrites the other
- Someone deletes a row by accident and nobody notices until the event
- Nobody gets a reminder, so you send the "who is bringing what?" message yourself
- People without the link, or with a work account that blocks outside files, cannot open it
- Forms responses are private, so people keep signing up for the slot that is already full
A sign-up sheet tool fixes those five. SignupKit closes a slot when it fills, shows everyone what is taken, and sends reminder emails. It is free for 5 sheets with 50 sign-ups each, and nobody needs an account to sign up.
How to Create Your Sign Up Sheet with SignupKit
- 1
Create your event
Add the event name, date, location, and a short description for participants.
- 2
Add sign-up slots
Create slots for dishes, shifts, roles, or RSVP options. Set quantities and optional deadlines.
- 3
Share one link
Send a single mobile-friendly link. Participants sign up without creating an account.
- 4
Track and remind
See who signed up in real time, export the list, and send automated reminder emails.