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, such as notes or emails, cannot be exported. To retrieve engagements, use the engagements API.
- 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 or to include All properties on records. The order of the columns in the export file depends on the option you select:
- If you export only properties in the view, the columns are displayed in the same property order set for the view.
- If you export all properties, the columns are displayed in alphabetical order, with the exceptions of Record ID and associated records. Record ID will be the first column in the file, while associations are included at the end.
- 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 (firstname.lastname@example.org); Lorelai Gilmore (email@example.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.