Advanced Training: Admin

Importing Data

Importing data to is a straightforward task, most often done by taking a spreadsheet file in .CSV format and uploading it into the system.

You can also import data automatically through's Web service back end, but this option will be covered in more detail later. This section focuses solely on uploading data via spreadsheet.

The data import function is available from two areas of the site, the Admin tab and from the Campaigns tab. In terms of functionality it makes no difference whether you initiate the import from the Admin or Campaign tab; the only difference is that if you import a through a Campaign, the records are automatically assigned to that campaign when they arrive.

Click to view larger image.

Click to view larger image.

Notice that from the Admin tab you can import accounts, deals/opportunities, and calendar events as well, but for purposes of the ISCA Certification, you'll only need to worry about importing Leads.

Unless you have a reason not to, we to assume that Sysadmins will typically run an import from the Campaigns tab, for a couple of reasons:

  1. By assigning sets of data to campaigns, it makes it much easier to track, sort, and report on the data later on, and
  2. If something were to go awry during a data import, it makes it easier to remove bad data and start over.

Before going into the actual import process, however, we've found it highly useful to review some tips about preparing the spreadsheet data.

Setting Up Your Spreadsheet supports the industry-standard CSV (comma separated value) file format for data uploads. When placed into Excel™, OpenOffice™, or another compatible database application, the spreadsheet app will render our CSV file into a usable database, we just need to lay out the data in the cells properly and save the file.

Also, to make the upload run smoothly, you'll want to make the top row of the sheet a column header. For example:

First Name Last Name Company Name Phone

Click to view larger image.

