Step by Step Guide to Importing your Spreadsheet

How do I import my contacts into TouchConvert from a Spreadsheet?

Importing contacts into TouchConvert doesn’t have to be something you need to lean on a TouchConvert team member for assistance with. Whether you already have your contacts in an organized spreadsheet or all over the place, this article will get you in the right place to import your customers (or potential customers) into our platform.

 

Quick 2-minute summary:

 

Preparing and Organizing Your Excel Sheet for Import

  • Organize your data into separate columns (first name, last name, email address, etc.)
  • Add any custom fields you’d like to import into TouchConvert
  • Use the find and replace tool to remove any commas, apostrophes or quotes
  • Save your file as a CSV

Your spreadsheet may look something like this:

Spreadsheet Screenshot | TouchConvert

Notice how all of the contact fields are a header for the column underneath? Be sure to give a header to all of your fields. 

Uploading your file to an Email Campaign

For a New Email Campaign:

From your Dashboard click on Email Campaigns > The Green '+' button > and then under Import a New List click 'Choose File' and search your desktop for the new file.

Importing Contacts to a New Email Campaign | TouchConvert

For Existing Email Campaigns

From your Dashboard, in the right-hand menu click on Email Campaigns. Click on the name of the existing email campaign you wish to add contacts to. In the right-hand panel click on Manage Subscribers > then Import. On the screen a new field will come up that will allow you to 'Choose a File' from your computer.

Importing Contacts to an Existing Campaign | TouchConvert

To Your Contact List

From the Dashboard, in the right-hand panel click on Contacts > then click on Import. A new window will populate and then you choose the file from your computer.


Locate your CSV on your computer. Choose it and click ‘Done’. You’ll then be faced with this data mapping screen:

Please notice. There are three boxes that have a red border around them: First Name, Last Name and Email. 

If you click on “Select first Name” from the dropdown you’ll see something this:

From this menu, you’ll want to match First Name with First Name - Choose First Name for this field. If you’re seeing an actual first name here like “Joe” “Bob” “Alex” or anyone else’s first name in this area – you’re missing the headers on your spreadsheet and will need to go back and add those in.

You’ll continue to map out by selecting the corresponding title to the “Select” title from the dropdown. For example, under “Select Last Name” I’ll choose Last Name, and so on and so forth.

As mentioned above, first name, last name and email are all that are required – so once those have been selected the ‘Done’ button will become green:

Once you click 'Done', a black bar should appear at the top of your browser as a display advising that your contacts were successfully imported.


Do you still have questions on how to import contacts into an email campaign? Still not sure how to import contacts into the CRM? Get in contact with a TouchConvert expert today and we'll be happy to assist you.

Most Recent

Adding Tags on Customers for Sorting

By Dan Carbone
November 16, 2017 Category: Learning

This article covers the proceedure for adding tags on customers records so that you can sort by them and export them into lists. Login to TouchConvert Login to TouchConvert and click on Settings Zoom Contact Attributes Click on Contact Attributes to add new Contact Field Zoom Add a new Field Click on the green plus button to add a new field. Zoom Name the Field Give the new Field a name, such as Tags. You can add other customer Contact Attributes here as well. Zoom New Tags Field is added Now you should see a new Tags field. Zoom View any contact you have Click on View next to any contact to see new field. Zoom New Tags Field Youll see your new input field in the contacts area. Zoom Type your Tags Type as many tags for this customer that you need. You dont need to use a comma if you dont want to. These will become search filters later. Zoom Go to Contacts Zoom Turn on the Tags Field Once you

How to Schedule out Facebook Posts

By Olivia Justice
October 23, 2017 Category: Social Media

Before you can schedule out your Facebook posts with TouchConvert, you will need to connect your Facebook to TouchConvert. Keep reading to learn how to connect your Facebook to TouchConvert: Connecting Your Facebook to TouchConvert Once you are in social you have three networks to start with. The way this area was built is you can create one message and then deploy it to all networks without the need to rewrite it. See the following pages as an example. 1. Connecting to Facebook 1. Click on the Facebook button You will be greeted to your Facebook login. Type your username and password. Click Login at the bottom (You do not need to check-off Keep me logged in). Choosing the Correct Facebook Profile Once you are logged into Facebook. You should see a dropdown with the option to pick your Facebook Profile. If you are a business you will want to consider having a Facebook company page rather than your My main profile page. The reason for this is because

How to create a drip campaign in TouchConvert

By Olivia Justice
September 06, 2017 Category: Drip Campaigns

Drip campaigns are an imporantant kind of customer nurturing that every marketing professional needs. This type of email marketing sends emails to segmented lists on a pre-determined frequency - taking the customer on a journey. The journey begins when the customer is added to the drip campaign. This type of marketing requires a lot of leg work up front, but in the long run increase client retention and conversion. Typically, each email in your campaign could stand alone but collectively, they encourage a specific action (using your service, purchase your product or to warm up the lead). Once youve segmented your list, created the content for your drip campaign and determined the frequency of your messages youre all ready to create your drip campaign. This guide shows you how to set up a drip campaign in TouchConvert. Login to TouchConvert If youre not already logged into TouchConvert, then youll need to login by visiting app.cmobuddy.com . Type in your username and password

Categories
How To (7)
Admin Settings (3)
Email Campaigns (2)
Add Subscribers (1)
Social Media (1)
Drip Campaigns (1)
CRM (1)
Opportunity Stages (1)
Marketing (1)
Drip Campaign (1)
Subscribers (1)
Adding A New Member (1)
Contacts (1)
Importing Contacts (1)
How To Import (1)
Importing (1)
Campaign Statistics (1)
Templates (1)
Learning (1)
+ Show More
Virteom Logo
TouchConvert is a product of Virteom LLC. For more information on Virteom click here.
Have A Question?