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
| Available in: both Salesforce Classic and Lightning Experience |
| Available in: All Editions except for Database.com. |
| User Permissions Needed | |
|---|---|
| To mass update addresses: | Modify All Data |
| To mass update addresses of contracts: |
Modify All Data AND Activate Contracts |
You can mass update addresses in contacts, contracts, and leads.
- From Setup, enter Mass Update Addresses in the Quick Find box, then select Mass Update Addresses.
- Select Countries or State/Province. If you chose State/Province, enter the country or territory in which to update the state or province.
- Click Next.
-
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.
-
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.
- To update the values, click Replace.