Example import formats

<< Click to Display Table of Contents >>

Navigation:  PerfectTablePlan 5.3.4 > Reference > Importing >

Example import formats

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

1_name_per_1_col_m

arrow

1_name_per_m_col_out_m

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 more_button_m 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

1_name_per_m_col_m

arrow

1_name_per_m_col_out_m

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 more_button_m 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

m_name_per_1_col_m

arrow

m_name_per_1_col_out_m

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

m_name_per_m_col_m

arrow

m_name_per_1_col_out_m

The guests will all be placed into a single group.

If you have multiple names in multiple separate columns you can click on the more_button_m button and use the Join feature to convert them to multiple guest names per row in a single column.

m_name_per_m_col_join_m

arrow-down

m_name_per_m_col_join_2_m

arrow-down

m_name_per_m_col_join_3_m

They can then be handled as multiple guest names per row in a single column.

Column for number of additional guests

1_name_per_1_col_and_n_add_m

arrow

1_name_per_1_col_and_n_out_m

The guests will all be placed into a single group.

Column for number of total guests

1_name_per_1_col_and_n_total_m

arrow

1_name_per_1_col_and_n_out_m

The guests will all be placed into a single group.

If you get really stuck on this, contact support.

See also:

Import non-English characters