Importing guests
Learn how to quickly upload your entire guest list from a CSV file with automatic creation of groups and households based on your spreadsheet data.
Already have your guest list in a spreadsheet? You can import it into WedSites using a CSV file. This is the fastest way to get a big list into the system.
How to import
- Go to Guests in your main navigation
- Click the Upload button at the top of the page
- Click Select file and choose your CSV file
- Click Continue
- WedSites will process the file and add your guests
Getting your CSV ready
Your CSV file needs at least a First name column. Everything else is optional.
Download the template
Not sure how to format your file? Click Download sample on the import page to get a pre-formatted CSV template. Just fill it in and upload.
The template download link is at the bottom of the import page, labeled "Download sample."
Supported columns
Here are all the columns WedSites recognizes:
| Column name | What it does |
|---|---|
| First name | Guest's first name (required) |
| Last name | Guest's last name |
| Email / E-mail address | Guest's email |
| Phone / Telephone number | Guest's phone |
| RSVP / Status | RSVP status (Confirmed, Unconfirmed, Declined, Shortlisted) |
| List | A or B |
| Side | Matches your partner names or "Both" |
| Dietary / Diet | Dietary requirements |
| Age | Adult, Child, or Infant |
| Group | Group name (creates the group if it doesn't exist) |
| Household | Household name (creates if it doesn't exist) |
| Address | Household address |
| Country | Country code for the household |
| Notes | Internal notes |
| Pluses / +1 | Plus-one (1, +1, yes, y, allowed, ok) |
| Children / Kids | Allow children RSVP (1, +1, yes, y, allowed, ok) |
| Language code | Preferred language code |
Column names aren't case-sensitive, and WedSites recognizes common variations (like "Email" and "E-mail address" both work).
What happens during import
- Guests are created with the info from your CSV
- Groups mentioned in the CSV are created automatically if they don't exist
- Households mentioned in the CSV are created automatically if they don't exist
- Address and country info is attached to the household
Tips
Start with the template. It's the easiest way to make sure your columns are right.
Clean up your spreadsheet first. Remove any extra rows, blank rows, or header notes that aren't part of the data. Just column headers and guest data.
Check after importing. Take a quick look through your guest list after importing to make sure everything looks right. You can always edit individual guests if something needs fixing.
Duplicates aren't merged automatically. If you import a guest who's already on your list, you'll get a duplicate. Use the merge feature to combine them.