Data Loader
The Force.com platform offers you a development environment which you can use to create your own custom applications. Frequently, you will use the Force.com platform to create applications that operate on data that you already have in some form - in comma-separated variable files, spreadsheets or other relational databases.
The Data Loader is an easy to use graphical tool that helps you to get your data into Force.com objects via insert and upsert operations. The Data Loader can also be used to export data from Force.com objects into any of the destinations mentioned above. You can even use the Data Loader to perform bulk deletions by exporting the ID fields for the data you wish to delete and using that source to specify deletions through the Data Loader.
The Apex Data Loader requires the use of the Force.com API (Enterprise, Unlimited and Developer Editions).
Download
If your Salesforce edition allows the use of the API , you can download the Data Loader from the Setup menu, under Administration Setup > Data Management > Data Loader.
Features
Features of the Data Loader include:
- An easy-to-use wizard interface
- An alternate command line interface
- A batch mode interface with database connectivity
- Support for large files with up to millions of rows
- Drag-and-drop field mapping
- Support for all objects, including custom objects
- Detailed success and error log files in CSV format
- A built-in CSV file viewer
- Supported on Windows 2000, XP, and Vista
Official Documentation
- PDF
- (Audience: Administrators) Information on how to use the Force.com Data Loader to perform bulk import or export of data in a Salesforce organization.
Additional Resources
For more detailed information about the use of Data Loader, check out:
- An introductory video on getting started with Data Loader
- An article Using Data Loader from the command line on running Data Loader from the command line for non-interactive operation
- A blog post on importing attachments with Data Loader
- One user's experience (PDF) on using Data Loader from the command line, including parameter descriptions and how to encrypt passwords.
- This course on the topic of migrating data into Salesforce
- Additional detail on importing data into related lists, using External IDs.
Other Loading Options
- Another option for loading and unloading data from Salesforce objects is the Force.com Excel Connector, an open source project available for download (Developerforce membership required).
- The Data Loader uses the Force.com API. Because of this dependence, the Data Loader is only available to Unlimited, Enterprise and Developer users.