Data Loader

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.

Image of Data Loader step 2, select Salesforce object.

Data Loader can be useful for loading data into testing environments, such as Developer Pro sandboxes that don’t contain any data. For regression testing, it’s advisable to use a stable set of data that doesn’t change from release to release, so it’s useful to store a set of data locally and use Data Loader to populate your test environment. Data Loader has a command-line interface so that scripts can automatically load data into a fresh organization.

Note
Data Loader is strictly a tool for loading data, not metadata. You can’t add or delete fields on an object or load any kind of setup changes.

To import data, you can use either the import wizards or Data Loader. 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 of importing best suits your business needs:

Use Web-based importing when:
Use Data Loader when:

For more information on importing data, see “Importing Overview” in the Salesforce online help and the Data Loader Guide.

© Copyright 2000–2014 salesforce.com, inc. All rights reserved.
Various trademarks held by their respective owners.