Example import formats

<< Click to Display Table of Contents >>

Navigation:  PerfectTablePlan 6.0.0 > 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. We recommend setting up common titles and suffixes in the prefs_16Preferences window before importing.

A single guest name per row in a single column

1_name_per_1_col_w

arrow

1_name_per_m_col_out_w

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_w button and check single guest per cell.

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_w

arrow

1_name_per_m_col_out_w

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_w button and check single guest per cell.

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_w

arrow

m_name_per_1_col_out_w

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_fullnames_per_m_col_w

m_multipart_names_per_m_col_w

arrow

m_name_per_1_col_out_w

The guests will all be placed into a single group.

Column for number of additional guests

1_name_per_1_col_and_n_add_w

arrow

1_name_per_1_col_and_n_total_out_w

The guests will all be placed into a single group.

Column for number of total guests

1_name_per_1_col_and_n_total_w

arrow

1_name_per_1_col_and_n_total_out_w

The guests will all be placed into a single group.

If you get stuck on importing, contact support.

See also:

Joining and splitting columns

Import non-English characters