Skip to content

HubSpot to Excel

Send HubSpot data to Excel automatically

Connect HubSpot to Mammoth, pick the fields you want and send them to Excel. Mammoth keeps Excel up to date on a schedule, so nobody exports a report by hand.
  1. HubSpot
  2. Mammoth
  3. Excel
    DealStageAmountOwner
    Brightline annualClosed won$18,400Maya R.
    Kestrel DentalContract sent$9,600Sam O.
    Orchard StudioQualified$4,200Maya R.
    Fieldway GroupClosed won$22,000Lee T.

Shown on sample data.

Set up HubSpot to Excel in three steps

  1. Step 1

    Connect HubSpot

    Sign in to HubSpot from Mammoth. There are no API keys to copy.

  2. DealsContactsCompaniesTickets
    Step 2

    Pick your fields

    Tick the CRM tables and columns you want, or describe the data in plain words.

  3. Updated
    Step 3

    Send it to Excel

    Email the Excel file after every update, or connect Excel to a Live link.

Start free and connect HubSpot14-day Pro trial · No credit card

Choose how Excel updates

Your HubSpot data refreshes every day, or only when you ask. You can set a different schedule.

Excel
DealStageAmountOwner
Brightline annualClosed won$18,400Maya R.
Kestrel DentalContract sent$9,600Sam O.
Orchard StudioQualified$4,200Maya R.
Email the file

Sends a new Excel file after every update.

Best for people who want the file in their inbox.

Excel
DealStageAmountOwner
Brightline annualClosed won$18,400Maya R.
Kestrel DentalContract sent$9,600Sam O.
Orchard StudioQualified$4,200Maya R.
Live link

Excel refreshes from a fixed web address.

Best for a workbook you keep and refresh.

Emails go to up to 50 people in your workspace. Files over 10 MB arrive as a download link.

Clean and combine your HubSpot data first

Mammoth gets the data ready before it goes to Excel.

Join

Add your other data

Join HubSpot with Salesforce, Google Ads, Xero or 100+ other sources.

48 duplicate contacts mergedCountry names set to one format
Clean

Fix the data first

Remove duplicates, fill blanks and fix formats. The same fixes run every time.

Days to close = Close date − Create date
Calculate

Add the columns you need

Work out days to close, deal age or quarter so they arrive ready to use.

What teams use HubSpot in Excel for

  • Weekly sales report

    Deals won and lost by owner, in the inbox every Monday.

  • Lead lists for the team

    New contacts by source, refreshed in a shared workbook.

  • Commission tracking

    Closed won deals by rep, ready for the monthly payout.

Ways to get HubSpot data into Excel

Mammoth

For current HubSpot data in Excel, joined with your other sources.

  • ✓Updates on a schedule
  • ✓Clean the data before it reaches Excel
  • ✓Join Salesforce, ads or finance data
  • ✓The file link stays the same

HubSpot's record export

For a one-off file of your records, as CSV or Excel.

  • ✕Updates on a schedule
  • ~Clean the data before it reaches ExcelBy hand
  • ✕Join Salesforce, ads or finance data
  • ~The file link stays the sameDownload links expire after 30 days

Or turn the same data into a HubSpot dashboard

Describe the dashboard in one sentence and Mammoth builds it from your data.

The template: paste this into Mammoth

HubSpot deal pipeline: open pipeline value, deals won, revenue won, win rate, average deal size and deals created as KPIs, revenue won by month, open pipeline value by deal stage, and revenue won by deal owner

HubSpot dashboard built in Mammoth, showing Open pipeline, Deals won, Revenue won, Win rate, Average deal size, Deals created
The dashboard Mammoth built from that sentence, on sample data.Open the live dashboard →

See the free HubSpot dashboard template

Common questions about HubSpot to Excel

How do I connect HubSpot to Excel?
Connect HubSpot to Mammoth and pick the fields you want. Then export them to Excel, and Mammoth keeps it up to date.
Does Excel update automatically?
Yes. Your HubSpot data refreshes every day, or only when you ask. You can set a different schedule. After each refresh, Mammoth sends the new data to Excel.
Can I limit how often the email sends?
Yes. By default it sends whenever the data updates. You can limit it to at most once a day or once a week.
How do I connect Excel to a Live link?
In Excel, choose Data, then From Web, and paste the link. Excel fetches the latest data each time you refresh.
What do I need in HubSpot?
A HubSpot user who can see the data you want. Mammoth reads the CRM tables that user can see.

Step-by-step setup is in our docs for HubSpot and Excel.

Keep Excel up to date with HubSpot data.

Start free, connect HubSpot, and send it to Excel.

  • ✓ 14-day Pro trial
  • ✓ No credit card
  • ✓ Viewers always free