Data Loader Explained
Data Loader handles operations on up to 5 million records per job, making it the go-to tool for data migrations, mass updates, and scheduled extracts. It supports CSV input/output and connects via either the Bulk API (optimized for large datasets processed in batches) or the SOAP API (better for smaller, real-time operations). Data Loader can be run interactively through its GUI or automated via command-line mode with process-conf.xml configuration files on Windows.
Key features include field mapping (matching CSV columns to Salesforce fields), upsert via external IDs to avoid duplicates, and hard-delete for permanent removal bypassing the Recycle Bin. Because Data Loader does not enforce validation rules by default in certain API contexts, admins must test in a sandbox before running against production. For teams that want a browser-based alternative without desktop installation, Salesforce also offers the Data Import Wizard for simpler jobs under 50,000 records.
Related Salesforce Terms
Data Import Wizard
The Data Import Wizard is a browser-based Salesforce tool for importing up to 50,000 records into standard and custom objects without desktop software.
Custom Object
A Custom Object is a user-defined database table in Salesforce that stores data specific to your organization's unique business needs.
Custom Field
A Custom Field is a user-defined field added to a standard or custom object in Salesforce to capture data not covered by out-of-the-box fields.
Validation Rule
A Validation Rule is a formula-based check in Salesforce that prevents users from saving a record if the data does not meet specified criteria.