Knowledge
Guest management: what the list needs and which tool to choose
Good guest management means having a single list, where each person has a clear status (invited, approved, confirmed, present) and personal data is under control. This article shows the columns you should have, common mistakes when importing from Excel, how to build an approval and attendance confirmation flow, 6 questions for trying out guest management software, and an honest comparison of Excel, Google Sheets and a dedicated platform like Tickmi.

What columns does a guest list need?
A usable guest list needs at least 8 columns: name, contact, group or guest type, source, approval status, confirmation status, presence status and notes. Without status columns, you will have to ask each person again at the last minute.
| Column | Purpose | Example |
|---|---|---|
| Full name | Printing on tickets and badges, calling names | Nguyen Van A |
| Email / phone number | Sending invitations, tickets, schedule reminders | One of the two is the minimum |
| Group / guest type | Access rights at the door, seating by group | VIP, partner, internal, press |
| Source | Knowing where guests came from | Partner list, self-registration, added by hand |
| Approval status | Sending tickets only to people who have been accepted | Pending / Approved |
| Attendance confirmation | Fixing the number of people who really come | Attending / Not attending / No response |
| Presence status | Tracking on the event day | Checked in at 8:42 |
| Notes / custom fields | Meals, table, organization, position | Vegetarian, table 5 |
On Tickmi, you can add custom information fields (text, dropdown list, image), and these fields automatically appear in the add-person form, the Excel template and the registration form. For an overview of this group of tasks see guest management on Tickmi.
Importing a list from Excel: common mistakes
Most Excel import errors come from formatting, not from the software. Check these five points before uploading:
- Phone numbers losing the leading 0: Excel converts them to numbers. Set the column to text type before entering.
- Emails with spaces or typos: "gmail.con" and "hotmail.vn" do not actually exist. Scan by eye for odd endings.
- Guest type names that do not match: writing "Vip" on one row and "VIP" on another are two different values in many tools. With Tickmi, the Ticket type column must contain the exact ticket type name, otherwise that row reports an error.
- Blank rows and merged cells: merged cells shift columns. Unmerge cells and delete blank rows.
- Re-importing the same file: easily creates duplicates. Tickmi currently only adds new people when importing Excel, and does not update existing ones; if you re-import the whole file, delete the rows that were imported successfully first.
Detailed handling, including the limit of 10,000 rows per import and the error file with an Error column, is in the attendee management guide.
Guest approval flow: who gets onto the official list?
An approval flow separates "has a name on the list" from "has been accepted and receives a ticket", letting you review before sending. This is the step people often skip and then regret after sending tickets to the wrong person.
- On Tickmi, people who are added by hand, imported from Excel or self-register through a ticket type without auto-approval are all in Pending approval status.
- Tickets are only issued when you Approve each person, approve by selection or Approve all. Only at this point is ticket issuance quota counted and email sent.
- Certain guests (partners, internal) can have auto-approval turned on; open-registration guests should be approved by hand.
How to turn on automatic or manual approval for a registration page is in the guide to creating a registration page.
How do you handle duplicate guests?
Duplicate guests are usually the same person with two emails or two phone numbers, or the same name written differently. No tool guesses 100% correctly, so the safe rule is: choose one identification key (usually email or phone number), sort by that key and scan by eye before approving.
With Tickmi, review the list in Pending approval status before approving, because after approval the ticket is issued and the quota has been used. Tickmi does not claim to remove duplicates on import, so do not rely on this feature; ask any vendor if you need it.
RSVP: know who will come before the event day
RSVP turns "invited" into "will come", helping you fix seats, meals and gifts. The minimum standard: a personal confirmation link for each person, a deadline you can set, reminders for people who have not responded, and automatic result counting.
- On Tickmi, each ticket has a personal confirmation link placed in the email; recipients choose I will attend or I cannot attend.
- You set a confirmation deadline, send invitations in bulk and turn on automatic reminders at up to 3 points.
- Choosing "Cannot attend" only records the response; the ticket remains valid.
For wedding invitations, parties and appreciation events, see online invitations and the guide to attendance confirmation.
Check-in status tied to the list
A guest list is only complete when presence status sits in the same place as the other columns. If check-in is recorded in one file and the list in another, the post-event report has to be stitched together by hand.
On Tickmi, the attendee list shows the Checked in count at the top of the page, and can be filtered by status, source and ticket type. When scanning tickets, each ticket can be given Check-ins per ticket; Tickmi does not yet have separate check-in for each session within the same ticket.
Privacy: who can see the guest list?
A guest list contains names, emails, phone numbers and sometimes positions, so only those who need it should see it. A simple principle: ticket scanners do not need to see the whole list; the person who exports the file must be the one responsible.
- On Tickmi, the Check-in staff role can only scan tickets.
- Export data is only for Owners and Administrators.
- Every attendee deletion asks for confirmation, because that person's ticket is lost with it.
Beyond the software, set your own rules: do not send the Excel list through group chat, and delete downloaded copies after the event.
6 questions to ask a guest management software vendor
- What is the maximum number of guests per import and how are errors reported? Best is an error file that points to each row.
- Is there an approval step before tickets are sent? If tickets send automatically on import, you have no chance to review.
- How do you edit guests already imported? Can re-importing a file update existing people, or does it only add new ones?
- Can guests confirm attendance, and who reminds those who have not replied?
- Who can view and export the list? Ask specifically about the gate staff role.
- Which features are not available? For example waiting lists and seating charts. A good vendor answers plainly.
Excel, Google Sheets or a platform: what to choose for guest management?
Excel and Google Sheets are enough for a small list handled by one person; a platform is worth using when you need QR tickets, check-in and several people working at once.
| Criterion | Excel | Google Sheets | Platform (like Tickmi) |
|---|---|---|---|
| Starting cost | Almost none | None | Depends on the package, see pricing |
| Several people editing at once | Easy to get version conflicts | Good | Good, with permissions |
| Permissions for viewing personal data | None | Shared per file, hard to control per column | By role |
| Personal QR ticket per person | No | No | Yes |
| Check-in and presence status | By hand | By hand | Yes, updated instantly |
| RSVP, automatic reminders | No | You have to build it with a form | Yes |
| Suitable scale | Under about 50 people | Under about 100 people | From about 100 people up, or when QR tickets are needed |
If your event has under about 50 guests and one person keeps the list, just use Excel or Google Sheets; you do not need Tickmi yet. When the list has several people editing it or the entrance needs QR scanning, consider a platform. For a deeper comparison see Google Form, Excel or a ticketing platform, and step-by-step operations are in the guide center.
Read next: what features event management software needs.
About Tickmi
Tickmi is a ticketing and attendee experience platform (Ticketing & Participant Experience Platform). On a single, unified set of attendee data, Tickmi connects the whole journey: issuing invitation, registration and paid tickets, sending branded QR tickets, checking in with the app, kiosk or scanner, even when the network is down, then the welcome screen, lucky draw, voting, quizzes and surveys. Tickmi is trusted by organizations such as Viettel, VNPT, MobiFone, FPT and CMC. Learn about Tickmi or try it free.
Frequently asked questions
What columns should a guest list have?
At a minimum: name, email or phone number, group or guest type, source, approval status, attendance confirmation status, presence status and notes. Add custom fields such as table, meal and organization if the event needs them.
Is there a limit when importing guests from Excel into Tickmi?
Yes. Each import is limited to 10,000 rows. Imported people are in Pending approval status and tickets are only issued when you approve them. Error rows are returned in an error file with an added Error column.
Does a second Excel import update guests who already exist?
No. Excel import on Tickmi only adds new people. To change an existing person's information, edit that person directly.
How do I know which guests will come?
Use attendance confirmation (RSVP): each person receives a personal link to choose whether they will come, you set a deadline and turn on automatic reminders. The results are counted right in the Tickets tab of Tickmi Studio.
Can gate staff export the guest list?
No. The Check-in staff role can only scan tickets; only Owners and Administrators can export data.
When is Excel or Google Sheets enough for guest management?
When the event has under about 50 guests, one person handles the list and you do not need QR tickets or real-time check-in.
Issue QR tickets, send emails, check in and engage attendees on one platform.