How to export contacts from HubSpot, step by step

Export your HubSpot contacts to a CSV, XLS or XLSX file in a few clicks, open it in Google Sheets, and know when an export is not enough.

Illustration: a contact list with an Export button, exported to a CSV spreadsheet file.

To export contacts from HubSpot, open your contacts, pick the view you want, and click Export at the top right of the table. Choose a file format, and HubSpot emails you a link to download the file. Below are the steps, the options that change your file, the limits, and how to open the file in Google Sheets.

Before you start

  • You need the Export permission. HubSpot’s help says export permissions “are required to export records”. If you don’t see the Export button, ask your HubSpot admin for the Export permission.
  • The export follows the view you open. To export every contact, open the All contacts view; it includes contacts who unsubscribed. To export fewer, open the saved view you want, for example “Customers in France”.

Export your contacts in 6 steps

  1. In HubSpot, click More > CRM > Contacts (or CRM > Contacts directly, if your account has no More menu).
  2. Open the view you want to export: All contacts for every contact, or one of your saved views.
  3. At the top right of the table, click Export. In board view, click Board options > Export view.
  4. Choose the File format: CSV, XLS or XLSX.
  5. Name the export. To get the column headers in another language, change Language of column headers (only the headers of default properties are translated, not the values).
  6. Choose which properties go in the file (next section), then confirm.

HubSpot then sends you an email with a download link. The link works for 30 days.

Choose what goes in the file

By default, the file holds only the properties and associations shown in your view: the same columns you see in the table. Click Customize to change it:

  • Properties and associations in your view (the default).
  • All properties on records: every contact property, without associations.
  • All properties and associations on records: everything.
Three options and the columns each puts in the file. In your view, the default: only the view's columns, for example first name, last name, email, lifecycle stage and associated company. All properties on records: record ID first, then every property from A to Z, such as city, company name, create date, email and first name. All properties and associations on records: the same, with associated companies and deals added at the end.
The columns each option puts in the file. The names are examples: yours depend on your view and your properties.

With all properties, the columns come in alphabetical order, with the Record ID first. For associated records, such as a contact’s companies, the file lists up to 1,000 per contact by default. All associated records is only offered for CSV files. A contact with several email addresses gets them all if you tick Include all email addresses.

The limits worth knowing

  • 300 exports in a rolling 24 hours, and three at the same time. Extra exports wait in a queue.
  • A large export can take a few hours.
  • A CSV file over 2 MB arrives zipped. Unzip it before you open it.
  • Very large exports come as several files in one zip: above 1,000,000 rows for CSV and XLSX, and above 65,535 rows for XLS.
  • XLS keeps 256 columns and XLSX 16,384. Extra columns are dropped. CSV has no column limit, so choose CSV when you export all properties.

Open the file in Google Sheets

  1. Download the file from HubSpot’s email. If it is a zip, unzip it.
  2. In Google Sheets, open a spreadsheet, then click File > Import and choose your file. Sheets takes CSV, XLSX and XLS files, among others.
  3. Choose where the contacts go: Create new spreadsheet, Insert new sheets, or Replace current sheet.
  4. For a CSV file, leave the separator on Detect automatically, then click Import.

Your contacts are now in a sheet, one row per contact.

Example spreadsheet with four columns: record ID, first name, last name and email. Three made-up contacts, one per row: 51 Ana Moreau, 52 Tomás Keller, 53 Mia Okafor.
What the sheet looks like after the import, with made-up contacts.

When an export is not enough

An export holds your contacts as they were when you clicked Export. A contact who changes jobs an hour later is still at the old company in your sheet. To see the change, you export again, download, unzip and import again.

Timeline of an example day. 9:00: you export your contacts and import the file into Google Sheets. 11:00: in HubSpot, a contact moves to a new company. 11:01: your sheet still shows the old company. Later: to see the change, you export, download, unzip and import again.
An example day: the sheet stays as it was at the moment of the export.

If you need the list once, for an audit, a backup or a one-off mailing, that is fine. The export is part of HubSpot and costs nothing extra.

If your team reads the list every day, a sync saves the repeat work. CRM Sheet Sync keeps HubSpot contacts, companies or deals in a Google Sheet and checks HubSpot for changes every minute (every 30 seconds on the Pro plan):

HubSpot export CRM Sheet Sync
How current the sheet is As of the export Checked every minute
A contact is edited Export and import again Its row is updated
A contact is deleted or merged Still in your file Its row is cleared within about a minute

In our test on a real HubSpot account, five edits reached the sheet in 5 to 38 seconds. Row 1 holds the property names as you see them in HubSpot, and column A holds the HubSpot record ID. CRM Sheet Sync only reads HubSpot: it never changes your contacts.

Setting it up takes three steps: sign in with Google, connect HubSpot, and choose contacts and the properties you want as columns. The setup guide on its site shows each step. The first 7 days are free, with no card to start.

Sources

Frequently asked questions

Can you export HubSpot contacts on a free account?

Yes. HubSpot lists record exports as available with all products and plans. Your user needs the Export permission.

How do I export HubSpot contacts to Excel?

Choose XLSX as the file format. XLSX holds up to 16,384 columns and XLS only 256; to export every property, choose CSV, which has no column limit.

How do I export all contacts from HubSpot?

Open the All contacts view, click Export, then Customize and choose All properties on records. The file includes contacts who unsubscribed: HubSpot suggests the filter Unsubscribed from all email is not equal to True to leave them out.

How do I export only some contacts?

Filter the contacts list, save it as a view, then open that view and click Export.

How long does the HubSpot export link last?

30 days. After that, export again to get a new link.