Help Centre

How can I import all my guest details into SuperControl?

Updated on

If you’re new to SuperControl and you want to import your guest database into SuperControl follow these steps. The document should be created in Excel which will allow you to save the file in the correct format.

1. Ensure your data is formatted to the exact requirements from the table below.

  • The columns should match and be listed in the same order as below.
  • The columns must be filled in as much as possible. If any columns are blank you will need to add a blank space.
  • You must use a specific data type for the ISO country codes and Subscribed fields. See notes below.
Field name Data type Notes
Title
Character

First name Character

Last name Character

Email address
Character

Address line 1
Character

Address line 2
Character

Town/City
Character

County/Region
Character

Post code
Character

Country
Two letter ISO country code
You must use the appropriate  "ALPHA 2" ISO country code. Click here to find the correct code.
Telephone
Number
Alt Telephone
Number
Mobile telephone
Number
Subscribed Enter the subscription ID. If multiple subscription options have been ticked, they can be separated by a comma eg. 123, 456
You can find your subscription options within "Admin subscription options".

If you haven't added these before your import make sure you add them first so you can obtain the ID's required for the import.
Your ref
Character

Source
Character

Example:

Note: You should NOT include the column headings, these are shown in the example for clarity.

2. Once you have your spreadsheet formatted correctly go to File > Save as > From the “Save as type” drop down select Text (Tab delimited) and click Save.

3. In SuperControl go to Database > Import records.

4. Click Choose file and select your Tab delimited file and click Open.

5. Click Upload.

6. Click Proceed with Import.

7. If you don’t receive any errors then you have successfully imported your guest records.

Previous Article How can I import bookings into SuperControl?
Next Article Going Live with SuperControl