What we do
Tools
Industries
Department
How we workLet's talk →
Home/Insightly/Insightly Import Contacts by CSV, Plus Exports
Insightly

How to Import Contacts Into Insightly, and Get Them Back Out

You have a spreadsheet of contacts, or an export from your old CRM, and an empty Contacts tab. Insightly's importer sits in the sidebar of each record tab. It takes a CSV, asks whether you're adding records, updating them or both, and lets you map every column before anything is created.

Contacts in, the short version

Open Contacts, show the sidebar if it's hidden, click Import and choose Import Contacts from a CSV File.

Contacts Show Sidebar Import

Pick an import action, map each column to an Insightly field, and click Start This Import. Insightly emails you when the queue finishes, with anything it skipped.

An Insightly contact import, start to finish

  1. 1

    Create custom fields first

    A column that doesn't match a default field needs a custom field before you begin, since the mapping screen can only offer fields that already exist. Insightly also recommends CSV over Excel files, which can carry formatting the importer misreads.

  2. 2

    Import organizations before contacts

    Insightly links each contact to an organization by name, and creates the organization if there's no match. Loading organizations first, with their own addresses and phones, means contacts attach to complete records.

    Watch for: organization names. Rows with the same name become one organization, so branches need distinct names, such as 'Acme Denver' and 'Acme Austin'.

  3. 3

    Upload the file and pick the action

    Select File Next

    Choose Add New Records, Update Existing Records, or both; the table below helps. Leave Skip the first row when importing ticked if the file has a header row.

  4. 4

    Decide on automations and notifications

    Tick Trigger Automations if workflow rules and AppConnect recipes should run on these records. Leave it off for a historical load you don't want kicking off follow-ups. Send Notifications is off unless you tick it.

  5. 5

    Map the columns and start

    Match each column to an Insightly field, using the header and the first record as a guide, then click Start This Import. The file joins a queue and an email arrives when it's done.

    Watch for: the first run. Insightly suggests a test file of five to ten records before the full list.

Add, update or both: picking the Insightly import action

Your file Pick Watch for
New contacts nobody has entered yet Add New Records Rows Insightly takes for duplicates are skipped and listed in the completion email.
An Insightly export you edited to correct fields Update Existing Records Rows match on the Record ID column alone. Rows without one are skipped, and the changes can't be undone.
Edited records and brand-new ones in one file Add New Records and Update Existing Records Rows with a Record ID update, the rest are added, and duplicates are still skipped.

Why an Insightly import skipped, or doubled, your contacts

Contacts skipped as duplicates

How you'll know: Fewer contacts arrived than the file had rows.

Fix: Insightly counts a contact as a duplicate when the first and last name match exactly and so does the email, phone or organization. A name match on its own isn't enough. The completion email lists what was skipped.

Copies of records you can't see

How you'll know: With Advanced Permissions on, a second copy of a contact someone else owns turns up.

Fix: The duplicate check only covers records the importing user can see. Have someone with access to every record run large imports.

Rows missing a required field

How you'll know: Some rows vanished, and they weren't duplicates.

Fix: Contacts need a first name, and leads need a last name, lead status and lead source. A row missing a required field isn't imported.

An update you want to reverse

How you'll know: An update import overwrote values that were right.

Fix: You can delete newly added records from Your Recent Imports in the sidebar, but changes to existing records can't be reviewed or undone. Export a backup before any update import.

The file is over the plan's limit

How you'll know: The whole import is rejected.

Fix: Imports count against your plan's record limit. Check usage on the Billing & Account page, then trim or split the file.

Exporting contacts out of Insightly

  1. 1

    Get export permission

    Users can't export until an Insightly administrator grants it.

  2. 2

    Export a whole record type

    Contacts Show Sidebar Export

    This takes every record of that type. Some record types ask for a format first.

  3. 3

    Or export a slice

    Filter or List View Tick records More Export

    Narrow the list with a filter, a saved list view, a tag or a recent import, tick the records, and use Select all when there are more than 50.

  4. 4

    Collect the file

    The CSV comes by email, and the last four exports wait under Your Recent Exports in the sidebar as zipped files. The download link lasts 30 days.

    Watch for: what stays behind. File attachments, events, comments and saved emails don't export.

The import that comes back every week

The importer is built for a load somebody starts by hand. When a billing system or an email platform has to agree with Insightly every week, the export, edit and re-import loop never ends, and one slipped column in an update import can't be taken back.

That's the part n-frames builds for Insightly accounts: an API job that updates contacts by Record ID as they change in the other system, or a one-time migration from an old CRM with dedupe rules and field mapping written for that data, so its mess doesn't land in Insightly.

Website forms don't need the importer at all. Insightly builds Web to Contact and Web to Lead forms under System Settings: you pick the fields, copy the generated HTML onto your site, and each submission becomes a tagged contact or lead, with lead assignment rules applied if you use them. Unbounce also connects directly. Insightly's form article doesn't describe a check against contacts you already have, so a returning customer can arrive as a fresh lead. Where that matters, n-frames builds the form handler on the Insightly API that matches each submission to an existing contact before creating anything new.

Insightly import and export questions

Can I import contacts into Insightly from a CSV?

Yes. On the Contacts tab, click Import in the sidebar and choose the CSV option. You map each column to an Insightly field and choose whether to add new records, update existing ones by Record ID, or both.

Can I export my data out of Insightly?

Yes, once an admin has given you export permission. Contacts, organizations, leads, opportunities, projects, tasks, notes, custom object records and more export to CSV, either the whole type from the sidebar or a filtered selection through More and then Export. Attachments, events, comments and saved emails stay behind.

Does Insightly support recurring or automatic imports?

Not through the import tool, where every run is started by hand. A recurring feed is either an AppConnect recipe or custom work on the Insightly API, and that's where n-frames builds the job that updates records as they change in the other system.

Can leads from a website form go straight into Insightly?

Yes. Insightly's own Web to Lead and Web to Contact forms, set up under System Settings, create a record for each submission and tag it Web Lead or Web Contact, and landing-page tools such as Unbounce connect directly. What the native form doesn't cover is your own logic: matching a submission to a contact who's already in Insightly, or passing it to other systems at the same moment. For that, a handler built on the Insightly API takes the submission instead.

Can I import my Google contacts into Insightly?

Yes, two ways: connect Insightly to Google directly, or export Google Contacts to a CSV for more control over the mapping. Contacts whose email address already exists in Insightly aren't imported, and they don't update the existing record either.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.