Help CentreGetting started Importing existing data into SupercontrolHow can I import all my guest details into SuperControl?

How can I import all my guest details into SuperControl?

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

First name Character

Last name Character

Email address

Address line 1

Address line 2



Post code

Two letter ISO country code
You must use the appropriate  "ALPHA 2" ISO country code. Click here to find the correct code.
Alt Telephone
Mobile telephone
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



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.



Please give an excel spreadsheet example, as the data could not be presented in a vertical column. Surly this is a horizontal line of column?

Rosie Georgeson

Hi there,

The fields names above would be column headers in an excel spreadsheet. I have included a screen shot in the above article to allow you to see the layout.

Kind regards

Heather Trappe

I am saving the country code as GB and it does not seem to registering it - it changes to the UK

Tobias Parker

Everything in our database is under GB. You just need to add it as GB and understand that it will revert to UK on the front end. This is not a problem- but the system needs the GB code to upload correctly.

How can we make this page better for you?

E-Mail me when someone replies to this comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.