Need help?

CSV Import Wizard

The first step to success for using Nimble is to upload your company contacts from an existing CRM, Outlook, or other sources. Once you add your contacts to Nimble, you’ll be able to take advantage of all the Sales & Marketing features in Nimble.

We built the CSV Import Wizard for Nimble as an in-app utility, allowing you to load any CSV file into Nimble and then match the fields for import to Nimble. Upload the file into Nimble, match the fields, and let our Wizard do the rest!

Table of Contents

Getting Started With the Wizard
Data Sources
Matching Columns and Fields
Importing Contacts And Companies In One File
Importing Custom Fields
Importing Social Profiles
Field Hierarchy
Bulk Updating Contacts via Import

Getting Started With The Wizard
Our CSV Import Wizard that can be found in Settings » Networks & Imports » “Start Wizard”.

Data Sources

When adding your CSV file to Nimble, you may select your existing data source via our menu on the righthand side. By default we support - ACT!, Base CRM, Capsule, Highrise, Insightly, LinkedIn, Nutshell, Microsoft Office 365, Microsoft Outlook and Outlook Express, Pipedrive, Prosperworks, Salesforce, Sugar CRM, Yahoo Mail, Zoho.

You may also choose from a mapping you have already saved from a previous import! Learn more here: How to Save CSV Import Mappings

If you are importing from another source or from a proprietary spreadsheet, simply click “Next” skip this step to the “Match Fields” step.

Matching Columns and Fields

Once you load your CSV file, you’ll be brought to the “Field Matching” page. The “Column name” column on the left will contain fields from your import file, while the “Nimble field” column enables you to find and match corresponding Nimble fields.

In each row, find the corresponding fields to match by searching the field selection.

Importing Contacts And Companies In One File

Nimble allows you to import both contacts and companies in the same file. This will save you time with having to create two separate CSV files and perform two separate imports.

If your file contains both contacts and companies, this will require some formatting of your CSV file. There are 2 ways to format your CSV file to achieve a successful import.

In your CSV file, place company names on the same row as contacts. This will assure that contacts and companies are automatically matched once imported.

To apply field values such as phone numbers, addresses, emails, etc to both contact and companies, copy your companies and paste them below your contact data. You can then copy and paste information from the contact fields and paste beside the companies. Or you can enter new information that pertains specifically to that company.

Formatting Domains In Your File
Domains in Nimble can only apply to companies. Therefore, if you are uploading domains to a company record, you must treat this the same as applying information to companies.

First, create a header titled “Domain”. If you have contacts at the top of your CSV file, you’ll need to leave the domain fields blank until you reach companies below contacts.

Domains must also be formatted without HTTP://.” or “WWW.”. Therefore, your domain should look like this ex. “nimble.com”.

Importing Custom Fields

If you have data in your CSV file that does not correspond with a field that already exists in Nimble, you can create custom fields from your Settings » Data Fields page, and then match those fields in our Import Wizard! Learn more in our support article here: Custom Data Fields

Our CSV Import Wizard also offers the option to create custom fields from within the Wizard itself! Simply click the dropdown next to a field you wish to map to Nimble, and select “Create New Field”:

Importing Social Profiles
You may now import social profiles along with other contact information when importing a CSV file to Nimble! For more information, please see our support article here: Importing Contacts’ Social Accounts via CSV File

Field Hierarchy
Here’s the hierarchy we have for field headers, dictating which field values appear at the top of contact records in Nimble.

Phone modifiers:

  1. Main
  2. Work
  3. Mobile
  4. Home
  5. Work Fax
  6. Home Fax
  7. Other

    Email modifiers:

  8. Work
  9. Personal
  10. Other

Address modifiers:

  1. Work
  2. Home
  3. Other

Updating Contacts via CSV Import
To update contacts via CSV import, select the “Override existing fields” option, and all fields will be updated or overwritten.

Fields that will be overwritten:
Single-value fields: Name, Title, Company, Description, custom fields - Nimble will override these fields with the data from the CSV field.

Fields that will be appended:
Multi-value fields: phone numbers, addresses, websites…etc. - Nimble will append new data from the CSV into the record.

Last Updated: 23 October, 2018

SMS logo

We're the experts in the business cloud. Take a look at our full service range.

Office 365 Plans

We offer the full suite of Office 365 plans including the fully-features Office 365 Business Premium, email only plans, and the full Enterprise suite.

See Office 365 plans

Microsoft 365 Plans

Get the full Microsoft experience with Windows 10, Microsoft Office, cloud storage, and email.

See Microsoft 365 plans

Advanced spam protection

Protect your emails, and company network, from spam, virus, phishing, and other threats.

See protection plans