HubSpot Magical Import Overview

Your team is spending valuable time in Excel cleaning and standardizing your data before importing it to your HubSpot database. Even with this effort, details are being missed, formatting is often inconsistent, and some duplicates are being created in HubSpot. Though the CRM has a built-in import tool, the features are limited.

Insycle's Magical Import module allows you to import data flexibly and powerfully, ensuring that clean, non-duplicate data is entered into HubSpot. You can explore, format, standardize, associate, and cleanse the data before it's imported to the CRM (instead of using Excel or other tools).

Key Use Cases

How It Works

When you select a CSV in Insycle, it doesn't import to the CRM right away. Instead, it loads your CSV into Insycle for preprocessing.

You'll map the CSV columns to CRM fields and choose how that data will be used on a field-by-field basis. Then, you can manage your data in several ways—cleansing, formatting, standardizing, appending data, and creating relationships before importing it into your database.

Insycle also helps you avoid creating duplicates as a side effect of the import using unique identifiers and comparing the CSV rows to existing CRM data.

You can save the import configuration as a template so future imports can be set up with just a couple of clicks.

Supported HubSpot Object Types

Insycle supports importing the following HubSpot object types:

  • Contacts
  • Companies
  • Courses
  • Deals
  • Leads
  • Line items
  • Listings
  • Orders
  • Tickets
  • Custom objects

At the top of the Magical Import module, select the object type that you would like to import.

pick a csv

Here, you can see that we can also select the custom object type, “Cars.” Any custom records that your company uses will be available in Insycle. If yours is not showing, please contact support through the chat to have it added.

Step-by-Step Instructions

Select the CSV File for Import and a Template

Navigate to Data ManagementMagical Import

In the top menu, select the database and record type. Then, choose the CSV file that you would like to import.

magic-import-choose-csv.png

Select a template if you or someone on your team has already saved one that can handle importing from the same source.

magical-import-template-import-format-assoc.png

Step 1: Map CSV Columns to CRM Fields and Choose Import Method

After uploading your CSV data into Insycle, Step 1 will populate with a column for each field in the CSV. Insycle automatically looks for the matching CRM fields and maps them for you. You'll need to manually map any fields it can't figure out.

add-to-multi-select-step-1.png

Next, tell Insycle how to use the data on a field-by-field basis by selecting the Import Mode for each column—update existing records, create new records, or do both depending on what's in your HubSpot data.

There are four Import Modes:

  • Update: Import CSV values into HubSpot, overwriting existing CRM values (will skip empty CSV values).
  • Fill: Import CSV values only when there is no existing value in CRM (will not overwrite existing CRM values).
  • Overwrite: Import CSV values, including empty CSV values, into HubSpot (will overwrite existing CRM values).
  • Append: Add CSV values to existing values in HubSpot. For example, append notes from a CSV to existing notes or add values on multi-select fields (checkboxes or picklists).

magic-import-step-1-import-mode-highlighted.png

Step 2: Choose the Matching Criteria and an Action: Import, Compare, Delete, or Export

Set Matching Criteria

Insycle uses Matching Criteria to compare the CSV with your HubSpot data and identify existing records for the same entity. Matching Criteria are rules based on unique identifiers that typically belong to only one entity, such as:

  • Email address
  • Company domain (for business records)
  • Phone number
  • ID number
  • Street address

You can set multiple matching rules that are evaluated in order from top to bottom. This allows you to find matches based on various criteria, all in one step. 

For example, you could use the following criteria to match contact records:

  1. Email address
  2. First Name + Last Name + Company Name
  3. First Name + Last Name + Phone Number

magical-import-step-2-matching-criteria-610x269.png

Insycle attempts to match each CSV record using the first rule. If no match is found, it proceeds to the next rule, continuing until either a match is found or all rules are exhausted (in which case the CSV record is considered new or unique).

For best results, place your most precise matching criteria at the top of your rule list. Additionally, keep in mind that while names can be included as part of the matching criteria, they should be used in conjunction with other identifiers, as multiple individuals may have the same name.


There are four actions in Step 2 to choose from: 

Import CSV Data into HubSpot

Use the Import feature to enrich existing records or create net new records from data you have in a CSV (without adding duplicates). Learn more about importing from a CSV.

magical-import-hubspot-contacts-step-2-import-646x410.png

Select the Records Mode to tell Insycle how the imported data should be handled during the import process. 

  • Update existing and create net new – If Insycle is unable to find a corresponding record, a new record will be created in HubSpot.
  • Only update existing – If a corresponding record is found, it will be updated with the data from your CSV import. Records that are not matched with an existing CRM record will not be imported.
  • Only create net new – Only records that can not be matched with an existing record in your database will be imported. Records that already exist in HubSpot will not be updated.

