Data Loader Guide

Data Loader
When to Use Data Loader
Considerations for Installing Data Loader
Configure Data Loader
Using Data Loader
Running in Batch Mode (Windows Only)
Command-Line Quick Start (Windows Only)
Data Loader Third-Party Licenses
PDF

Newer Version Available

This content describes an older version of this product. View Latest

When to Use Data Loader

Available in: both Salesforce Classic and Lightning Experience
Available in: Enterprise, Performance, Unlimited, Developer, and Database.com Editions

Data Loader complements the web-based import wizards that are accessible from the Setup menu in the online application. Refer to the following guidelines to determine which method best suits your business needs:

Use Data Loader when:

  • You need to load 50,000 to 5,000,000 records. Data Loader is supported for loads of up to 5 million records. If you need to load more than 5 million records, we recommend you work with a Salesforce partner or visit the AppExchange for a suitable partner product.
  • You need to load into an object that is not yet supported by the import wizards.
  • You want to schedule regular data loads, such as nightly imports.
  • You want to export your data for backup purposes.

Use the import wizards when:

  • You are loading less than 50,000 records.
  • The object you need to import is supported by import wizards. To see what import wizards are available and thus what objects they support, from Setup, enter Data Management in the Quick Find box, then select Data Management.
  • You want to prevent duplicates by uploading records according to account name and site, contact email address, or lead email address.

For more information about the import wizards, see Import Data Into Salesforce.