Getting data out of Salesforce sounds simple until you are staring at five different export options, each with its own limits, formats, and scheduling rules. Pick the wrong method and you end up with truncated fields, expired download links, or a CSV that breaks on import.
This guide walks through every practical way to export data from Salesforce — the Data Export Service, Data Loader, dataloader.io, report exports, and APIs — with current limits, step-by-step guidance, and the security considerations most teams overlook.
Salesforce data export is the process of extracting records, files, and attachments from your Salesforce org into CSV files or other formats for backup, migration, integration, or analysis. It matters for any admin, operations leader, or IT team responsible for data protection, system migrations, or reporting. This guide helps you choose the right export method for your situation, avoid the common pitfalls (expired files, truncated text, edition-based limits), and set up a repeatable export process. Vantage Point helps businesses design data migration and integration strategies that include reliable, secure export routines.
Salesforce data export is any method of extracting data from your Salesforce org into files you control — typically CSV files bundled in a zip archive, spreadsheet exports, or API-driven data feeds. Businesses use exports for backups, migrations to new systems, integrations with data warehouses, audits, and offline analysis.
Salesforce provides native tools for this, and a healthy ecosystem of third-party options fills the gaps. The right choice depends on how much data you have, how often you need it, and who is doing the work.
CRM data is an operational asset. Teams need reliable exports for four reasons:
A deliberate export strategy is cheaper than an emergency recovery project.
Here is the practical comparison. Details on each method follow.
| Method | Best For | Key Limits |
|---|---|---|
| Data Export Service (native, in Setup) | Scheduled full-org backups of records and files | Manual export once every 7 days (weekly) or 29 days (monthly); weekly only in Enterprise, Performance, and Unlimited Editions; zip files deleted 48 hours after the email |
| Data Loader (free desktop app) | Large, selective exports; automation via command line | Up to 5 million records with Bulk API; up to 150 million with Bulk API 2.0; requires API access |
| dataloader.io (browser-based) | Quick cloud exports without installing software | Free tier has monthly record limits; paid plans raise volume and add scheduling |
| Report export (Lightning reports) | Ad-hoc, user-friendly extracts for analysis | Formatted matrix exports cap at 2,000 rows; tabular/summary Details Only exports up to 100,000 rows and 100 columns; long text fields truncate at 255 characters in formatted exports |
| APIs (REST, SOAP, Bulk API 2.0) | Automated, incremental feeds into other systems | Governed by org API limits; requires development resources |
The Data Export Service is Salesforce's built-in backup-style export, accessible from Setup with no installation.
Critical detail: the download link expires. Zip files are deleted 48 hours after the email is sent, and large exports are split across multiple zip files. Download everything promptly and move it to controlled storage.
Edition limits matter here. Weekly exports (manual every 7 days or scheduled weekly) are available in Enterprise, Performance, and Unlimited Editions. Professional and Developer Editions are limited to one export every 29 days — monthly only.
Data Loader is Salesforce's free desktop application for high-volume imports and exports. It runs on Windows and macOS, through a point-and-click interface or the command line.
Data Loader supports up to 5 million records per job with the Bulk API and up to 150 million records with Bulk API 2.0. The command-line interface lets you schedule exports with Windows Task Scheduler or cron, which makes it the workhorse for repeatable, automated extracts without buying additional software.
dataloader.io is a browser-based tool (no installation) with a clean interface, scheduling, and cloud storage connections. It is a good fit for admins who want Data Loader-style power without a desktop install. The free tier carries monthly record limits; paid tiers raise volumes and unlock more automation.
Report exports are the fastest option for business users. Build a report in Lightning, click Export, and choose Formatted Report or Details Only. Know the limits: formatted matrix exports cap at 2,000 rows, tabular and summary Details Only exports reach 100,000 rows and 100 columns, and long or rich text fields truncate at 255 characters in formatted output. Exports can also time out on very large reports — split the report with filters if that happens. Use report exports for analysis, not for backups.
APIs are the right answer when exports feed other systems on a schedule. REST and SOAP queries handle smaller, incremental pulls; Bulk API 2.0 query jobs handle large extracts. This route requires development work and consumes your org's API allocations, but it is the foundation of every serious integration and data warehouse pipeline. If your team is weighing these options, our workflow automation and process optimization work often starts with exactly this decision.
Every export is a full copy of your customer data sitting outside Salesforce's controls. Treat it accordingly.
For organizations with formal obligations, our compliance and security solutions team helps design export governance that stands up to audits.
Vantage Point is a boutique, senior-led Salesforce and HubSpot consulting partner. We help businesses design data export, backup, and migration processes that are secure, automated, and documented — not dependent on one admin's memory.
Senior consultants only — no junior handoffs; the experts you meet are the experts who deliver.
With the native Data Export Service, you can run a manual export once every 7 days (weekly) or once every 29 days (monthly), and you can schedule automatic exports at the same intervals. Weekly exports require Enterprise, Performance, or Unlimited Edition; Professional and Developer Editions are limited to monthly exports. Other tools like Data Loader, dataloader.io, and APIs have no such frequency cap — only record volume and API limits.
No — it is a data extraction tool, not a true backup and restore product. It produces CSV files of your data (and optionally files and attachments), but it does not capture metadata, and there is no built-in way to restore from those files. Businesses that need point-in-time recovery should evaluate dedicated Salesforce backup solutions alongside the native export.
The Data Export Service is a browser-based tool in Setup designed for scheduled, full-org exports of many objects at once. Data Loader is an installable desktop application built for selective, high-volume exports of specific objects using SOQL queries, with command-line automation. Use the Data Export Service for org-wide backup-style extracts and Data Loader for targeted or automated jobs.
Data Loader supports exports of up to 5 million records per job using the Bulk API, and up to 150 million records using Bulk API 2.0. For most business use cases, the practical constraint is your org's API limits and the tool you use to open the resulting CSV — Excel, for example, caps at 1,048,576 rows.
Formatted report exports in Lightning truncate long text and rich text fields to 255 characters. To capture full field content, export using the Details Only option as a CSV or XLS file instead of a formatted report.
Zip files created by the Data Export Service are deleted 48 hours after the completion email is sent. Download your files immediately and store them in a secure, governed location — the link will not work after the window closes.
Yes. The Data Export Service supports scheduled weekly or monthly exports (edition-dependent). Data Loader's command-line interface can be scheduled with Windows Task Scheduler or cron. dataloader.io offers scheduled cloud exports on paid plans, and Bulk API 2.0 query jobs support fully custom pipelines. Vantage Point regularly builds these automated routines as part of managed services engagements.
Only if you ask for them. In the Data Export Service, you must explicitly select the options to include images, documents, attachments, and Salesforce Files — they are excluded by default. Data Loader can export Attachment and ContentVersion records with targeted queries, though binary content requires additional handling.
Ready to build a reliable, secure Salesforce data export process? Whether you need a one-time migration, automated backup routines, or a full integration pipeline, Vantage Point's senior consultants can assess your current state and design a practical plan. Contact Vantage Point to start the conversation.
Vantage Point is a boutique CRM consulting firm helping businesses transform with Salesforce, HubSpot, and AI. Senior consultants only — no junior handoffs; the experts you meet are the experts who deliver. Learn more at vantagepoint.io.