# Import guests from a spreadsheet

> Upload guests, review plus-ones and private groups, and save profile details for guests to confirm.

- Where: Event → People → More → Import guests
- Console path: https://aaa.attend.vip/{org}/{event}/people
- Do first: [Create your event](https://www.attend.vip/help/organizers/create-event.md)
- Updated: 2026-11-11

Import a guest list with plus-ones, attendee groups and details from a previous event. The wizard saves guests as **Draft**. It does not send invitations or change anyone's RSVP to confirmed.

## Download a template

[Download the Excel template (.xlsx)](https://www.attend.vip/help/downloads/attend-guest-import-template.xlsx) or [download a blank CSV template](https://www.attend.vip/help/downloads/attend-guest-import-template.csv).

The Excel template is unprotected and ready to edit. It has three sheets:

- **Guests**: the blank sheet to fill in with your own guest list. Keep the column headings in row 1.
- **Example guests**: eight fictional people showing hosts, plus-ones, dietary details and group columns. Use it for reference, not for your real import.
- **Instructions**: guidance for the columns.

The five screenshots below use the fictional **Willow Bay Retreat** event. All guest names, companies, emails and phone numbers are examples.

## Before you upload

Use **CSV, XLS or XLSX**, up to **2 MB** and **2,000 people**. You can use your own column headings and map them in the wizard.

- Give each person a name and a valid, unique email address. Each plus-one needs their own row and email too. Resolve missing emails before importing those people; don't invent delivery addresses.
- Give each row a unique **Source ID**, and keep it the same on future uploads. It identifies the person even if the spreadsheet order changes.
- In **Guest Of**, enter the host's full name as it appears in the file. **Relationship to host** is optional.
- Use a group column such as **VIP Access**. Use an explicit value such as **Yes** for membership; a blank cell is not a yes.
- Keep uncertain information as a note. A historical allergy or dietary preference still needs the guest's confirmation.

### If the workbook has a password

Open it in Excel with the password, remove the password-to-open protection, then save a new unprotected `.xlsx` copy locally. Upload that copy. The browser importer cannot open encrypted workbooks.

## 1. Upload and choose the worksheet

1. Open your event's **People** page.
2. Open **More** (**⋮**) and select **Import guests**.
3. Choose or drop your spreadsheet into the upload area.
4. Choose the **Worksheet** containing your guest rows. With the template, choose **Guests** after filling it in.
5. Set **Header row** to the row containing the column names. Use **Read row** if you change it. The template uses row **1**; your own file may have titles above the headings.
6. Check the row count, then select **Continue**.

![The upload step with the fictional Example guests worksheet selected and eight rows found](https://www.attend.vip/help/img/organizers/guest-import-upload.png)

## 2. Map the columns

Check each source column against the Attend field it will fill. Common headings are matched automatically. Map either **Full name**, or **First name** and **Last name**, plus **Email**.

You can also map preferred names, company, job title, mobile, dietary requirements, food allergies, dietary notes, apparel size, accessibility and emergency contacts. Leave fields you don't have as **Not mapped**. A source column can map to only one field.

Set a **Stable import ID** for this guest list, such as `willow-bay-retreat-guests`. Reuse it and the same Source IDs when retrying or importing the same list again. Without a Source ID column, row numbers are used, so keep the row order unchanged.

**Keep unmapped columns as organizer-supplied reference fields** preserves extra source information. For example, an old RSVP column can remain reference data; it does not confirm the guest in Attend.

If you've previously downloaded a mapping, use **Load saved mapping**. Check the worksheet and header row as well, and review host and contact decisions again.

Select **Continue**.

## 3. Review the plus-one hosts

Choose the **Host-name column** and, if present, the **Relationship column**.

An exact, unique host name is selected automatically after allowing for differences in spacing and capitalization. Attend does not guess nicknames or ambiguous names. For each unresolved row, choose the correct host explicitly, or choose to leave that relationship unlinked.

In the example, Jordan Vale is linked to Avery Lane, and Taylor Brooks is linked to Morgan Reed. A plus-one cannot also host another plus-one. If you skip a host later, review the dependent plus-one again.

![Reviewing Jordan Vale and Taylor Brooks against their fictional hosts](https://www.attend.vip/help/img/organizers/guest-import-plus-ones.png)

Select **Continue** once every host decision is resolved.

## 4. Choose which columns create groups

Select **Add a group from a column** for each attendee group you want to create. Choose its **Source column**, enter the **Group name**, and tick the exact values that mean membership.

For example, choosing **VIP Access** and including **Yes** adds only the people whose VIP Access cell is Yes. The preview shows the member count before you save.

![The VIP Access column configured as a private group with three members](https://www.attend.vip/help/img/organizers/guest-import-groups.png)

New groups created by this import are **private, manual attendee groups**. You can also intentionally create a group with zero members. Group membership does not book an activity or create a schedule RSVP.

If groups already exist, select their destinations at **Matches**. The import adds the selected members; it does not remove people who are already members.

## 5. Review existing contact matches

The **Matches** step checks Source IDs and email addresses. It shows how many rows are new, matched and selected.

- For a new person, leave **Create contact + draft guest** selected.
- For an existing contact, explicitly choose the matching contact or **Skip this row**. Linking keeps that contact's existing name, email, phone and company.
- Skip an existing active guest. The import does not replace their RSVP status.
- For each group, choose **Create / reuse this import's private group**, or select the existing private group you want to add people to.

Review every decision, then select **Continue**.

## 6. Review and import drafts

Check the people count, plus-one links, group counts and profile warnings. Values that don't match a supported dietary option are kept in notes; review those notes before relying on them.

![Final review showing eight draft guests, two plus-one links and three VIP Access members](https://www.attend.vip/help/img/organizers/guest-import-review.png)

1. Tick **I have reviewed the host matches, cohort membership and profile warnings. Import as drafts without sending invitations.**
2. Select **Import drafts**.
3. Wait for the completion message with the saved people, profile, plus-one and group counts.
4. Select **Done**, then spot-check the guest records.

You can select **Download reusable mapping** at Review to reuse your column and group configuration next time. It does not replace the spreadsheet or save your host and contact review decisions.

## Check imported profile details

Open a guest record on **People**. Imported dietary requirements, allergens and notes appear in **Dietary**, with an **Organizer Imported** pill and a reminder that the guest has not confirmed them for this event.

![Jordan Vale's fictional profile showing a dairy-free diet, milk allergy and the Organizer Imported pill](https://www.attend.vip/help/img/organizers/guest-import-profile.png)

The imported details prefill the guest's relevant forms. When the guest confirms a field, their answer replaces its superseded imported value. The **Organizer Imported** pill disappears when their dietary details are confirmed for this event. An explicit answer of no restrictions wins too. Unrelated imported fields, such as shirt size or emergency contact, stay on file until those fields are updated.

Sending invitations is a separate action. When the guest list is ready, follow [Send invites](https://www.attend.vip/help/organizers/send-invites.md).

## Retry or re-import the same list

Keep the same **Stable import ID** and **Source IDs**, load the saved mapping if you have one, and review the current matches again. Existing draft guests can be reused without creating duplicates. Existing contact identity details and active guest RSVP states are preserved.

If an import stops part-way through, earlier stages may already be saved. Retry the same file and configuration, reviewing the saved records and matches, rather than deleting people and starting over. Don't change IDs during a retry.
