From Excel to a Live Guest List: Paste Your Whole List at Once
Most families already have a guest list somewhere: a spreadsheet, a notes app or a long WhatsApp message from an aunt. Typing it again guest by guest is the main reason families give up on guest management tools.
Paste, do not retype
In the Guests tab of your wedding admin, the Add many guests at once box accepts a whole list at once, up to 500 lines at a time. Each line becomes one guest with their own entry pass.
Formats that work
Put one guest or household on each line, with the details separated by commas. Rows copied from Excel or Google Sheets work as they are, because their columns are separated by tabs. Only the name is required.
- Sunita Verma, 9876543210, 4, bride
- Rahul Mehta, +91 98765 43210, 2 guests, groom’s side
- 12. Kapoor family, 5, friend
- Dadi ji
How each line is read
The name is the first part that contains letters. A phone number has six or more digits, the party size is a number from 1 to 20, and the side can be written as bride, groom or friend, or as ladki or ladka. The order does not matter, and anything else on the line is kept as a note. Numbering from a list, such as “12.”, is removed.
Duplicates are handled
A guest pasted twice is updated rather than given a second pass: the same phone number, or the same name without a number, is treated as the same guest. Lines without a readable name are skipped and listed for you to check.
Mark a group as arrived
When a group arrives together, such as a bus from the hotel, paste their names with Mark all as arrived ticked, and they are added and checked in at once.
Keep Excel for planning
Many families plan in a spreadsheet and paste the final list a few weeks before the wedding. Afterwards, the admin downloads the list back to Excel. Our guide to guest list management covers building the list in the first place.
Frequently asked questions
How many guests can I paste at once?
Up to 500 lines at a time. For a longer list, paste it in parts.
What if my columns are in a different order?
It usually still works, because names, phone numbers, party sizes and sides are recognised by what they look like rather than by their position.