Skip to content
Back to template gallery
Salesforce
Salesforce

How to export opportunities from Salesforce to Microsoft Excel

A ready-made, step-by-step walkthrough. Preview every step below — then make it your own in seconds.

Sales & Customer Success
14 steps 6 min Community template
1

Navigate to your Salesforce

Navigate to your Salesforce

2

Click "Reports" in navigation

Click "Reports" in navigation

walkme--fullsb.sandbox.lightning.force.com/lightning/o/Report/home
Click "Reports" in navigation
3

Click "New Report"

Click "New Report"

walkme--fullsb.sandbox.lightning.force.com/lightning/o/Report/home
Click "New Report"
4

Click "Opportunities" link

Click "Opportunities" link

walkme--fullsb.sandbox.lightning.force.com/reports/lightningReportApp.app
Click "Opportunities" link
5

You can add or delete columns by toggling the options on the left-hand side of your screen.

You can add or delete columns by toggling the options on the left-hand side of your screen.

walkme--fullsb.sandbox.lightning.force.com/reports/lightningReportApp.app
You can add or delete columns by toggling the options on the left-hand side of your screen.
6

Click "Filters"

Click "Filters"

walkme--fullsb.sandbox.lightning.force.com/reports/lightningReportApp.app
Click "Filters"
7

Click the "Add filter..." field if you'd like to add any filters.

Click the "Add filter..." field if you'd like to add any filters.

walkme--fullsb.sandbox.lightning.force.com/reports/lightningReportApp.app
Click the "Add filter..." field if you'd like to add any filters.
8

In the example below I added a specific filter, but you can skip this step if you just want to export all opportunities.

In the example below I added a specific filter, but you can skip this step if you just want to export all opportunities.

9

Click "Created By"

Click "Created By"

walkme--fullsb.sandbox.lightning.force.com/reports/lightningReportApp.app
Click "Created By"
10

Click "Apply"

Click "Apply"

walkme--fullsb.sandbox.lightning.force.com/reports/lightningReportApp.app
Click "Apply"
11

Click "Run"

Click "Run"

walkme--fullsb.sandbox.lightning.force.com/reports/lightningReportApp.app
Click "Run"
12

Click the arrow next to the "Edit" button and click "Export"

Click the arrow next to the "Edit" button and click "Export"

walkme--fullsb.sandbox.lightning.force.com/reports/lightningReportApp.app
Click the arrow next to the "Edit" button and click "Export"
13

Click "Export"

Click "Export"

walkme--fullsb.sandbox.lightning.force.com/one/one.app
Click "Export"
14

If it's a very large file, it's recommended to download as a CSV rather than an Excel file as it'll download faster. Make sure to then save the file as an excel file, though!

If it's a very large file, it's recommended to download as a CSV rather than an Excel file as it'll download faster. Make sure to then save the file as an excel file, though!

Make this walkthrough your own

Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.