Salesforce to Excel
Send Salesforce data to Excel automatically
Salesforce
- Mammoth
Excel
Opportunity Stage Amount Close date Northwind renewal Closed Won $48,000 Nov 14 Harbor Foods expansion Negotiation $32,500 Nov 28 Lumen Labs pilot Proposal $12,000 Dec 05 Atlas Freight new Closed Won $27,800 Nov 11
Shown on sample data.
Set up Salesforce to Excel in three steps
- Step 1
Connect Salesforce
Sign in to Salesforce from Mammoth. Production orgs, sandboxes and custom domains all work.
- OpportunitiesAccountsContactsLeadsStep 2
Pick your fields
Tick the objects and fields you want. Preview 100 rows before you save.
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 Salesforce data refreshes every day, or only when you ask. You can set a different schedule.
| Opportunity | Stage | Amount | Close date |
|---|---|---|---|
| Northwind renewal | Closed Won | $48,000 | Nov 14 |
| Harbor Foods expansion | Negotiation | $32,500 | Nov 28 |
| Lumen Labs pilot | Proposal | $12,000 | Dec 05 |
Sends a new Excel file after every update.
Best for people who want the file in their inbox.
| Opportunity | Stage | Amount | Close date |
|---|---|---|---|
| Northwind renewal | Closed Won | $48,000 | Nov 14 |
| Harbor Foods expansion | Negotiation | $32,500 | Nov 28 |
| Lumen Labs pilot | Proposal | $12,000 | Dec 05 |
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 Salesforce data first
Mammoth gets the data ready before it goes to Excel.
Add your other data
Join Salesforce with HubSpot, Xero, Google Ads or 100+ other sources.
Fix the data first
Remove duplicates, fill blanks and fix formats. The same fixes run every time.
Win rate = Won ÷ (Won + Lost)Add the columns you need
Work out win rate, deal age or quarter so they arrive ready to use.
What teams use Salesforce in Excel for
Weekly pipeline file
Open deals by stage, in the sales team's inbox every Monday.
Board pack numbers
Bookings by month, refreshed in the board workbook.
Finance forecasts
Expected revenue by close month, ready for the forecast model.
Ways to get Salesforce data into Excel
Mammoth
For current Salesforce data in Excel, joined with your other sources.
- ✓Updates on a schedule
- ✓Clean the data before it reaches Excel
- ✓Join HubSpot, ads or finance data
- ✓Send the same data to Google Sheets, Power BI or a warehouse
Export a report by hand
For a one-off copy of the numbers.
- ✕Updates on a schedule
- ~Clean the data before it reaches ExcelBy hand
- ~Join HubSpot, ads or finance dataPasted in by hand
- ✕Send the same data to Google Sheets, Power BI or a warehouse
Or turn the same data into a Salesforce dashboard
Describe the dashboard in one sentence and Mammoth builds it from your data.
The template: paste this into Mammoth
Salesforce opportunity dashboard: closed won amount, open pipeline, win rate (won opportunities over closed opportunities), average deal size, opportunities won and opportunities created as KPIs, closed won amount by month, open pipeline by stage, and closed won amount by lead source

Common questions about Salesforce to Excel
How do I connect Salesforce to Excel?
Does Excel update automatically?
Can I limit how often the email sends?
How do I connect Excel to a Live link?
Does it work with a Salesforce sandbox?
What do I need in Salesforce?
Step-by-step setup is in our docs for Salesforce and Excel.
Keep Excel up to date with Salesforce data.
Start free, connect Salesforce, and send it to Excel.
- ✓ 14-day Pro trial
- ✓ No credit card
- ✓ Viewers always free