undefined - Email Marketing - Import Contacts to an Audience - illustration 06a6cdda-2e0c-4345-a3de-6be30f5393ad

Email Marketing - Text File (CSV) Import Contacts into an Audience

If you want to import many contacts from another source, for example, a CRM, Spreadsheet, or accounting package, using a text import file (CSV format) is an easy method to complete this task.

The following tutorial describes the process to complete an import of contacts into an audience.

Step1: Navigate to the Campaigns section in the left toolbar, and then select the Audience option in the top menu.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Email Marketing - Import Contacts to an Audience - illustration 665fc1e3-6d23-40b1-8ec7-732e8f3117f5

Step 2: Click on the arrow to show the Action dropdown menu options for the Audience you would like to import contacts. Then click on the Import option.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Email Marketing - Import Contacts to an Audience - illustration e43dd308-61d4-48c3-a893-f2b8d5067e82

Step 3: Click on the Select File button, now select a file from your computer hard drive or network drives, or simply drag and drop your data

The CSV file will need to be in a specific format; if you do not know the correct format, you can download a sample import file using the Download Sample CSV File. This sample file will give you the correct order of data columns in your import file. 

Please make sure that the contact import file you have prepared matches the sample you can download.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Email Marketing - Import Contacts to an Audience - illustration 41c6bb71-256b-4788-ba7b-92d3c89290af

Step 4: You will be prompted to Map Data Items. You can use your previously saved settings, manually match, or click Auto Matching. You can save these settings later in this process.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Email Marketing - Import Contacts to an Audience - illustration 35bedc94-95e2-4889-8682-33f4ac58a558

The data columns are as follows:

Email Address: the email address of the contact
First Name: the first name of the contact to be imported
Last Name: surname of the contact to be imported
Tags: if the contact is to be allocated, tag list them in the column, as tag is used to segment contacts in an audience, e.g. gender, age group, location, etc
Company Name: the company name of the contact
Phone Number: the phone number of the contact to be imported
Mobile Phone: mobile number of the contact to be imported
Address: the address of the contact
Email Marketing: the value must be "Subscribed" if you would like the contact to be in the correct status to receive emails in a campaign.
Contact Rating: enter values 1 to 5 to rate the importance of this contact in your campaign
Date Added: enter a date in the following format yyyy-mm-dd

Enter text here to see it on your site...

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Email Marketing - Import Contacts to an Audience - illustration 0161340d-6f20-4636-bbbc-2e53610a272f

Step 5: Choose whether you would like to leave as is, delete, or override your previous data upon import.

Click Yes, Import Now to start importing.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Email Marketing - Import Contacts to an Audience - illustration ad2cd8fd-b86d-408d-9c13-6634e02dcca3

Your contact data is successfully imported into QuoteCloud. A message displays with a success notification and the number of records imported.

If there is a problem with your import file, then QuoteCloud will attempt to advise you of the problem, and you can alter your file data and try again.

If you continue to have issues importing your product data, you can contact the QuoteCloud Support Team. Click on the Account menu, and then select Email Support.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Email Marketing - Import Contacts to an Audience - illustration 323290ee-16a8-4b79-a2d3-67e3d9be5642

To help streamline your import process in the future, you are given the option to save your data mapping. 

To do this, enter a name that clearly articulates what the mapping is used for in the New mapping name field, then click Save

If you don't need to save the mapping, simply click Cancel and you will be taken back to the Audience screen.

QuoteCloud - Sales Quote, Sales Proposal and Contracts Software - Email Marketing - Import Contacts to an Audience - illustration 97186e39-1f77-4516-97ef-fe19061fcb7c

Related User Guide Topics