Export your records
Last updated: June 22, 2022
Applies to:
All products and plans |
You can export your records (e.g., contact records) in your HubSpot account. You can also view a list of your account's past exports.
Engagements on records cannot be exported. To retrieve engagements, use the engagements API.
Export records
- Navigate to your records:
- Calls: In your HubSpot account, navigate to Contacts > Calls.
- Contacts: In your HubSpot account, navigate to Contacts > Contacts.
- Companies: In your HubSpot account, navigate to Contacts > Companies.
- Deals: In your HubSpot account, navigate to Sales > Deals.
- Payments: In your HubSpot account, navigate to Sales > Payments.
- Tickets: In your HubSpot account, navigate to Service > Tickets.
- Custom objects: In your HubSpot account, navigate to Contacts > [Custom object]. If your account has more than one custom object, hover over Custom Objects, then select the custom object you want to view.
- If you're on the deals, tickets, or custom object index page, ensure you're in the table format by clicking the listView table icon in the upper left.
- To open the view you want to export, click + Add view then select the view from the dropdown menu. To export all records of that object, open the All [records] view.
- Once you're on the tab of the view you want to export, on the right, click the Actions dropdown menu, then select Export view.
- In the dialog box, click the File format dropdown menu and select the format for your export file.
Please note: the file format XLS has a limit of 65,536 rows. If you're exporting more than 65,536 records, you should select another file format.
- Select either to Include only properties in the view of the table or to include All properties on records. Learn how to edit which properties appear as columns in a view.
- If you're exporting contact records, select the Include all email addresses checkbox to include all email addresses for contacts with multiple emails in the export file.
- If you're exporting company records, select the Include all domains checkbox to include all domain names for companies with multiple domains in the export file.
- Click the dropdown menu to select in which language you'd like your column headers to appear within the exported file. By default, the dropdown menu will show the default language you've selected in your settings. The column headers of default properties will be translated, but the property values within each column will not be translated to the selected language.
- Click Export. You'll receive an email with a download link to your export file. Download links to export files will expire after 30 days.
Frequently asked questions
How do associated objects appear in the export file?
If the records you export have associated records, each associated object will have its own columns within the file containing the following headers and information:
- Associated company:
- Associated Company ID: the ID of the associated company.
- Associated company: the associated company's name.
- Associated contacts:
- Associated Contact IDs: the IDs of any associated contacts, separated by a semicolon.
- Associated contact: the first name, last name, and email address of any associated contacts. Each contact will be separated by a semicolon (e.g., Luke Danes (luke@lukesdiner.com); Lorelai Gilmore (lorelai@thedragonfly.com)).
- Associated deals:
- Associated Deal IDs: the IDs of any associated deals, separated by a semicolon.
- Associated Deal: the names of any associated deals, separated by a semicolon (e.g., Deal 1; Deal 2; Deal 3).
- Associated tickets:
- Associated Ticket IDs: the IDs of any associated tickets, separated by a semicolon.
- Associated Ticket: the names of any associated tickets, separated by a semicolon (e.g., Ticket 1; Ticket 2; Ticket 3).
Why am I not receiving an email with my export file?
If you're not receiving your export file, the file may be larger than 2GB. You may want to filter down your records and export in separate batches to receive the export faster.
Thank you for your feedback, it means a lot to us.
Related content
-
Import one object
You can import files to create and update HubSpot records in bulk. This article explains how to import a...
Knowledge Base -
Assign ownership of records
HubSpot uses the [Object] owner properties to set the ownership of a contact, company, deal, ticket, or...
Knowledge Base -
Create and edit properties
Properties are fields that store information on HubSpot records. For example, you can use the City company...
Knowledge Base