9. Import guests

<< Click to Display Table of Contents >>

Navigation:  Getting started > Tutorial >

9. Import guests

You can import guest details from spreadsheets, databases and other formats, so that you don't have to re-type them. We will illustrate this by importing some guest details from Excel. The principles are similar for other applications and file formats.

Note The user interface of Excel may differ between different versions.

Create a simple Excel spreadsheet like the one below and save it:

import excel guest list

Create a new plan by selecting File>New.

Select File>Import. The import_16Import window will appear.

import guest list window

Ensure Excel/CSV/text file is selected and click the OK button. An Open window will appear. Navigate to the .xls/.xlsx/.csv file you just created and click Open. If a .xls/.xlsx file has multiple tabs you will be asked to choose one. You should now see the contents of the Excel file in the import_16Import Data window.

import guest properties

Tell PerfectTablePlan which columns correspond to which guest properties and to ignore the first row, as shown below.

ignore rows

Note that you can edit the data in the table before you import it. This will not affect the original .csv file.

Click the Next> button (if you want to change anything you can then click <Back ).

Click OK. If you are prompted to Save this import mapping to use again? click Don't save. The guests should now be imported as below.

guest list imported

If it has imported anything incorrectly you can easily change it in Edit mode or Edit>Undo the import.

edit guests

The email address has been added to the group contact information. This is shared by everyone in the group.

Click the group_16Groups tab to see how guests have been placed into groups.

guest groups

If you don't like how they have been grouped you can easily drag guests between groups in Drag and drop mode in the group_16Groups pane. E.g. You can drag Miss Erica Black into the same group as Mr Alan Black.

If you look in the heart_16Proximity pane you will see it has set default proximities for the guests in each group according to the settings in the Proximities tab of the prefs_16Preferences window.

If you are importing data in a format PerfectTablePlan already knows about, you can select the format from the File type menu in the import_16Import Data window:

import file types

Click on the more_button_w button in the import_16Import Data window to show additional options. These options give you full control over how the import file is interpreted. For example you can specify that columns in the import file are separated by Tab characters, rather than commas:

input file format

PerfectTablePlan can import complex guest lists with multiple guests per row in one multiple columns, including addresses, meal choice, VIP status, RSVP status etc. . See example import formats for more details.

You can also import guest name data using the simpler (but less flexible) scratchpad_16Quick Add Guests window.

You can also import guests from any application that supports vCard format. This includes many email and address book applications. Just drag the guest vCard(s) onto the PerfectTablePlan unknown_adult_16Guests pane.

Next: 10. Check-in guests >>