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 macOS

You can use Data Loader to insert, update, delete, and export Salesforce records. To use it, you install it on your macOS 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 macOS. 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 macOS.
    4. For Architecture, select your computer's architecture.
    5. From Java Package, select JRE.
    6. Scroll down to the top results, and download a 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.
  5. After the download completes, right-click the .zip file and select Extract All. Optionally, verify that the downloaded Data Loader zip file is signed by Salesforce by running the command jarsigner -verify dataloader_mac_<version>.zip. Replace <version> with the version string in the download's filename. For example,
    1jarsigner -verify dataloader_mac_v56.0.2.zip
  6. In the Data Loader folder, double-click the installer.command file. If you can’t open the file because of an unidentified developer message, press the Control key while clicking the installer.command file, and select open from the menu.
  7. Specify where to install Data Loader.
  8. Specify whether to add a Data Loader launch icon on your desktop or Applications folder. Data Loader completes the installation.

To run Data Loader, use the Data Loader desktop icon, Applications folder, or dataloader.command 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

Running Data Loader on Mac M1 Hardware

“M1” is the new Apple-designed System on a Chip (SoC) that's been developed for use in Macs. While Salesforce updates Data Loader periodically to support the latest operating system releases, the time frame for doing so depends on support from underlying third-party libraries. If you’re running macOS on Mac M1 hardware, errors on your console indicate that the Eclipse SWT library, required by Data Loader, isn’t supported on Mac M1. Explicit support for the Eclipse SWT library (or lack thereof) on Mac M1 is still unknown. Try running Data Loader in Intel emulation mode using Rosetta 2 to see if emulation mode enables Eclipse SWT to work correctly. Here’s Apple's support article on enabling Rosetta 2: https://support.apple.com/en-us/HT211861.

To run Data Loader on Mac M1 hardware:

  1. Open Terminal and run the command:
    1/usr/sbin/softwareupdate --install-rosetta
  2. Make sure you have Java Runtime Environment (JRE) version 11 or later, such as Zulu OpenJDK version 11 or later for macOS x86 64-bit architecture installed on your Mac M1. Native JRE for ARM architecture doesn’t work in this scenario.
  3. Run the installer.command file from the Data Loader folder that you downloaded. For details about this step, see the procedure at the top of this page.