---
schema_version: "1"
id: d0439d0ff335d05b6d88489ee336d6ce031d2b608979bc759ef73a9c73c3b732
title: Mass Update Addresses
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/data_updateaddresses.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.data_updateaddresses.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: e4c879d210e48a11e742124011cb1bcd3be9f1002a3e5631abfb7d519cb4b353
description: When your data is consistent, your reports and related metrics are more accurate and easier to understand. For example, having different abbreviations for a country/territory or state can skew your data. To make your addresses consistent, you can update country/territory and state/province information in existing fields at one time.
products:
  - Salesforce Platform
  - Cross Cloud
release: "264"
---
# Mass Update Addresses

When your data is consistent, your reports and related metrics are more accurate and easier to understand. For example, having different abbreviations for a country/territory or state can skew your data. To make your addresses consistent, you can update country/territory and state/province information in existing fields at one time.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>All</strong> Editions except for <strong>Database.com</strong>.</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d185973e67">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d185973e67 ">To mass update addresses:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d185973e67 ">Modify All Data</td>

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d185973e67 ">To mass update addresses of contracts:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d185973e67 ">
              <p>Modify All Data</p>
              <p>AND</p>
              <p style="margin-bottom:0;">Activate Contracts</p>
            </td>

          </tr>

        </tbody>
      </table>

You can mass update addresses in contacts, contracts, and leads.

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

Tip To ensure data consistency in new records, consider using state and country/territory picklists. Mass Update works with standard address fields, but doesn’t change Custom Address Fields.

1. From Setup, enter Mass Update Addresses in the Quick Find box, then select **Mass Update Addresses**.
2. Select **Countries** or **State/Province**. If you chose State/Province, enter the country or territory in which to update the state or province.
3. Click **Next**.
4. Select the values to update and click **Add**.
    
    The Selected Values box displays the values to update.
    
    The Available Values box displays the address values found in existing records. To find more addresses to update, enter all or part of a value and click **Find**.
    
    If your organization has large amounts of data, instead of using the Available Values box, enter existing values to update in the text area. Separate each value with a new line.
5. In the **Replace selected values with** field, enter the value with which to replace the specified address data, and click **Next**. If your organization has large amounts of data, this field is called **Replace entered values with**.
    
    The number and type of address records to update are displayed. If you have large amounts of data, only the values to update are displayed.
6. To update the values, click **Replace**.

#### See Also

- [Let Users Select States, Countries, and Territories from Picklists](https://help.salesforce.com/s/articleView?id=xcloud.admin_state_country_picklists_overview.htm&release=264.0.0&type=5 "State and country/territory picklists let users select states, countries and territories from predefined, standardized lists, instead of entering state and country/territory data into text fields. State and country/territory picklists offer faster and easier data entry. They help to ensure cleaner data that can be harnessed for other uses—in reports and dashboards, for example. They protect data integrity by preventing typos, alternate spellings, and junk data—even in records updated through the API.")
- [Tips for Mass Updating Addresses](https://help.salesforce.com/s/articleView?id=xcloud.data_updateaddresses_tips.htm&release=264.0.0&type=5 "To save time and ensure that your filter settings are up-to-date, use these tips when you mass update country/territory and state/province information in existing address fields.")