Spreadsheets and CSV files can be supplied with guest data organized into columns in a multitude of different ways. Below we give examples of some of the more common formats and how to deal with them.
A single guest name per row in a single column
|
|
|
If you have commas, the word "and" or other things that might be interpreted as there being more than one name in a column, then you should click on the 
button and check single guest per row.
If you want to import multiple guests per group you should add a group column.
A single guest name per row in multiple columns
|
|
|
If you have commas, the word "and" or other things that might be interpreted as there being more than one name in a column, then you should click on the button and check single guest per row.
If you want to import multiple guests per group you should add a group column.
Multiple guest names per row in a single column
|
|
|
Various naming formats are handled, including:
Mr & Mrs John Smith
John Smith, Jane Smith
John and Jane Smith
Mr John Smith + 1
The guests will all be placed into a single group.
Multiple guest names per row in multiple columns
|
|
|
The guests will all be placed into a single group.
If you have multiple names in multiple separate columns you can click on the button and use the Join feature to convert them to multiple guest names per row in a single column.
They can then be handled as multiple guest names per row in a single column.
Column for number of additional guests
|
|
|
The guests will all be placed into a single group.
Column for number of total guests
|
|
|
The guests will all be placed into a single group.
If you get really stuck on this, contact support.
See also: