Skip to content

Salesforce to Excel

Send Salesforce data to Excel automatically

Connect Salesforce 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. Salesforce
  2. Mammoth
  3. Excel
    OpportunityStageAmountClose date
    Northwind renewalClosed Won$48,000Nov 14
    Harbor Foods expansionNegotiation$32,500Nov 28
    Lumen Labs pilotProposal$12,000Dec 05
    Atlas Freight newClosed Won$27,800Nov 11

Shown on sample data.

Set up Salesforce to Excel in three steps

  1. Step 1

    Connect Salesforce

    Sign in to Salesforce from Mammoth. Production orgs, sandboxes and custom domains all work.

  2. OpportunitiesAccountsContactsLeads
    Step 2

    Pick your fields

    Tick the objects and fields you want. Preview 100 rows before you save.

  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 Salesforce14-day Pro trial · No credit card

Choose how Excel updates

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

Excel
OpportunityStageAmountClose date
Northwind renewalClosed Won$48,000Nov 14
Harbor Foods expansionNegotiation$32,500Nov 28
Lumen Labs pilotProposal$12,000Dec 05
Email the file

Sends a new Excel file after every update.

Best for people who want the file in their inbox.

Excel
OpportunityStageAmountClose date
Northwind renewalClosed Won$48,000Nov 14
Harbor Foods expansionNegotiation$32,500Nov 28
Lumen Labs pilotProposal$12,000Dec 05
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 Salesforce data first

Mammoth gets the data ready before it goes to Excel.

Join

Add your other data

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

12 duplicate deals removedClose dates set to one format
Clean

Fix the data first

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

Win rate = Won ÷ (Won + Lost)
Calculate

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

Salesforce dashboard built in Mammoth, showing Closed won amount, Open pipeline, Win rate, Average deal size, Opportunities won, Opportunities created
The dashboard Mammoth built from that sentence, on sample data.Open the live dashboard →

See the free Salesforce dashboard template

Common questions about Salesforce to Excel

How do I connect Salesforce to Excel?
Connect Salesforce 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 Salesforce 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.
Does it work with a Salesforce sandbox?
Yes. Enter your sandbox login address, such as https://test.salesforce.com, when you connect.
What do I need in Salesforce?
A Salesforce user with API access turned on. Mammoth sees the objects and fields that user can see.

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