---
schema_version: "1"
id: f2396d72ee1366e46e3e1b63980e22684fb9f11f8e328d46ccb3684b19117e39
title: How do I use the Data Import Wizard to update records that match specified Salesforce IDs?
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/faq_import_general_update_with_import_wizard.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.faq_import_general_update_with_import_wizard.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 953db5cb152cac5e7996767ca1db26df834230abba4e2f2be8b1f82f489f4704
description: You can use the Data Import Wizard to update leads, contacts, or accounts using the record’s ID as the unique identifier. These steps don’t apply to custom objects.
products:
  - Salesforce Platform
  - Cross Cloud
release: "264"
---
# How do I use the Data Import Wizard to update records that match specified Salesforce IDs?

You can use the Data Import Wizard to update leads, contacts, or accounts using the record’s ID as the unique identifier. These steps don’t apply to custom objects.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-setup-264-0-0-production-enus/6f21df35-9ea0-4f53-ac94-45c3b5dfd5bc/images/icon_note.png)

Note These steps assume that you have an administrator-level of knowledge with Salesforce.

After you have prepared the data and updated the report, import the CSV file into Salesforce. The steps vary based on the records you're updating.

#### See Also

- [Data Import Wizard](https://help.salesforce.com/s/articleView?id=xcloud.data_import_wizard.htm&release=264.0.0&type=5 "You can use the Data Import Wizard to import accounts, contacts, leads, solutions, campaign members, person accounts, and custom objects. You can import up to 50,000 records at a time.")

## Prepare the Data

Before you begin, prepare the data you're updating.

1. Create a tabular report for the records you're updating, including the record ID and the fields you're updating.
2. Save the report locally as a .csv file for backup purposes.
3. To create a version of the .csv file and make your changes to the data, click **Save As**.
4. Click **Save**.

## Update Leads

1. From Setup, enter Data Import Wizard in the Quick Find box, then select **Data Import Wizard**.
2. Click **Launch Wizard**.
3. Select **Leads**, then select **Update existing records**.
4. Set Match Lead by to Salesforce.com ID.
5. Select the CSV file that contains your import data, and click **Next**.
6. Map the Lead ID field to the Lead ID column in your CSV file, and map the other fields.
7. Click **Next**.
8. Review the import settings, and then click **Start Import**.

## Update Accounts or Contacts

1. From Setup, enter Data Import Wizard in the Quick Find box, then select **Data Import Wizard**.
2. Click **Launch Wizard**.
3. Select **Accounts and Contacts**, then select **Update existing records**.
4. Set Match Contact by to Salesforce.com ID.
5. Set Match Account by to Salesforce.com ID.
6. Select Update existing Account information.
7. Select the CSV file that contains your import data, and click **Next**.
8. Map the contact ID, phone, and address fields to the relevant columns in your CSV file.
9. Map the account ID and other fields to the relevant columns in your CSV file.
10. Click **Next**.
11. Review the import settings, and then click **Start Import**.

The Data Import Wizard matches the record IDs in your file with the record IDs in Salesforce and updates the fields that were mapped.