Contact
Page header background

Home >> How to Import Data into Insightly

At BestCRMSoftware.com, we prioritize transparency and honesty in all our content. In order to maintain the quality of our reviews and to keep providing valuable information to our audience at no cost, We earn commissions through clicks and affiliate purchases from select links in our articles. Our commitment to unbiased content remains unwavering, despite our use of affiliate links. These links do not influence the opinions or recommendations provided by our editorial team. We prioritize integrity and objectivity in every piece of content we produce, ensuring that our readers receive unbiased and reliable information to inform their decisions effectively.

How to Import Data into Insightly

Stephen Jones BestCRMSoftware Author
Author
Stephen Jones
CRM Consultant
Stephen Jones BestCRMSoftware Author
Biography
Stephen Jones is a seasoned Customer Relationship Management (CRM) professional with over 7 years of experience in the field. Throughout his career, he has helped businesses of all sizes implement and optimize their CRM systems to drive sales growth, improve customer satisfaction, and streamline operations. Stephen is passionate about sharing his CRM expertise and insights through insightful blog posts and articles.
View Author Profile
Anna Rodriguez BestCRMSoftware Author
Factcheck By:
Anna Rodriguez
CRM Expert
Anna Rodriguez BestCRMSoftware Author
Biography
Anna Rodriguez is a CRM consultant with 4 years of experience in helping businesses across various industries select, implement, and manage their CRM systems. She is skilled in CRM system customization, data migration, and user adoption strategies. Anna is passionate about helping businesses unlock the full potential of their CRM systems and fostering a customer-centric culture within organizations. She constantly keeps on top of the newest industry trends and holds a Bachelor's degree in Information Technology.
View Author Profile
Latest Update: Aug 23, 2024, 11:03 am
How to import contacts into insightly
Latest Update: Aug 23, 2024, 11:03 am

Insightly is a powerful customer relationship management (CRM) tool designed to streamline your business processes and enhance your customer interactions. To set up your CRM system and ensure that the data in your database is correct and current, you must import data into Insightly.

In this comprehensive guide, we’ll walk you through the process of importing various types of data into Insightly, from contacts and organizations to leads and opportunities. By following these steps, you will be able to easily move data, organizations, opportunities, or other records more efficiently. 

So, let’s dive in and learn how to seamlessly import your data into Insightly, empowering your business to thrive in today’s competitive landscape.

Step-by-Step Guide To Import Data Into Insightly

To import the data into Insightly, you need to prepare your file before you can import your records. While importing, you may notice more options for different records, but the procedures remain the same.

When you do it for the first time, use a file containing only a few of your entries to test the import. 

Step 1: Prepare Data

  • Organize your data in a format that Insightly supports such as CSV format or Excel form.
  • Make sure that your data includes all the necessary details required in Insightly.

Step 2: Log In To Insightly

Go to the Insightly website and log in to your account.

Step 3: Import Records 

  • First, import records or choose the Object tab to select the type of data that you want to import.
  • In the sidebar, click on the data import link. If the sidebar is not being displayed on the screen, click the Show Sidebar icon.
insightly import contacts button
  • Sometimes while importing the data or records, you will not require this step. If the step is displayed on the screen then you must select one import method to continue the process.
  • Here, we want to import data & then choose to import data from a CSV file.
insightly crm import csv

Step 4: Upload File

Now select the file that you want to import and click Next.

insightly import file screen

Step 5: Import Options

You will need to choose one import option from the three given options:

  1. Create New Record: You can create new records by excluding some that Insightly locates as duplicates.
  2. Update Existing Record: Update those records in your file that match the record ID field and ignore all others.
  3. Create New Record and Update Exiting Record: Add all the additional records by skipping duplicate ones and updating the records that match the record ID field.
insightly import options

Step 6: Field Mapping

  • If there is no header row in your file, uncheck the Skip the first row when importing option.
  • To initiate AppConnect Recipes or workflow automation tasks, choose the Trigger Automations checkbox. Workflow automation rules, actions, and related AppConnect recipes that apply to these records and are relevant to the data you are importing will not be handled if they are not verified.
  • To select whether to send these record change alerts, click the Send Notifications button. Notifications of record changes will not be delivered by default.
  • Click on Next.
insightly import options notification

Step 7: Importing Records With Tag

  • Three columns will be shown by Insightly: the first entry in your file, headers from your file, and Insightly fields. For every column in your file, choose or confirm the Insightly Field.
  • You can explore Importing records with tags if you are importing tags with your records.
insightly import file mapping

Step 8: Click on Start

  • To start importing data, click on the Start button.
  • A confirmation message will be displayed on your screen after successfully importing data.
  • You will be notified that the process has been completed (or if any issue arises) vie email within a few minutes.

Wrapping Up

You can import data easily into Insightly and ensure that your CRM database is filled with the data needed to support your business activities. Setting up a solid CRM system that enables you to efficiently manage your client connections requires completing the data import process, regardless of whether you’re beginning from scratch or migrating from another system.

Leverage the efficiency of Insightly and use precise, well-organized data to maximize the capabilities of your CRM system.