Data Loader is a client application for the bulk import or export of data. Use it to
insert, update, delete, or export Salesforce records. When importing data, Data Loader reads,
extracts, and loads data from comma-separated values (CSV) files or from a database
connection. When exporting, Data Loader outputs CSV files.
Required Editions
Available in: both Salesforce Classic and Lightning Experience
Available in: Enterprise, Performance, Unlimited, and
Developer editions
Data Loader can be used on either MacOS or Windows, and offers these key
features.
An easy-to-use wizard interface for interactive use
An alternative command-line interface for automated batch operations (Windows
only)
Support for large files with up to 5 million records
Drag-and-drop field mapping
Support for all objects, including custom objects
Process data in both Salesforce and Database.com
Detailed success and error log files in CSV format
A built-in CSV file viewer
You can use Data Loader in two different ways:
User interface—Specify configuration parameters and CSV files used for import and
export, and define field mappings that map field names in your import file to field
names in Salesforce.
Command line (Windows only)—Specify the configuration, data sources, mappings, and
actions in files. The command line enables you to set up Data Loader for automated
processing.
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required Cookies
Always Active
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional Cookies
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising Cookies
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.