Skip to main content
← All guides

Import your guest list from a spreadsheet

Last updated 26 September 2026

Already have a guest list in Excel or Google Sheets? Don't retype it. Save it as a CSV and bring it into Guests in one pass.

Prepare your file

Mangalyam reads a CSV file (comma-separated), not an Excel (.xlsx) or Google Sheets file directly. In Excel or Google Sheets, use File → Download (or Save As) → CSV first.

Open the guest options menu (the ⋯ button next to Guests) and choose Download template. The template is made for your wedding: after the guest columns it has one column for each of your events, named the way they appear on your Guests page.

Name, Phone, Email, Side, Relationship, VIP, Notes, Haldi, Wedding Ceremony, Reception

Only Name is required. For Side, use "Bride", "Groom", "Mutual" or "Both". Matching ignores case, and a blank or unrecognised value is imported as Mutual. For VIP, use "yes", "y", "true" or "1".

In each event column, write how many people are coming to that event, counting the guest. 1 means just them, 4 means a family of four, and a blank or 0 means not invited. yes or x also works for one person. The most you can enter per event is 21.

Add your events before you download the template. If you add an event later, download a fresh template to get its column.

Import and check the preview

  1. From the same ⋯ menu, choose Import CSV and pick your file.
  2. Mangalyam matches your headers automatically, including the event columns. "Full name" or "Mobile" work as well as "Name" or "Phone", so you don't need to match columns yourself. Columns it doesn't recognise are listed and ignored, and rows with an unrecognised Side value are flagged before you import.
  3. Check the preview. It lists which events it found and how many invitations it will create, and flags any event cell that isn't a number of people. Then confirm.

Rows with no name are dropped. A row whose phone number exactly matches a guest already on your list is skipped as a duplicate. The match is exact, so the same number typed with different spacing or without the country code won't be caught.

After import

The guest list refreshes with everyone added and already invited to their events, with the headcount you entered for each. The event strip above the list updates to match.

One import takes up to 1,000 rows. Split a larger list into batches.

Duplicate checking only compares phone numbers, not names. A guest without a phone number can't be checked against your existing list, so look over the preview before you confirm.