Look for Duplicates and Compare Values

Use the Compare (Preview) feature when you want a side-by-side comparison of CSV data against matching items in HubSpot. This is a read-only operation.

Compare features: 

  • Create a new CSV report comparing your import CSV values to HubSpot.
  • See how many contacts from a file are net-new versus already existing in HubSpot.
  • Show CSV data side-by-side with HubSpot data so you can preview how your CSV import would change data for existing records.
  • Check unsubscribes against your HubSpot database.

Learn more about using Magical Import to compare CSV data to existing records in your CRM.

magical-import-hubspot-contacts-step-2-compare-646x288.png

Delete Listed Items from HubSpot

Use the Delete feature when you have a CSV containing records you know need to be deleted. You can match the CSV rows to HubSpot records and easily delete the data in bulk.

⚠️ Note that there is no preview step for this delete action. Once you click the Yes button, the records will be removed from HubSpot.

Learn more about using a CSV to specify records to delete from HubSpot.

magical-import-hubspot-contacts-step-2-delete-646x342.png

Export HubSpot Data Side-by-Side with CSV Values

Use the Export feature when you want more information from HubSpot about items you have in an external source. Put the items you want to look up in a CSV—you really only need the Matching Fields used to look for matches in your database. Then select the HubSpot fields you want to export for the matching records.

Export features:

  • Create a new CSV report comparing your import CSV values to HubSpot.
  • Select the HubSpot field values to include in the export using the Fields to Export.
  • See how many contacts from a file are net-new versus already existing in HubSpot.

This is a read-only operation.

Learn more about exporting CRM data for CSV comparison or enrichment.

magical-import-hubspot-contacts-step-2-export-646x340.png

Step 3: Format and Standardize Data Before Importing (Optional)

Under Step 3, you can make bulk changes to the CSV data or filter out rows before it is uploaded to HubSpot. The options selected and applied here will be reflected in the table view of the data in Step 1, not done directly in your HubSpot database.

Use Functions to Transform CSV Data

On the Functions tab, you can select fields from your CSV and apply formatting and transformation changes to the field data. You could clean up, format, add or remove text, copy values to other fields, or make other updates before it is uploaded to HubSpot. These are the same functions found in the Transform Data module, which you can learn more about here

When finished, click Apply and view the changes under Step 1

magic-import-hubspot-contacts-step-3-format-name-company-country-phone.png

Find & Replace Values before Importing

Using the Find & Replace tab, you can bulk update values in the Step 1 table so they are ready to go when you import. This saves you from needing to go back and edit the original CSV and setting it up in Insycle again.

magical-import-hubspot-companies-step-3-find-&-replace-US.png

Filter Out Rows in Your CSV

The Filter tab allows you to limit which rows from your CSV are imported based on criteria you define. You may want to do this to import in segments that are handled differently or if there are just some junk rows you don't want to import.

magical-import-hubspot-companies-step-3-filter-domain-exists.png

Step 4: Create Relationships, Bulk Update, Add to Campaigns or Lists (Optional)

Make Bulk Changes to a Field 

On the Bulk Update tab, you can add values to CRM fields even if you don't have the field in the CSV. This will add the same value for all the imported records.

magical-import-step-4-bulk-update-lifecycle-stage.png

Associate Imported Rows to Other HubSpot Records

The Associate tab allows you to create relationships between CSV records and existing records in your database when you import. 

Learn more about making associations when importing.

magical-import-hubspot-contacts-step-4-associate-contact-to-company.png

You can create relationships between:

  • Standard or custom objects of different types (such as the cars custom object with deals).
  • Contacts, companies, and deal objects of the same type (contacts to contacts).
  • One object and many objects (for example, one company to multiple deals). Learn more about multiple associations.
  • Contacts or companies and meeting IDs (Learn more in the Advanced How-Tos, below.)

Explore the Associate dropdown for all the options for each object type.

Set Format for Dates Tied to Records

The Date Format tab allows you to reformat dates before the data is imported into your HubSpot database.

Learn more about reformatting dates before the data is imported into HubSpot.

magical-import-step-4-date-format.png

Add Records to HubSpot Lists

When importing HubSpot contacts, the List tab will appear. From here, you can add the imported contacts to a new or existing list.

Type to search existing lists in HubSpot or use the button to Create a new list. If you select an existing list, the Show link will let you open it in HubSpot for a preview.

