Upsert Salesforce Data
Upsert is a combination of Updating and Inserting. If a record in a file matches an existing record, the existing record is updated with the values in your file. The record is created as a new entity if no match is found.
The following articles describe using Single Dataloader to upsert data into Salesforce via a CSV file.
Log in to your ARM account.
Hover your mouse over the
Dataloader
module and selectDataloader
.Click
Upsert
on the right side of the screen.

Choose your
Salesforce Org
and your org environment (Production or Development Edition
,Sandbox
, orPre-Release
).The corresponding
URL
and yourUsername
are automatically generated based on the above selection.Click
Login and Fetch Objects
.

Select the object you wish to upsert data into (e.g.,
Account
,Contact
,Lead
). Use thesearch
function andfilter
button for convenience.Click
Next
.

Upload your CSV file by clicking the
Upload
button.

Click
OK
on the notification popup showing impacted records.

Prepare field mappings: match CSV columns to Salesforce fields.
Use
Automap
to match fields automatically if names align.

Confirm all required fields are mapped, then click
Next
.

Process Summary Options
Name: Assign a name to the job.
Category: Organize processes by categories (create new or use existing).
External ID Field: Specify unique identifier other than Salesforce ID (e.g., ERP ID).
Object: Displays the object being upserted.
Operation Type: Displays Upsert.
Impacted Records: Shows record count.
Use Bulk API: Enable for large datasets for improved throughput.
You can also schedule tasks as Daily, Weekly, or On-demand. Click Save
to store and run later.
The task appears in the Dataloader Summary list.
Click
Run
to execute the task immediately.

Dataloader Configuration Options
Use Bulk API
Optimized for large datasets; supports serial or parallel processing. Recommended to use Serial Mode if other jobs are in progress.
Batch Size
Applies if Bulk API is disabled. Based on SOAP and better for smaller datasets.
Disable workflow rules
Deactivates workflows during operation and reactivates post-process.
Disable Validation Rules
Deactivates validation rules during the process and re-enables afterward.
Insert/Update with null values
Allows null value updates in destination org.
Use UTF-8 file encoding
Required for data containing English alphabets. Disable for non-English content.
Click
Run
to begin.

Results Monitoring
Results of Last Run: Shows success/failure record count dynamically.
Records: Displays the total records affected.

More Options

Edit: Update job configuration.
Abort: Stop a running job.
Schedule: Set periodic execution.
Delete: Remove the job.
Log: View execution logs.
VR/WFR: View validation/workflow rules. See Validation/ Workflow Rules.
Clone: Create a copy of the process with an option to choose a different data file.

Last updated
Was this helpful?