For database consistency, separate the first name, last name, account name (the contact's full name if B2C, or company name if B2B), and all address data (address, city, state, zip) into separate columns. When finished the spreadsheet should look something similar to the screenshot.

Formatting Dates

Because’s database runs on MySQL, dates need to be set with a specific format when being imported from a spreadsheet.

Typically when you input a date into a spreadsheet, such as “April 1, 2007,” the spreadsheet either leaves the date as you enter it, or automatically translates it into some other format it prefers. For example, Excel™ typically changes “April 1, 2007” automatically to read as “04/01/2007.”

However, to have dates uploaded correctly into InsideSales they need to be input as a date with the four-digit year first, followed by the month and day, for example, 2005/07/31.

Click to view larger image.

Luckily, it’s not difficult to change the format. Select the cells (or entire column), and choose the "Format Cells" option. Then you'll specify a “Custom,” or “User-defined” format type.

Enter the date format with the year first—yyyy/mm/dd, as shown.

Address Format

Addresses also need to follow a specific format to work properly when uploaded. All components of the address—street number and name, apartment / suite #, city, state/province, and postal code—must inhabit their own column within the spreadsheet. If addresses are listed in a single data column, then they must be split into their component pieces before being uploaded.

B2C Database Considerations

For companies who market on a business-to-consumer model, most lists don’t have a data column that indicates a “Company” (they’re consumers, not businesses, after all). We highly recommend that you substitute the full name of the contact in place of a company name.

Click to view larger image.

If your sheet only comes with a first name and last name, but no full name and no company name, you’ll want to create a FULL NAME column in the sheet, and then use the CONCATENATE function to merge the first name and last name together (refer to your spreadsheet application's help materials for using the CONCATENATE function).

Click to view larger image.

If you already have a full name column, but there is not a separate column for first name and last name individually, you’ll need to use the Data Text-to-Columns function to split your full names into a separate first and last name.

Consult your spreadsheet application's documentation for the Text-to-Columns feature if you need help using this function.

Importing the Leads

Once our spreadsheet is mapped and the needed changes are done, we can go ahead and start our data upload. Go to the Campaigns tab, and look for a campaign to upload the data to, or click the Manage Data Import link inside your Admin tab.

After clicking the Import Leads action, the system will take us to the first step of our data upload process.

Step 1

First, click the Browse button on the page and find the saved .CSV spreadsheet file on your computer. For purposes of this training, we assume that you will only be importing a list of names. In most cases, you will not ever use the Import Notes, Import Tasks, or Import Events options. These are used primarily for importing data from an existing database, such as ACT!.

Click to view larger image.

Unique Companies Option

Notice the check mark option for All leads are from unique companies. This is a key element of doing a database upload, particularly for business-to-business (B2B) users. By default this option is selected, meaning that all leads uploaded will arrive as their own unique entry.

However, if you unmark this option, the system will instead assume that all Leads with the same Account name should be linked—in other words, all common contacts at the same organization should cross-reference each other.

For example, in our test spreadsheet, it shows several names with a single company name, ACME, Inc. For most B2B organizations you'd want to relate these Leads together.

However, if there's any question as to which option should be used, leave the All leads are unique companies option selected. If necessary, you can always re-merge common company records down the line.

Once we browse for our CSV file and choose our unique company option, click Upload.

Step 2

After completing the initial upload, the system takes us to the second step in the process. As shown, this step gives us a chance to do a quick inspection of our data, and decide to move on, or go back and re-upload our spreadsheet.

Click to view larger image.

If you've done a good job of pre-formatting the .CSV file, the list should be in good shape and we can quickly continue on. However, if your list was very large, or you’re unsure how "clean" the list was, go ahead and click the Download button. The system will re-parse the list you just uploaded, and create a separate, temporary copy of the .CSV. Save this temporary copy to your hard drive and inspect it, if desired.

If you decide to grab a temporary copy, look at a few of the suggestions on the Step 2 screen, and see if your data has any of the issues listed. If there is any problem with the data, click Go Back and Upload Again and restart the upload.

If our inspection is satisfactory, click Continue and we’ll move on.

Step 3

Step 3 is where we line up all of the column headings in our spreadsheet to the data field in the database. When you first land on the page, the system will have attempted to do some preliminary matching on its own. Any fields marked in yellow will have a pre-matched column selecting.

You'll want to double check the pre-selected matches to make sure they're accurate. You may need to only make a few minor adjustments. If it looks like the matches are way off, click Reset Mapping, which will clear the existing matches.

Click to view larger image.

To map a field, find the field label on the left, then click the dropdown next to it to show a list of all of the column headings in your spreadsheet. Line up the appropriate rows of data.

If you do not have a column heading for some of the database fields, that’s fine, go leave them marked as [SELECT].

Duplicate Checking in Step 3

Step 3 of the upload process also gives us the chance to tell the system to check for records in the system that may match the records we're currently uploading. The goal is to prevent duplicates from getting into the system, and all of the problems that entails.

While selecting the dropdowns, you may have noticed a small check box to the right of some of the fields. These indicate to the system that when your list uploads, you want it to check against those fields for duplicates. If you select more than one option, it will check against both options in aggregate, meaning that a name in your list must meet both criteria to be considered a duplicate. (Using Boolean logic, that's an "AND" not an "OR.") If you get a match for a duplicate the system will disregard that record and not import it.

Click to view larger image.

The most common criteria, or combinations of criteria for duplicate checking are:

  • Last name and phone number together.
  • Email address.
  • Company name and Last Name together.
  • Some combination of phone number, email address, and a custom field of your choice.

Another check box you may want to use is labeled Duplicate check across all objects. This will extend the duplicate check basis for all other objects, such as Accounts and Contacts. By default the duplicate check will operate only among the records of the object type you're importing.

You can also use the check box labeled Limit the duplicate check to records within specific campaigns. This enhancement allows you to import leads and check for duplicates -- but only apply the duplicate rules if a duplicate is found in specific campaigns. Checking this box will open a list of campaigns for you to select. Hold the CTL button (or Command for Mac users) to select multiple campaigns from the list. You might use this feature if you use the PowerDialer in conjunction with outsourced lead generation, and want to actually include the same lead multiple times in different campaigns, but don't want duplicates WITHIN a single campaign.

Step 4

The final step gives us a chance to do a quick “at-a-glance” inspection of the data we just uploaded, and then ultimately accept or reject the new batch.

Click to view larger image.

We highly recommend that you at least do a cursory inspection of the data. Click the browse the site button, and a second window will pop up with a short view of the data batch.

Click to view larger image.

Notice that the preview does not show you everything about the leads, only a select few key fields. If you need to inspect the data in more detail, then you will need to open the advanced search options and run some searches to get the view that you are looking for. Remember that you will need to narrow the campaign and created date in your search so that you are only looking at the batch of data you just uploaded.

Once you have completed your inspection, close the preview window.

To complete the import, choose Accept. If for any reason the data did not come in cleanly, Reject the data, and the system will send you back to Step 1 of the import process, giving you a chance to start over.

Importing Data - Additional Tips

If you expect to be uploading spreadsheet data to the system regularly, we recommend setting up a field map template. This is useful if you're going to be getting a list of names in the same, consistent format, like from a list provider like Hoover's or Dun & Bradstreet.

Click to view larger image.

The way to do this is to create a mapping template while performing an upload. After selecting all of your field maps in Step 3, notice the small input form next to the button to Save Template. Enter a name in the form, and click to save. The system will memorize all of your selections, and create a mapping template that can be reused later at any time.

Using a Lead Routing Rule

By default, when you upload a Lead list, unless you specify otherwise the system assumes the person uploading the data should own it. You can specify an owner ID field in your .CSV spreadsheet to override this, but this can be a lot of work if you have large batches of data to upload, and want to distribute the records to multiple reps.

You could also use a Mass Action to reassign blocks of data after the upload completes, but this can also be problematic, depending on the number of users and amount of data.

The upload tool streamlines this process by letting you use what we call Routing Rules. Routing Rules will get a full treatment and explanation in a future section, but in essence they're a pre-set way for Sysadmins to assign data ownership as leads arrive in the database, either from a list upload, or through the system back end.

Any routing rules will have to be created before doing a list upload, so if you're still setting up a new system, you won't have any rules available initially. Once you create a rule, you can select and apply it during Step 4 of the import process. When you click to Accept the import, the rule applies the necessary ownership changes.

Release Notes

Find our most recent release notes.


Our community forum is coming soon.

Advanced Training Guides

Advanced training for the Lead Management Platform.

Have questions?

We're happy to help. An expert is just a phone call away.

(866) 593-2807

Mon-Fri 6-7 MST

Back To Top

© 2004–2014, Inc. all rights reserved. Use of the service and this Web site constitutes acceptance of our Terms of Use and Privacy Policy. technology is protected by the following United States Patents: 8078605, 8325738, 8352389, 8510382, 8566419.