Search "waitlist spreadsheet template" and you will find a hundred of them: a column for the name, a column for the phone, a row per person. They all work on a quiet Tuesday. They all fail on the Saturday you actually need them.
Where the sheet breaks
A line has three rules a spreadsheet cannot enforce on its own.
Only one person can be number 12. When two people sign up at the same minute, whoever edits the sheet last wins, and the other one finds out at the counter. A form that feeds a sheet has the same problem one step removed.
Full means full. A sheet does not know you have 20 stools. It will happily take row 41, and now you are the one writing the apology.
The list belongs to today. Tomorrow's walk-ins should start at #1 again. In a spreadsheet that means someone remembers to clear the tab, or starts a new one, or does not.
What a line needs instead
A number that is handed out once, a cap that stops the form, and a reset that happens at the time you pick. That is the whole product. The name and phone still end up in a list you can export; the difference is that the counting happens before the row exists, not after.
Here is the setup a walk-in restaurant would use. It caps the day, resets at closing, and only takes names while the kitchen is open.
Restaurants
RecipeTonight's counter
10 per day
10 seats per day. The count resets at 5:00 AM in your time zone.
- 10 per day
- Tue, Wed, Thu, Fri, Sat 6 AM–12 PM
- 4 fields
A barbershop wants nearly the same thing with a smaller number. Both take about a minute to create and both give you the CSV you had before, minus the arguments.
Barbershops
RecipeWalk-ins
12 per day
12 walk-ins per day. The count resets at 8:00 AM.
- 12 per day
- Tue, Wed, Thu, Fri, Sat 8 AM–5 PM
- 4 fields
When to keep the spreadsheet
If your line never exceeds a dozen people, nobody joins at the same time, and you do not care about a cap, the sheet is fine. If you need to page the person at the front by text message while they wait outside, you want a walk-in queue tool, not us. We are the link people join before they arrive.