magical-import-hubspot-contacts-step-4-list.png

Step 5: Import the Data to HubSpot

By default, Insycle will attempt to import all of your CSV data into your database. If there are only a few records you want to import, return to the table under Step 1 and check the boxes beside the select records. 

magical-import-hubspot-contacts-step-1-select-records.png

When you click the Import [X Objects] button under Step 5, you'll be prompted to confirm.

⚠️ Note that there is no preview step. Once you confirm, the changes will be applied to HubSpot immediately.

link16.png

After the import runs, the Import Result breaks down the import information—how many records you tried to import and how many succeeded, failed, were updated, deleted, or unmodified. Click the Run ID to open a CSV record of the import.

magic-import-result-7-records.png

Insycle will also email you a CSV report of these changes. If you open the CSV file, you can look at the Result column to see how each row of your import was handled.

The Result column may show:

  • Created - A new record was created in HubSpot
  • Updated - An existing record was found and updated with data from the CSV
  • Failed - If there is an issue, the Message field will give you details so you can troubleshoot

You can also see the (Before) and (After Update) values side-by-side for each field in your import.

magical-import-hubspot-contacts-by-email-csv.png

Create a Template to Streamline Future Imports

After you've seen the results in the CRM and are satisfied with how the import runs, you can save all of the configurations as a template to use each time you import a CSV with the same source and format. With a template, all of your settings are saved, including field mapping, actions, functions etc., so you will have minimal work for future imports.

Return to the Template menu at the top of the page and click the disk icon to save this as a new template, giving it an informative name.

magical-import-save-new-template-salesforce.png

Tips for Importing from a CSV

  • If your CSV file contains special characters or symbols, it needs to be saved in CSV UTF-8 format. Otherwise, Insycle may not recognize those characters during import.
  • You can experiment with how the functions under Step 3 will work before importing records. After you have set up Functions to apply to your CSV data, click the Apply button. The data in the table under Step 1 will be modified per these instructions. If you don’t like how a function played out, make adjustments and re-apply them. If you don't want to use a function at all, delete it from Step 3; when you click Apply again, the affected data will revert to what it was before.
  • Importing a large data set can take a while to process, and Insycle handles this in the background. Once you click Import, there is no need to keep the page open; you can move on to other things. To check the status of your import, go to the Activity Tracker.

Advanced How-Tos

Selecting Matching Criteria

Insycle uses Matching Criteria to compare your CSV to your HubSpot data. Matching Criteria must be "unique identifiers." These are data points that could only belong to a single entity—such as email addresses, phone numbers, street addresses, or ID numbers.

Additionally, when using an email field, Insycle will automatically cross-reference any additional email fields in the records for a match. If using a domain field, Insycle will check additional domain fields. 

magical-import-hubspot-contacts-step-2-import-email-only-646x269.png

When you configure your Matching Criteria rules, the data under Step 1 will refresh, and you'll be able to see which records are already in your HubSpot database. The records that Insycle found will become blue links that will open the record in HubSpot.

magic-import-hubspot-contacts-step-1-links-to-existing.png

Important Note

You can select more than one field in each Matching Criteria rule; however, ALL of the fields must match, not just one or some of them. If you include five fields and four of them match, but one doesn't, Insycle will not consider the rule a match.

In this scenario, if you Import using either of the "create net new" record modes, Insycle will create a new record for any CSV rows that don't match all five criteria.

If you use the Only Update Existing mode, there will most likely be few records that match all your criteria, and much of your CSV data will not be imported because Insycle will not be able to find the correct record to update.

Typically, it is best to use a single field for your first Matching Criteria to improve the likelihood of finding existing records in HubSpot. Then you can add additional rules to match multiple fields.

magical-import-too-many-matching-fields-in-one-rule-646x245.png

Standardize URL Formats before Importing Data

If you rely on URLs to match imported data with records in HubSpot, the formatting of those values can be key. Perhaps the data in HubSpot is inconsistent, with different representatives entering URLs differently, or maybe website addresses are formatted differently in an external data source.

For example:

  • https://www.acme.com
  • http://acme.com
  • acme.com
  • www.acme.com

When importing, a CSV with varied URL formats might look like this:

magical-import-companies-step-1-website-URLs-mixed-up.png

Insycle lets you easily clean and format values from a CSV before they are imported. All the cleanup happens on the Insycle side, ensuring the import has standardized data.

By using the Functions under Step 3, you can make bulk changes to the CSV data before it is uploaded. The options selected and applied here will be reflected in the table view of the data in Step 1, not done directly in HubSpot.

