Contacts

View and analyze previous imports

Last updated: April 5, 2021

After importing objects to HubSpot, you can view and analyze your previous imports in the imports dashboard. This can help with any import errors, or understanding where a record was created. You can also delete the records of an import.

Imports dashboard

  • Name: the name of the import that was added in the Import Details.
  • New records: the number of new contacts added. If a contact already existed in your database prior to the import, it will not be included in this value.
  • Updated records: the number of existing records updated by the import.
  • Error count: the number of records in your import that resulted in an error and could not be processed. To see a detailed list of errors, click the More dropdown menu and select Download errors to see a detailed list of errors.
  • Source: the type of import selected.
  • User: the name of the user in your account who imported the file.
  • Created: the date the import was completed.

import-status

View imported objects and import errors

To view your original import file, click the More dropdown menu and select Download original file.

Create a list of imported contacts

To create a list of your recently imported contacts, you can create a list from the imports dashboard:

import-more-new-list

  • Click the pencil icon edit in the top-left corner and give your list a name.
  • Click the AND or OR to add more criteria to your list.
  • When you are done, in the top right, click Save.

Create a filter to view imported contacts, companies, or deals

To save the list of imported records as a view in HubSpot:

  • In your HubSpot account, navigate to your contacts, companies, or deals.
  • Click More filters.
  • In the right panel, search for and select Import.
  • Select the radio button next to the filter criteria is any of, is none of, is known, or is unknown. Then click the dropdown menu and select the import file you want to segment by. save-import-as-view
  • Click Apply filter, then exit the side panel.
  • Click Save view, then select Save as new.
  • Give the view a name, choose who to share it with, then click Save.

Download error file

If your import has errors:

  • In your HubSpot account, navigate to your contacts, companies, deals, tickets, or products.
  • In the upper right, click Import.
  • Hover over a file import with errors and click the More dropdown menu, then select Download error file.
  • Extract the CSV file from the downloaded zip file, then open the CSV file.
  • In the file, identify the error code under the Error code header, the reason for the error under the Reason column, and the details of the object with the error in the subsequent columns.

Please note: you can only download error files for imports that were completed within the last six months.

Learn more about each error and how to troubleshoot them.

Delete records from an import

You can delete the records that were created or updated by your import. For example, if you’ve imported all new records but made a mistake, you can delete all of the records and import again.

Please note: if you updated existing records via an import, you will not be able to reverse the changes by deleting. You would need to complete another import with the correct information or manually edit the properties.

  • In your HubSpot account, navigate to your contacts, companies, deals, tickets, or products.

  • In the upper right, click Import.

  • Hover over the name of the import, then click View [object]. If you’ve imported multiple objects in the file, click View, then in the dropdown menu, select the object of the records you want to delete. If you want to delete all imported records, you will need to repeat this with each object.

  • Select the checkboxes to the left of the records you want to delete. To select all records, select the checkbox at the top left of the table. A blue banner will appear telling you how many records are selected. Click Select all [records].

  • At the top of the table, click delete Delete.