HubSpot to Excel
Send HubSpot data to Excel automatically
HubSpot
- Mammoth
Excel
Deal Stage Amount Owner Brightline annual Closed won $18,400 Maya R. Kestrel Dental Contract sent $9,600 Sam O. Orchard Studio Qualified $4,200 Maya R. Fieldway Group Closed won $22,000 Lee T.
Shown on sample data.
Set up HubSpot to Excel in three steps
- Step 1
Connect HubSpot
Sign in to HubSpot from Mammoth. There are no API keys to copy.
- DealsContactsCompaniesTicketsStep 2
Pick your fields
Tick the CRM tables and columns you want, or describe the data in plain words.
Updated
Step 3Send it to Excel
Email the Excel file after every update, or connect Excel to a Live link.
Choose how Excel updates
Your HubSpot data refreshes every day, or only when you ask. You can set a different schedule.
| Deal | Stage | Amount | Owner |
|---|---|---|---|
| Brightline annual | Closed won | $18,400 | Maya R. |
| Kestrel Dental | Contract sent | $9,600 | Sam O. |
| Orchard Studio | Qualified | $4,200 | Maya R. |
Sends a new Excel file after every update.
Best for people who want the file in their inbox.
| Deal | Stage | Amount | Owner |
|---|---|---|---|
| Brightline annual | Closed won | $18,400 | Maya R. |
| Kestrel Dental | Contract sent | $9,600 | Sam O. |
| Orchard Studio | Qualified | $4,200 | Maya R. |
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.
Add your other data
Join HubSpot with Salesforce, Google Ads, Xero or 100+ other sources.
Fix the data first
Remove duplicates, fill blanks and fix formats. The same fixes run every time.
Days to close = Close date − Create dateAdd 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

Common questions about HubSpot to Excel
How do I connect HubSpot to Excel?
Does Excel update automatically?
Can I limit how often the email sends?
How do I connect Excel to a Live link?
What do I need in HubSpot?
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