To eliminate format variants, you can isolate the second-level domain. Under Step 3, select the website or URL column, then select the Extract: Domain from URL function. This will keep just the second-level and top-level domain (acme.com). If you need to take it a step further, and remove the top-level domain (keeping "acme"), add a second function to the column, Remove Top-level domain

magical-import-step-3-functions-extract-domain-remove-TLD.png

Click Apply, then review the changes to the column data under Step 1 to verify that the column data matches the needed format. In this example, the domain has been extracted from the URL, so only the second-level and top-level domains remain. These are the values that will be imported into HubSpot.

magical-import-companies-step-1-website-URLs-2LD-only.png

Learn more about cleaning data before vs. after importing it into your CRM.

Date Format Matching

When date values are detected in a CSV, Insycle will decide which format is being used and make the values consistent when importing. 

Insycle will recognize the following date formats, all of which will work with or without the - or / symbols:

  1. Date time with timezone: 2018-07-19T23:25:45.671-0400
  2. Date time in UTC timezone: 2018-07-19T10:15:30Z 
  3. YYYY-MM-DD HH:MM:SS
  4. Date (YYYY-MM-DD): 2018-07-19 or 2018/07/09
  5. Date (M-D-YYYY): 07-19-2018 or 7/19/2018

You can override this automatic standardizing using the Date Format tab, which allows you to reformat dates before the data is imported into HubSpot.

magical-import-step-4-date-format.png

Learn more about reformatting dates before the data is imported into HubSpot.

Associate HubSpot Companies or Contacts to Meetings on Import

If your team's calendars are integrated with HubSpot, you can import contacts or companies and associate them with meetings in HubSpot to help track engagement. Multiple contacts or companies (meeting attendees) can link to the same meeting.

Your CSV will need to include the contact or company's matching field and the Meeting IDs from your calendar system. 

Suggested Matching Criteria Fields

Options for companies Options for contacts
  • Domain
  • Company Name
  • Record ID
  • Email
  • Record ID
  • First + Last Name

magic-import-hubspot-contacts-meeting-IDs-import-csv.png

In Step 1, make sure the attendee identifier is pointing to the appropriate HubSpot field. In this example, the attendee email maps to the contact Email field. There's no need to map the Meeting ID field. This will only be used for the association, not written to a field. 

magical-import-hubspot-contacts-step-1-meeting-ID.png

Select the Matching Criteria under Step 2, then under Step 4, configure the association to make using the following settings:

  • Action: Add
  • Associate: Contact to Meeting ID or Company to Meeting ID
  • Labels: Unlabeled
  • CSV Column: Meeting ID

magic-import-hubspot-contacts-step-4-associate-meeting-ID.png

In HubSpot you'll see the newly added contact or company associations on the meeting activity.

hubspot-contact-meeting-associations.png

  Note that there is no need to add Meetings as an object type to the account.

Using Activity Tracker to View Audit Trail and History

With the Activity Tracker, you have a complete audit trail and history of changes made through Insycle. At any time you can download a CSV report that lets you see all of the changes that were made during an import operation.

Navigate to Operations > Activity Tracker, enter "import" to search for the Magic Import module, or look for a template name, then click the Run ID for the operation.

activity-tracker-hubspot-magical-import-run-id-w-arrow.png

Viewing the Insycle Run ID Property in HubSpot

When working with HubSpot, for every Insycle operation that updates or creates a record, the Run ID will be updated in the custom property, Insycle Run ID

hubspot-contact-property-history-insycle-run-ID.png

If the Insycle Run ID doesn't already exist in your HubSpot database, add it as a custom property with the label "Insycle Run ID" to each object type as needed. 

This object label is the only requirement for the integration to work properly. It's not dependent on the internal name or underlying API field name.

hubspot-contacts-custom-property-insycle-run-ID.png

When using an Insycle Recipe that includes templates for more than one object type, such as companies and contacts, the same Run ID will appear in both HubSpot records.

Troubleshooting

Here are some tips for troubleshooting issues specific to importing:

Seeing red warnings icon in Step 1

If there are issues with a CSV row, the red warning icon will be shown on the left side of the record. Records that have errors in them will not be imported.

To learn what the problem is and determine steps to resolve it, hover over the red exclamation mark—an explanation of the error will display. 

import12.png

If a field in your HubSpot database includes dropdown values and the data included in your CSV does not match, the row will display an "Invalid picklist value" error. This value needs to be changed to match the dropdown options used in HubSpot.

import13.png

You can make quick fixes to the import data directly in Insycle by hovering over a value and clicking the pencil icon.

