If your guest list has been sitting in a spreadsheet for ages, there is no need to type it out again. With the CSV import it moves into your event in one go. And if you need it the other way round for the seating plan or the caterer, you can download it again whenever you like. Both are free.
Preparing your file
Open Gäste (guests) and click „Importieren" (import) in the filter bar. In the dialog „Gäste importieren" (import guests) you first download the template gaeste-beispiel.csv through „Beispiel-CSV herunterladen" (download sample CSV). Open it in Excel, Numbers or Google Sheets, enter your guests and save it as a CSV again.
Required columns: Vorname, Nachname (first name, last name)
Optional columns: E-Mail, Telefon, Gruppe, Haushalt (email, phone, group, household)
The English headings firstname, lastname, email, phone, group and household are recognised as well.
Commas and semicolons both work as separators, and values may be wrapped in quotation marks.
In the Gruppe column you write the group name as text, for example „Familie Braut". Values that are not recognised end up in „Andere" (other) automatically.
Uploading the file
Drag your file into the field „Ziehen oder klicken zum Hochladen" (drag or click to upload) or pick it through „CSV-Datei auswählen" (choose CSV file).
Have a look at the preview. At the top you see how many valid guests were recognised, and next to it, if it applies, how many rows are invalid. The reasons shown are „Vorname fehlt" (first name missing), „Nachname fehlt" (last name missing) or „Ungültige E-Mail" (invalid email).
If everything looks right, you click „N Gäste importieren" (import N guests). Invalid rows are simply skipped.
If something is off, remove the file with the X, correct it and upload it again.
The preview shows ten rows at most, the rest appears as „Und N weitere..." (and N more) below it. All valid rows are imported, of course.
Good to know: There is no duplicate check. If you upload the same file twice, every guest will be in your list twice. When in doubt, import once and add the rest by hand.
There are two things the import deliberately leaves out: the toggle „Plus One erlauben" (allow a plus one) is off for all imported guests, and internal notes stay empty. You fill both in afterwards for the guests where you need them.
Downloading your guest list
Click „Exportieren" (export) in the filter bar. You get the file gaesteliste.csv with these columns: Vorname, Nachname, E-Mail, Telefon, Gruppe, Status, Haushalt. Companions that were added automatically appear as their own rows in it. And there is something new: every child that has been signed up gets its own row too, with „Kind" (child) in the Gruppe column. The last name, the status and the household come from the guest it belongs to. For the catering and the seating plan you have everyone in one single table. As long as you have not added a single guest, the button is greyed out.
Good to know: The export always contains all of your guests. The search and the status and group filters only affect what you see on screen, not the file you download. Details from the replies such as dietary needs and allergies are not included.
Frequently asked questions
I cannot see the buttons „Importieren" and „Exportieren".
They are hidden on phones, where only „Gast hinzufügen" (add guest) stays. For importing and exporting, sit down at a computer or a tablet for a moment.
My file is being rejected.
Only real .csv files are accepted, otherwise you see „Bitte nur CSV-Dateien hochladen." (please upload CSV files only). The file also needs a header row plus at least one row of data, and the columns „Vorname" and „Nachname". In your spreadsheet program, save it through „Export" or „Save as" in the CSV format.
Can I use the import to update guests I already have?
No, the import always creates new guests. You make changes to existing guests through „Bearbeiten" (edit).