Exporting Salesforce Data With Data Loader [Screenshots]

Photo of author
Jerome Clatworthy

Certified Salesforce Administrator

Data Loader makes it quick and easy to export data directly from Salesforce, without needing to navigate reports or exports from inside the Salesforce platform.

To export data from Salesforce with Data Loader you will need to have Data Loader installed on your computer.

When exporting data with Data Loader, Data Loader provides you with a friendly user interface to create a SOQL (Salesforce Object Query Language) statement that will identify the Objects and corresponding fields you will export from in the Salesforce database.

1. Open Data Loader and Select ‘Export’

Screenshot of Salesforce Data Loader home screen.
Choose ‘export’ from the available Data Loader options.

2. Select Data Objects

Choose the Objects you want to export from, and where on your computer you wish to save the export file. In this example, I will choose the Account object.

Screnshot of Salesforce Data Loader Object selection screen.
Choose the Object to export

3. Edit Your Query

Based on the Object you selected, you will then be able to choose which fields from the Object that you want included in the Export.

Screenshot of Salesforce Data Loader SOQL Query edit screen.
Set up your SOQL query

Once you have selected your fields, you can also filter the records that will be included using various operations. This enables you to only include records that meet certain criteria.

RELATED RESOURCE: Import Data With Data Loader

Screenshot of Salesforce Data Loader query filtering options.
Add filters to your SOQL query

As you refine the fields, and the clauses, the SOQL statement that will retrieve your records is created, and visible.

Once you have defined the fields and inclusion clauses for your export, choose Finish.

A pop-up confirmation will ask you to confirm that you wish to proceed.

Screenshot of Salesforce Data Loader export confirmation screen.
Confirm the export

The SOQL query will execute and generate a CSV file including the selected records, and an Operation Finished message will appear with a link to the extraction.

Screenshot of Salesforce Data Loader export completion screen.

You can view the records by navigating to the local folder you saved the file and opening the CSV with Excel or Google Sheets, or use the inbuilt CSV viewer.

If you have a large number of records, then the built-in viewer is not suitable for viewing the whole data set, but you can quickly check if the data set meets your requirements.

Screenshot of Salesforce Data Loader exported record viewer.
The view is useful to check a small number of records.