Data Loader Guide

Data Loader
When to Use 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
Uploading Attachments
Upload Content with the Data Loader
Review Data Loader Output Files
Data Import Limits
View the Data Loader Log File
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

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 starts with “success,” and the other starts with “error.” You can use the Data Loader CSV file viewer to open the files.
Available in: Salesforce Classic and Lightning Experience
Available in: Enterprise, Performance, Unlimited, Developer, and Database.com Editions

  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 all the successfully loaded records. The file includes a column with the newly generated record IDs. The error file contains all the rejected records. The file has a column that describes why the load failed.

    If the object you are exporting has a column named “success” or “error,” your output file columns could display incorrect information. To avoid this problem, rename the columns.

    Note

  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. For more information, see Configure Data Loader.

Note