Salesforce Data Loader is a desktop client application that allows users to insert, update, delete, and export large amounts of data in Salesforce. It is a free tool provided by Salesforce and can be used by any Salesforce user with appropriate permissions.
In this article, I will demonstrate how to use Data Loader to import data into Salesforce.
I have a CSV file with some fictional Account records that I will add to a Trailhead Playground Org and demonstrate each step with explanations and screenshots.
To follow along you will need to install Data Loader onto your computer if you haven’t already.
Table of Contents
1. Open Data Loader and Login
Open Data loader and click Insert . This will prompt you to first log in to the Org that you wish to add new records to.
(This guide will show you how to connect Data Loader to your Trailhead Playground Org if you are having troubles).
![Screenshot of Salesforce Data Loader home screen.](https://jeromeclatworthy.com/wp-content/uploads/2023/08/image-321.png)
RELATED RESOURCE: Getting Data In And Out of Salesforce
2. Select Object and Upload File
Choose the object that you want to insert new records into and upload the CSV file that includes the new records, then select Next.
![Screenshot of Salesforce Data Loader Object selection screen.](https://jeromeclatworthy.com/wp-content/uploads/2023/08/image-322.png)
A confirmation message will appear confirming the data upload and how many records, were found.
![Screenshot of Salesforce Data Loader Data Selection confirmation screen.](https://jeromeclatworthy.com/wp-content/uploads/2023/08/image-323.png)
3. Map CSV Fields to Object Fields
The current mapping (or lack thereof) will appear, and you need to choose Create or Edit a Map to adjust the field mapping.
![Screenshot of Salesforce Data Loader Field Mapping screen.](https://jeromeclatworthy.com/wp-content/uploads/2023/08/image-325.png)
Drag the Object field name from the list down to the corresponding CSV column header, then choose OK.
![Screnshot of Salesforce Data Loader field mapping screen.](https://jeromeclatworthy.com/wp-content/uploads/2023/08/image-326.png)
With mapping updated, select Next.
![Screenshot of Salesforce Field Mapping confirmation screen.](https://jeromeclatworthy.com/wp-content/uploads/2023/08/image-328.png)
4. Choose Results Folder
Each insert batch will generate a results report, indicating which records were successfully imported and which ones failed. Select a folder for this report to be saved to, then choose Finish.
![Screenshot of Salesforce Data Loader Export file save location screen.](https://jeromeclatworthy.com/wp-content/uploads/2023/08/image-329.png)
5. Insert The Records
A final confirmation box will appear asking you to confirm the insert operation.
![Screenshot of Salesforce Data Loader final confirmation screen.](https://jeromeclatworthy.com/wp-content/uploads/2023/08/image-330.png)
6. Check The Results of Your Import
![Screenshot of Salesforce Data Loader import job completion screen.](https://jeromeclatworthy.com/wp-content/uploads/2023/08/image-331.png)
A dialogue box will appear, giving you a high-level overview of the results of the operation you just completed.
A CSV file will also be saved to the folder you selected in previous steps.
![Screenshot of Windows File explorer with a file name highlighted.](https://jeromeclatworthy.com/wp-content/uploads/2023/08/image-332.png)
Then one final confirmation is to look at the list of recently added records on the Account Object in my Trailhead Playground Org, and I can see the nine new records added, in addition to the other new records I recently added via other means.
![Screenshot of Salesforce Account Record List.](https://jeromeclatworthy.com/wp-content/uploads/2023/08/image-333-1024x622.png)