import14.png

Matches for CSV records not found in HubSpot

If a record in your CSV is not being matched to a HubSpot record and you know that it should be, there are several potential causes:

  1. The Matching Criteria you chose does not match between the CSV and CRM

    Have a look at the data in HubSpot using the Grid Edit module, adding columns to the layout so you can explore the fields and values. Then, compare this against the columns and values in your CSV to find a reliable but unique field that matches the two sources. 

  2. You are using too many fields in Matching Criteria rule

    You can select more than one field in each Matching Criteria rule; however, ALL of the fields must match, not just one or some of them. If you include five fields and four of them match, but one doesn't, Insycle will not consider the rule a match.

    Typically, it is best to use a single field for your first Matching Criteria to improve the likelihood of finding existing records in HubSpot. Then you can add additional rules to match multiple fields.

    magical-import-too-many-matching-fields-in-one-rule-645x290.png

  3. Your Matching Criteria is too broad

    Insycle uses Matching Criteria to compare your CSV to your HubSpot data. If you're using a field that is not truly unique as Matching Criteria, it's likely that Insycle won't be able to identify one single record as a match. For instance, there could be many people with the first name, "John" in HubSpot. This is why uniqueness is key.

    When selecting your Matching Criteria, make sure it is truly a "unique identifier." These are data points that would only belong to a single record—such as email address, phone number, street address, or ID number. For companies, it could also be company name, or company domain.

    magical-import-too-broad-matching-field-646x236.png

  4. There is a syncing issue

    To refresh the data in Insycle, navigate to Settings > Sync Status, and next to the account name, click the Sync changes from last day button (lightning bolt icon).

    settings-accounts-sync-hubspot.png

    Alternatively, you could log out of Insycle and then log back in.
    For help re-syncing a specific field, contact support.

Data not being formatted when importing

If you have set up formatting or standardization functions in Step 3 but aren't seeing those changes reflected after importing your data, make sure that you click the Apply button.

You must apply these updates to your CSV data before importing it into HubSpot. Then, you will see these changes reflected in the data under Step 1.

import17.png

For general troubleshooting advice, see our article on Troubleshooting Issues.

Frequently Asked Questions

Does Insycle automatically map my CSV fields to my CRM fields?

Yes, Insycle will automatically map fields that it is able to identify. However, if there are cases where it can't figure out what a field should map to, a warning icon will appear, and the CRM field dropdown will say "Not Mapped." You should select the corresponding CRM field to ensure the field is included in the import.

notes

Can Insycle add new data from a CSV to existing records?

Yes, you can easily add to existing data using the Fill or Append Import Modes in Step 1.

  • Fill: Import CSV values only when there is no existing value in CRM (will not overwrite existing CRM values).
  • Append: Add CSV values to existing values in HubSpot. For example, append notes from a CSV to existing notes or add values on multi-select fields (checkboxes or picklists).

magic-import-hubspot-companies-step-1-fill-append.png

Can I clean CSV data before it is added to HubSpot?

Yes, Insycle provides many functions that can clean, format, and standardize data from your CSV before it's imported into your database. The options selected and applied here will be reflected in the table view of the data in Step 1, not done directly in HubSpot.

Under Step 3, on the Functions tab, you can select fields and apply formatting and transformation changes to the field data. These are the same functions found in the Transform Data module, which you can learn more about in the Function Catalog.

magic-import-hubspot-contacts-step-3-format-name-company-country-phone.png

Can Insycle create relationships between records when importing?

Yes, Insycle allows you to associate records while importing data from a CSV in Step 4 using the Associate tab. Learn more about associating HubSpot objects while importing from a CSV.

magical-import-hubspot-contacts-step-4-associate-contact-to-company.png

Can Insycle compare CSV data to existing data in my CRM?

Yes, Insycle allows you to compare the CSV to existing data in your HubSpot records. The Compare (Preview) tab under Step 2 provides a simple CSV report showing the values from your original CSV next to the values currently in HubSpot.

To learn more, see the Compare CSV Data to Existing Records In Your CRM article.

Is there a limit to how many records I can import at once?

Yes, the Magical Import module can handle up to 100k rows for each CSV import. Keep in mind that the more rows and fields you have in your CSV, the slower the import process will be. If you run into any issues, try breaking the CSV into segments and removing any extraneous fields.

Can Insycle add CSV import data to a HubSpot list?

Yes, in Step 4, you can choose to add import data to a HubSpot list in the List tab.

magical-import-hubspot-contacts-step-4-list.png

Additional Resources

Related Help Articles

Related Blog Posts