Data Loader Guide

Data Loader
When to Use Data Loader
Install Data Loader
Configure Data Loader
Using Data Loader
Data Types Supported by Data Loader
Export Data
Define Data Loader Field Mappings
Insert, Update, or Delete Data Using Data Loader
Upload Attachments
Upload Content with the Data Loader
Review Data Loader Output Files
Data Import Dates
View the Data Loader Log File
Configure the Data Loader Log File
Run 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

Review Data Loader Output Files

After an import or export, Data Loader generates two CSV output files that contain the results of the operation. One file name begins with success, and the other starts with error. Both files have the extension .csv. Use the Data Loader CSV file viewer to open the files. Specify the folder containing success and error CSV files in the Finish step of an operation.

Export operations don’t generate a success file by default. To generate a success file when exporting data, check Generate status files for exports in the Advanced Settings dialog.

Note

  1. Choose View | View CSV.
  2. Specify the number of rows to view. Each row in the CSV file corresponds to one Salesforce record. The default is 1,000.
  3. To view a specific CSV file, click Open CSV. To view the last success file, click Open Success. To view the last error file, click Open Error.
  4. To open the file in an external program, such as Excel, click Open in External Program.

    The success file contains the successfully loaded records, including a column with the newly generated record IDs. The error file contains the rejected records, with a column that describes why the load failed. If the object you’re exporting has a column named “success” or “error”, your output file columns could display incorrect information. To avoid this problem, rename the columns.

  5. To return to the CSV Chooser window, click Close. To exit the window, click OK. To generate success files when exporting data, select Generate status files for exports.