Importing records with custom fields

This article is part of the Insightly Importing Guide

As you prepare a file for import, you may find that you have special information that isn't covered by the standard fields in Insightly. For these, you'll need to create a custom field in Insightly before importing.

Here are a few helpful notes about importing custom fields:

Selecting the right type of field

The type of information you're importing will help you decide what kind of field to set up.

In this example, our file includes a billing ID from our accounting system and a preferred nickname for our contacts. We can create numeric and text fields in Insightly to hold this information.

Type of information you're importing Recommended custom field type
A short string of text Text Field
Dates Date Field
A binary choice: Yes/No, Off/On, True/False Checkbox
Only numbers Numeric
Web addresses URL
A longer string of text Multi-line Text Field
A limited list of values Dropdown Field
Email addresses Email Address Field
Phone numbers Phone Number Field

Dropdown field values

A dropdown field in Insightly limits the selection to a list of specific values. When you import to a dropdown list field, the value you import will have to match an item in the list exactly. If it's "Nice" in the dropdown list, it should be "Nice" in your file -- a lowercase "nice" will not work properly.

When you set up a dropdown field, you'll need to make sure your list in Insightly covers all the values you might import.

Checkbox field values

Checkbox custom fields display as either checked or unchecked in Insightly. In computer-speak, this is a True or False value. To import checkboxes, checked = True and unchecked = False (or a blank value in your file).

If your previous system used different values, like Yes and No or On and Off, do a search and replace in that column of your file and change the "checked" value with True.


Have more questions? Submit a request