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

How To Build an Email Campaign

By Olivia Justice
February 07, 2019 Category: Email Campaign

Below is a video and an article on building your own email campaign in TouchConvert. Below are Step by Step Instructions IMPORTANT: Make sure you added the DNS settings inside of your DNS manager to start to send emails. If you have not done this or get a message that mail cannot be sent from TouchConvert, this is because your DNS settings have not been added. Simply contact us to get the settings if need be. Email campaigning is used for news and informational events that need to be released on a very specific date and time. For example you could use this feature to create news letters, announcements to certain groups of customers and even invitations and surveys. Click on Email Campaigns to start to build a campaign. Email Campaign Overview Once you are inside of your campaign you should see a list of campaigns that youve already created. If this is your first time in this area then it will be blank. To add an email campaign click on the Plus button. To edit a campaign

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

Virteom Logo
TouchConvert is a product of Virteom LLC. For more information on Virteom click here.