Data Loader Guide

Data Loader
When to Use Data Loader
Installing Data Loader
Install Data Loader on macOS
Install Data Loader on Windows
Considerations for Installing Data Loader
Uninstall 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

Install Data Loader on Windows

You can use Data Loader to insert, update, delete, and export Salesforce records. To use it, you install it on your Windows computer.
Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience
Available in: Enterprise, Performance, Unlimited, and Developer editions

User Permissions Needed
To use Data Loader: API Enabled

AND

The appropriate user permission for the operation you’re doing, for example, Create on accounts to insert new accounts

AND

Bulk API Hard Delete (only if you configure Data Loader to use Bulk API to hard-delete records)

For each major release, a new version of Data Loader is available at https://developer.salesforce.com/tools/data-loader. See the Salesforce Release Notes for the most current information. The Data Loader major release corresponds to the API version available.

  1. Install Java Runtime Environment (JRE) version 11 or later, for example, Zulu OpenJDK version 11 or later for Windows. To install:
    1. Open the link and scroll down to "Download Azul Zulu Builds of OpenJDK".
    2. For Java Version, select your java version of choice, or the latest version.
    3. For Operating System, select Windows.
    4. For Architecture, select your computer's architecture.
    5. From Java Package, select JRE.
    6. Scroll down to the top results, and download either the .zip or .msi file that corresponds to your computer's architecture.
    7. Complete the installation. For installation help, click the How to install? link next to your download button.
  2. Navigate to your org’s Setup page. Enter Data Loader in the Quick Find box, and select Data Loader.
  3. Click Downloads. The Salesforce Data Loader page opens in your browser.
  4. Select your operating system, and select a release to start downloading the installation .zip file. Optionally, verify that the downloaded Data Loader zip file is signed by Salesforce by running the command jarsigner -verify dataloader_win_<version>.zip. Replace <version> with the version string in the download's filename. For example,
    1jarsigner -verify dataloader_win_v56.0.2.zip
  5. After the download completes, right-click the .zip file and select Extract All.
  6. In the Data Loader folder, double-click the install.bat file. If you get an unknown publisher error message, you can ignore it and run the file.
  7. Specify where to install Data Loader, and select whether to overwrite an existing Data Loader installation.
  8. Specify whether to create a Data Loader launch icon on your desktop or a start menu shortcut. Data Loader completes the installation.

To run Data Loader, use the Data Loader desktop icon, start menu entry, or the dataloader.bat file in your installation folder. If Zulu OpenJDK isn’t found, a message prompts you to download and install it.

To continue using your settings from an earlier Data Loader version in version 45 and later, migrate your config and log files after installation. Search for config.properties and log-config.xml, and copy or move the files to your current Data Loader’s /config folder.

Note