Salesforce exports cap at 2,000 rows and carry a formula injection risk; Power Query's connectors need an API-enabled edition not included in Essentials.
There are four practical ways to get Salesforce data into Excel: the built-in report export, Data Loader or Workbench for raw object data, XL-Connector (the established AppExchange add-in), and Power Query's Salesforce connectors. Each has a meaningful constraint. The report export is simple but caps at 2,000 rows and carries a formula injection risk if your data contains field values that start with =. Power Query needs an API-enabled Salesforce edition, which rules out Essentials and Professional unless you pay for the API add-on. Here is the full picture, including what works on Mac and web Excel.
Method 1: Report export from Salesforce (any edition)
Open any report in Salesforce, click the down arrow next to the Edit button, and choose Export. You get two format options: Formatted Report preserves the report layout with groupings, subtotals, and headers in the way it looks on screen; Details Only gives you a flat CSV or Excel file with one row per record and no summary rows. For any downstream analysis in Excel, Details Only is almost always what you want, because Formatted Report exports with merged cells and subtotal rows that break pivot tables and structured references.
The catch: the export is capped at around 2,000 rows in many Salesforce editions. If your report returns more records, Salesforce will truncate the file without a clear warning. For full object dumps, use Data Loader instead. Also, any field value that begins with =, +, -, or @ may be interpreted as an Excel formula when the file opens. This is a genuine security consideration for data that includes user-generated text like contact names or notes.
Method 2: Data Loader and Workbench (raw object exports)
Salesforce Data Loader is a free desktop application that lets you export all records from any standard or custom object using a SOQL query. It exports to CSV, which you open in Excel. Salesforce Workbench is a browser-based alternative that does the same thing without installing software. Both tools bypass the 2,000-row report limit and can pull millions of records in batches.
The catch: Data Loader requires API access, which means it is available on Enterprise, Unlimited, and Developer editions. Essentials and Professional users need the API add-on. The export contains raw Salesforce IDs for lookup fields (for example, the AccountId on an Opportunity rather than the Account Name), so you may need to run a second export and do a VLOOKUP to resolve human-readable names.
Method 3: XL-Connector (the leading AppExchange Excel add-in)
XL-Connector by Xappex is the most established Excel add-in for Salesforce on AppExchange, with 228 reviews and a 4.8-star rating. It installs into Excel's ribbon and lets you import Salesforce reports, run SOQL queries, and refresh individual sheets or the whole workbook. XL-Connector 365 extends the same functionality to Excel Online through OneDrive or SharePoint.
The catch: XL-Connector is freemium. The first 14 days include full features, but mass insert, update, upsert, and scheduled refresh require a paid license after the trial. It also needs API access, so the same Essentials and Professional edition restriction applies. If your team already uses XL-Connector and it does what you need, it is a mature and well-supported product worth keeping.
Method 4: Power Query Salesforce connectors (Windows Excel only)
Excel for Microsoft 365 on Windows includes two built-in Salesforce connectors under Data, Get Data, From Online Services: From Salesforce Objects (pulls raw object records using the Salesforce API) and From Salesforce Reports (pulls a saved report). Both authenticate with your Salesforce username and password. Once connected, Power Query loads the data into the spreadsheet and can refresh it on demand.
The catch: these connectors require that API Enabled is checked in your Salesforce profile settings. Salesforce Essentials and Professional editions do not include API access by default. Upgrading or purchasing the API add-on is required. The connectors are also Windows-only inside Excel; they do not appear in Excel on Mac or Excel on the web. Salesforce trial accounts have no API access at all.
Method 5: Brooked for Excel (scheduled, Mac and web Excel supported)
Brooked for Excel is an add-in that connects to Salesforce, pulls reports and object data into the worksheet, and keeps it current on a schedule. It runs inside Excel's ribbon and works in Windows desktop, Mac, and Excel on the web, which is the gap Power Query cannot fill. The AI analyst built into the add-in lets you ask questions about your Salesforce data in plain English without building reports manually.
Honest framing: Excel support is in beta. Manual imports and the AI analyst work today; scheduled refresh is rolling out through the beta. The Google Sheets version of the connector is fully live, so the Salesforce plumbing itself is mature.
Setting up the Salesforce connection
Open Brooked in the Excel ribbon, choose Salesforce as the source, and sign in with OAuth. Pick the report or object you want (Opportunities, Accounts, Activities, or a custom object), configure your filters, and import into the active worksheet. The data arrives as a flat table, with lookup field labels resolved, ready for pivot tables.
Brooked AI, SalesforceMethod comparison
| Method | Cost | Works on | Refresh | Best for |
|---|---|---|---|---|
| Report export (UI) | Free, any edition | Any Excel | Manual re-export | One-off report snapshots |
| Data Loader / Workbench | Free, any edition with API | Windows & Mac Excel | Manual re-export | Raw object exports and bulk data |
| XL-Connector (AppExchange) | Freemium, license for full use | Desktop & Mac Excel | Manual refresh in add-in | Teams who want SOQL queries in Excel |
| Power Query (Salesforce connectors) | Included in Microsoft 365 | Windows Excel only | Manual or scheduled via Power Query | Windows users with API-enabled editions |
| Brooked for Excel | Free during beta | Desktop, Mac & web Excel | Scheduled (rolling out in beta) | Live Salesforce data on any edition with API |
What sales and revenue teams build with this
- Weekly pipeline review: Opportunities by stage and owner, refreshed without re-exporting
- Forecast model: live Salesforce actuals feeding the revenue model already built in Excel
- Activity reporting: calls, emails, and tasks per rep for the current quarter
- Account health dashboard: open cases, last activity date, and ARR in one view
- Territory comparison: quota attainment by region using Salesforce data and Excel calculations
Troubleshooting common issues
Related Articles
- How to Connect HubSpot to Excel
- How to Connect Pipedrive to Excel
- How to Connect Salesforce to Google Sheets
Frequently asked questions
Can I export Salesforce reports directly to Excel?
Yes. Open any report in Salesforce, click the down arrow next to Edit, and choose Export. You can export as Formatted Report (which preserves the report layout with groupings and subtotals) or as Details Only (a flat table with one row per record). Details Only is far more useful for pivot tables and formulas in Excel because Formatted Report adds merged headers and subtotal rows that break structured data operations.
Does Salesforce have a native Excel add-in?
Not one built by Salesforce itself. XL-Connector by Xappex is the longest-standing AppExchange add-in for Excel, with 228 reviews and a 4.8-star rating. It lets you run SOQL queries and pull report data into Excel with a refresh button. Salesforce has also worked on Excel integration through its partnership with Microsoft, but there is no first-party Salesforce-built Excel add-in comparable to what Google Sheets users get through Salesforce for Google Workspace.
Does Power Query connect to Salesforce?
Yes, Excel for Microsoft 365 on Windows includes two built-in connectors: From Salesforce Objects and From Salesforce Reports, both under Data, Get Data, From Online Services. The connectors require that your Salesforce edition has API access enabled. Salesforce Essentials and Professional do not include API access unless you purchase the API add-on separately. Enterprise, Unlimited, and Developer editions include API access. The connectors are not available in Excel on Mac or Excel on the web through Power Query.
What is the formula injection risk with Salesforce exports?
If any Salesforce field value starts with =, +, -, or @, Excel may treat it as a formula when the file opens. This is a real risk if contacts or companies have names or notes that start with those characters. An exported field containing =HYPERLINK("https://evil.com","click") would execute in Excel. The Details Only export does not sanitize these values. Open exports from untrusted data sources with Protected View enabled, and review any cells that show formula output you did not expect.
Which Salesforce export method works on Mac and web Excel?
The built-in report export (downloading a file from Salesforce's UI) works on any platform because it is just a file download. XL-Connector also supports Mac Excel and Excel Online through its XL-Connector 365 product. Power Query's Salesforce connectors are Windows-only inside Excel. Brooked for Excel works on Windows desktop, Mac, and Excel on the web.
How do I export a large Salesforce object like all Opportunities to Excel?
The report export in the UI caps at around 2,000 rows. For full object exports, use Salesforce Data Loader (a free desktop app) or Salesforce Workbench (browser-based). Both let you write a SOQL query to pull all records from any standard or custom object. Data Loader exports to CSV which you then open in Excel. For very large objects, split the export using a date filter to stay inside governor limits.
Get live Salesforce data in Excel, on Windows, Mac, and the web.
Brooked for Excel is in beta and free to try. Using Google Sheets instead? Read the Sheets version of this guide.
See Brooked for Excel →
