ABCDEFGHIJKLMNO
1
#SalutationName PrefixNameName SuffixParty Size AffiliationTableNicknameRemarksOther InfoUser-DefinedUser-DefinedQR IDQR Key
2
0e.g. Dre.g. Jonathane.g. Tane.g. Eng Hocke.g. 1e.g. Bride Familye.g. VIP Tablee.g. Second Uncle
3
0e.g. Mr & Mrse.g. Fadhline.g. bin Akmale.g. 2e.g. Groom NS Friende.g. Bridal Tablee.g. Wife - Violete.g. 1 baby chair
4
0e.g. Mse.g. Mariae.g. Cosuliche.g. and Partnere.g. 1e.g. Groom Ex-colleaguee.g. 27
5
0
e.g. 孙e.g. 启睿e.g. 2e.g. Bride Colleaguee.g. 3e.g. Sun Qi Ruie.g. Vegetarian
6
0e.g. Mre.g. Ivane.g. Fyodoroviche.g. 1e.g. Bride Secondary Classmatee.g. 55
7
1
8
2
9
3
10
4
11
5
12
6
13
7
14
8
15
9
16
10
17
18
General Notes
19
Download this file for editing by selecting "Download" from the "File" menu.
20
Only the column headers in bold (D - name, F - party size, and H - Table, if your event has seating) are required. You can leave the rest blank.
21
If you have an existing spreadsheet with columns laid out in a different order, simply rename your headers to match ours.
22
Note on name columns (B, C, D, and E):
23
We split names into four parts — salutation, prefix, name, and suffix. This is to allow sorting by name parts.
24
If you want to be able sort by surname on the iPad, put the surname under "Name" (column D) and put the other name parts in the other columns,
25
depending on whether they appear before or after the surname. The examples from above are repeated below:
26
27
DrJonathanTanEng Hock
28
Mr & MrsFadhlinbin Akmal
29
MsMariaCosulichand Partner
30

启睿
31
MrIvanFyodorovich
32
33
If you don't need to sort by parts of a name, you can just enter the whole name into "Name" (column D) and leave the rest of the columns (B, C, E) blank:
34
Dr Jonathan Tan Eng Hock
35
孙启睿
36
37
Note on affiliation (column G):
38
This column can be displayed under the guest's name, or it can be hidden and just be searchable.
39
For example, you can enter "Bride's Family", and any search for the word "family" will show these guests.
40
Note on user-defined columns (columns I to M):
41
These columns can include any data here that your receptionists might search for. We can optionally display this information under each guest's name as well.
42
For example, under "nicknames", enter names of guests that they might use which you might not display. E.g. "Ah Ma", or names of spouses, or pinyin translations of Chinese names
43
You can change the column headers to anything of your choosing, to help in your planning.
44
Note on QR columns (N and O):
45
These will be automatically generated. No need to fill anything in here.