# Bulk Importing Guests from Excel or CSV

If you already have your guest list in a spreadsheet, you can import it directly into AisleList instead of adding guests one by one.

**Supported file formats:** `.xlsx`, `.xls`, and `.csv`

***

#### Step 1 — Upload your file

1. Go to **Guest List**
2. Click the **Import** button in the top right
3. Either **drag and drop** your file onto the upload area or click to browse and select it

If you don't have a file ready, click **Download Template** to get a pre-formatted Excel file with the correct columns and example data.

***

#### Step 2 — Map your columns

AisleList will read the headers from your file and attempt to auto-match them to the correct fields. Review the mapping and adjust any columns that were not detected correctly.

**Available fields to map:**

| Field              | Required | Description                                 |
| ------------------ | -------- | ------------------------------------------- |
| **Full Name**      | Yes      | Guest's full name                           |
| **Salutation**     | No       | Mr, Mrs, Ms, Mr & Mrs, Dr, Rev              |
| **Contact Number** | No       | Phone number                                |
| **Group**          | No       | Group or family name                        |
| **Adults**         | No       | Number of adults in the party               |
| **Children**       | No       | Number of children in the party             |
| **Is Family**      | No       | Yes / No — marks the guest as a family unit |

Click **Next** once your columns are mapped.

***

#### Step 3 — Review and import

A preview of all guests to be imported is shown. Any rows with errors (e.g. missing name) or warnings (e.g. unrecognised salutation) will be highlighted.

Click **Import** to begin. A progress bar will track the import and once complete a summary will show how many guests were successfully imported.

***

> **Tips:**
>
> * Unrecognised salutations will be left blank rather than blocking the import
> * Phone numbers starting with `0` are automatically formatted to the Sri Lanka country code (`+94`)
> * New groups are created automatically if a group name in your file does not already exist


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://aislelist.gitbook.io/aislelist-docs/guest-list/bulk-importing-guests-from-excel-or-csv.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.