How to import data into Insightly

After you've prepared your file for importing, you can begin importing your records.

In the steps below, we're importing contact records. For other records, you may see additional selections during import, but the steps are the same. We have articles to guide you through importing leads and contact or organization notes.

If you have specialized information in your file—like billing ID numbers or customer types—be sure to create custom fields before importing. You'll need these fields to map your information during the import process.

When importing for the first time, test the import with a file that contains just a few of your records.

To import records

  1. Click the object tab for the type of records you're importing.
  2. Click the Import link in the sidebar. If the sidebar is not displayed, click the Show Sidebar icon.
  3. If displayed, choose an import method. Some record imports will not require this step.
    In this example, we will choose the most common method, Import Contacts from a CSV File.
  4. Click Select File, then choose a file to be imported. Click Next.
  5. Choose an import action.
    • Add New Records - Add new records and skip records that Insightly recognizes as duplicates.
    • Update Existing Records - Update records that match the Record ID field in your file. Skip all other records.
    • Add New Records and Update Existing Records - Update records that match the Record ID field in your file, skip duplicates, and add all other records.
  6. Uncheck the Skip the first row when importing checkbox if your file does not include a header row.
  7. Click the Trigger Automations checkbox if you want to trigger workflow automation actions or AppConnect Recipes. If not checked, workflow automation rules and actions and associated AppConnect recipes will not be processed for these records that are applicable to the records you are importing. 
  8. Click the Send Notifications checkbox, which allows users to choose whether these record change notifications will be sent or not. By default, record change notifications will not be sent.

  9. Click Next.
  10. Insightly will display three columns: Insightly fields, headers from your file, and the first record in your file. Select or verify the Insightly Field for each column in your file. If you're importing tags with your records, you might want to review Importing records with tags.
  11. Click Start This Import.

A confirmation message will display as your file is successfully placed in an import queue. We'll send you an email within a few minutes letting you know when the process has completed and if there were any problems with the import.

Was this article helpful?