Introduction

Managing a large address book can be challenging, especially when entering contacts one by one into a new system. Artshell simplifies this process by offering two efficient solutions for importing your contacts:

• • Concierge service: our team of experts will take care of the entire import process for you. Click here to learn more about the Concierge service.
  • Advanced Import: a tool that allows you to import contacts in bulk by uploading an Excel file directly into the Artshell database.

Whichever option you choose, it is essential to remember that a well-structured and professional address book is one of the keys to your organisation’s success. Take this opportunity to carefully review the contacts you want to keep in the Contacts section of Artshell:

• remove those you know are no longer active;
• check that there are no typos in email addresses (as these would otherwise be invalid);
• ensure that first name, last name and company details are entered correctly.

The Contacts section of Artshell is closely connected to the Email and Newsletter section, which allows you to send communications to your recipients within the same environment. This is extremely convenient, but it also requires careful attention: if, for example, you use personalised greetings such as Hello #name or Hello #company, you must ensure that the corresponding fields have been filled in correctly. Otherwise, you risk unprofessional results, such as Hello [empty field] (if the data is missing) or Hello Tina instead of Hello Antonia, if the contact was saved inaccurately or too hastily.

This article provides a step-by-step guide for using the Advanced Import feature.

Step 1: Download and fill out the contact import file (Excel)

Below is the Excel template you can download and fill out.

Download the Excel template for contact import below:

The file is also available for download directly in the Artshell platform on the Settings panel () by selecting Import > Contacts > download Excel template.

Once downloaded, follow these steps:

Open the file in Excel.
The file contains a header row (DO NOT edit the headers) and a second row with example data. The header row is colour-coded based on the type of contact information to assist you during compilation.

1. Take a moment to review all the columns in the file. If there are any that are not relevant to your needs, you can either leave them blank or delete them entirely.
2. Fill in one row for each contact. Fields that don’t apply to certain contacts can be left blank — they simply won’t be imported. If a field is only useful for some contacts, you can leave the cell blank for the others: it will not be imported into their file. Finally, some fields require specific configuration to be imported correctly.
   Below you will find instructions on how to fill in each field.
   
   

   Detailed instructions for each field

   First name	text
   Last name	text
   Company	text
   Contact type	text
   Role	text
   Tags	text – separate with commas
   Email label	text – must match predefined options
   Email	text/number
   Phone label	text – must match predefined options
   Phone number	number
   Address label	text
   Street address	text/number
   City	text
   Postal code	number
   Province/Region/State	text
   Country	text, from the country sheet
   Link label	text – must match predefined options
   Website	URL
   Legal name	text
   Billing street address	text/number
   Billing postal code	number
   Billing city	text
   Billing province/region/state	text
   Billing country	text, from the country sheet
   VAT number	number
   Tax code	text/number
   Billing email	text/number
   Nationality	number, from nationality sheet
   Day of birth	number
   Month of birth	number
   Year of birth	number
   Notes	text/number

3. Save the file in XLSX format, and rename it as needed. Do not save it in any other format — the system will not be able to process it.

Step 2: Import the contact file (Excel)

Once your file is ready and free from filters or formatting, follow these steps:

1. Click the Settings panel icon () at the bottom left.
2. Select Import > then select Contacts.
3. Click Browse and select the file from your computer.
4. Click Import and wait for the upload to complete — the time depends on the number of contacts and your internet connection. 

At the end of the import, the system will show a summary:

• Contact imported:
  Number of new contacts successfully added.
• Contacts merged:
  Number of contacts matched with existing ones in your database. New data is added to existing profiles. Learn more in the next section in this article.
• Errors:
  Number of rows not imported due to errors in the file.

Subsequent imports

You can perform additional imports using Excel to expand your contact list.

If you wish to continue with more imports, there are some very important points to keep in mind:

Key rule: the email address is the unique identifier

During import, the system uses the email address to check if a contact already exists.

If a contact's email is already in your database, Artshell will:

1. Fill in empty fields with the Excel data.
2. Add tags that aren’t already present.
3. Add new phone numbers, emails, and addresses that aren’t already listed.
4. Ignore fields already filled in the contact profile (except for tags, emails, phone numbers, and addresses — these are added).