How to Export Salesforce Data to Excel
Four ways to export Salesforce data to Excel or CSV - reports, Data Loader, the Bulk API, and in-browser SOQL export - and when each one is the right choice.
Updated 2026-09-09
Exporting is the admin task that never goes away: a data audit, a cleanup list, a hand-off to finance. The right method depends on volume, on whether you need fields the report builder will not give you, and on how often you have to repeat it.
The four options below cover almost every case, from a 50-row spot check to a full-object extract.
Option 1 - Reports export
- Best for: business users, recurring exports, anything already reported on.
- Run the report, choose Export, and pick Formatted Report or Details Only.
- Limits: report row limits apply, and you cannot export fields the report type does not expose.
Option 2 - Data Loader
- Best for: large volumes, scheduled extracts, anything scripted.
- Supports the Bulk API for millions of rows and command-line automation.
- Limits: desktop install, separate login, and a SOQL query you must write by hand anyway.
Option 3 - In-browser SOQL export
When you already know the filter, the fastest path is to query and export from the Salesforce tab you are on. TurboKit runs the SOQL, shows the result grid, and exports to CSV or Excel without a desktop tool or a second login.
This is the option that fits the daily pattern - a filtered list, exported once, acted on, and forgotten.
Option 4 - Weekly Data Export
- Setup → Data → Data Export produces a full backup as zipped CSVs.
- Best for: backups and compliance, not for ad-hoc analysis.
- Runs weekly or monthly depending on edition, and the file is available for 48 hours.
Before you export
- Count the rows first (
SELECT COUNT() FROM ...) so you know what you are pulling. - Export IDs alongside the data - without them you cannot import the corrections back.
- Remember that exported data leaves Salesforce's security model; treat the file as sensitive and delete it when the job is done.
Frequently asked questions
- How do I export more rows than the report limit allows?
- Use Data Loader with the Bulk API, or split the export by a date or owner filter. Report exports are capped, and the cap depends on edition and export format.
- Can I export Salesforce data directly to .xlsx?
- Report exports offer a formatted Excel option. Data Loader writes CSV only. TurboKit exports the query result to CSV or Excel from the browser.
- Why are my exported dates shifted by a few hours?
- DateTime values are exported in the running user's time zone or in GMT depending on the tool. Check the user's locale settings before assuming the data is wrong.
More from the Admin How-To
- How to Export Salesforce Reports and List ViewsExport a Salesforce report or list view to CSV or Excel, including the size limits each format hits and when to switch to a SOQL export instead.
- How to Schedule a Recurring Salesforce Data ExportThree ways to get a Salesforce data export on a schedule - the native Weekly Export, a scheduled Bulk API job, and the difference between a backup and a working dataset.
- How to Mass Update Salesforce Records SafelyA safe procedure for mass updating Salesforce records: scope with SOQL, snapshot before, batch the import, and verify after - with the automation traps to check first.
- Change Sets vs Metadata API Deployments: Which to UseChange sets and Metadata API / CLI deployments solve the same problem differently. Here is when each one is the right choice, and what a change set genuinely cannot do.
- How to Check Field-Level Security in Salesforce FastCheck field-level security in Salesforce without clicking through Setup: where FLS lives, how it interacts with profiles and permission sets, and faster ways to read it.
- How to Check Salesforce Org LimitsCheck Salesforce org limits - API calls, data storage, file storage, and daily email - from Setup, the limits API, and the browser, before you hit them.