How to import my CSV file with new fields (columns) which are not available by default?

Updated on August 26, 2017 05:27AM by Admin

If you have a lot of business or personal custom fields while importing contacts, customers, leads etc information that you keep in a spreadsheet, you can import them directly into specified apps. Following are the steps to import Contacts CSV with new custom fields or columns.

There are four major steps:

  1. Get your contact data ready to be imported with custom fields.
  2. You will need to create custom fields in Contacts App.
  3. Import the CSV file format.
  4. Map the Excel spreadsheet columns with the appropriate Contacts fields.

Step One: Mapping structure

CSV fields Contacts App fields
Name Custom Field (Full Name)
First Name First Name
Last Name Last Name
Street Address Billing Address - Address Line 1
City Billing Address - City
State/Province Billing Address - State
Postal Code Billing Address - Zipcode
Phone Business
Mobile phone Mobile
Pager Pager
Home Home
Company Customer
Title Job Title
Other Telephone Telephone
Department Custom Field(Department)
Country or Region Billing Address - Country
Fax Fax
Initials Custom Field(Initials)
Notes Notes
Office Custom Field(Office)
Manager Employee Name

Step Two: Create custom fields in Contacts App

  1. Log in and access Contacts App from your universal navigation menu bar.
  2. Click on "More" icon and select “Settings” located at the app header bar.
  3. Click on "Customize App" from the left navigation panel.
  4. Add the above mentioned custom fields office, department, full name and initials.
    Custom Field
  5. Create custom communication type "Pager" using "Communication" setting as shown in the image below:
    New Contact Type

Step Three: Start the import

  1. Click on "More" icon and select “Import” icon located at the app header bar.
    Contact Import
  2. Click on "New Import" button.
  3. Click on "Browse" button and Choose CSV (Comma Separated Values) file from your computer and click "Next".
  4. Make sure to set the date format that matches your file. Click on "Import" button to import records.
  5. Do not click "Import" yet, because you'll need to "Map" some of the columns in your CSV file to the contact fields. Mapping can figure out the imported contacts, just the way you want.

Back to Top

Step 4: Map fields(columns) to Contacts App fields

  1. Map contacts fields to respective CSV fields based on the mapping structure as shown in the table above.
  2. You will see two rows, one is with your CSV column names and other one is Contacts app fields.
  3. The fields Salutation, First Name and Last Name are default contact fields, so if the contact information in your file has any of those contact names, you're good to go.
  4. Click on to each field, you will see a drop down with sections available; click on "Please Choose"
    You can find the field names, scroll down in the pane on the right for more fields.
  5. Map custom fields pager, office, department, full name and initials as shown in the image below:
  6. Map "Department"(Custom field), this field can be located at any section, here it is in "Contact Details" section:
  7. Map "Office"(Custom field), as shown in the image below:
  8. Map "Initials"(Custom Field), as shown in the image below:
  9. Map Full name(Custom Fields), as shown in the image below:
    Full Name

Back to Top

Related links