Data Loader

Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience

Available in: Enterprise, Performance, Unlimited, and Developer editions

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, it outputs CSV files.

If commas aren’t appropriate for your locale, use a tab or other delimiter. Specify your delimiter in Data Loader Settings (Settings | Settings).

Note

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.

Data Loader offers the following key features:

An easy-to-use wizard interface for interactive use
An alternate 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
Can be used to process data in both Salesforce and Database.com
Detailed success and error log files in CSV format
A built-in CSV file viewer
Support for Windows and Mac

For each major release, a new version of Data Loader is available in Salesforce Setup. The Data Loader major release corresponds to the API version available.

To get started, see the following topics:

In previous versions, Data Loader has been known as “AppExchange Data Loader“ and “Sforce Data Loader.”

Note

Data Loader Guide

Data Loader