---
schema_version: "1"
id: 23aeb092cf439f569066c3ab905016fbf884e022d7ded670952765d2823bc7dd
title: Convert State and Country/Territory Data
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/admin_state_country_picklists_convert_data.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.admin_state_country_picklists_convert_data.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 06304ba119aa28991634c0663f8203b171021ef58b8d63e4d461d47216676a48
description: To convert text-based state and country/territory data to picklist-compatible values, select specific text values and choose the standard values you want to map them to. For example, you can select all occurrences of “USA” and change them to “United States.”
products:
  - Salesforce Platform
  - Cross Cloud
release: "264"
---
# Convert State and Country/Territory Data

To convert text-based state and country/territory data to picklist-compatible values, select specific text values and choose the standard values you want to map them to. For example, you can select all occurrences of “USA” and change them to “United States.”

### 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 Database.com</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="d53911e64">User Permissions
              Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d53911e64 ">To convert text-based state and country/territory data:</td>

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

          </tr>
        </tbody>
      </table>

Before you convert state, country, and territory values in State and Country/Territory Picklists setup, [configure the picklists for your org](https://help.salesforce.com/s/articleView?id=xcloud.admin_state_country_picklists_configure.htm&release=264.0.0&type=5 "Configuring state and country/territory picklists means choosing which states and countries you want to be available in your Salesforce org. It lets you make state and country/territory picklists available for purposes like importing data, working with external systems, and accessing picklist data from the Metadata API."). That way, the data in your org is consistent and accurate when you enable picklists, because all new and updated records use your specified integration value.

Convert countries first, and then states and provinces.

You can convert up to 2,000 country/territory values and up to 2,000 state values. However, state and country/territory picklists that contain more than 1,000 states or countries can degrade performance.

1. From Setup, enter State and Country/Territory Picklists in the Quick Find box, then select **State and Country/Territory Picklists**.
2. On the State and Country/Territory Picklists page, click **Convert identified data**.
    
    Salesforce opens the Convert States, Countries, and Territories page. This page displays all the country and territory text values that appear in your org and the number of times each value is used.
3. Select Change for one or more values you want to convert. For example, select Change for all the iterations of United States.
4. In the Change To area, choose the country or territory that you want to convert the text values to and click **Save to Changelist**.
    
    ![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 If you map states or countries to Unknown value, users see states and countries in their records. However, your users encounter errors when they save records, unless they change each state, country, and territory to a valid value before saving.
5. Repeat Steps 3 and 4 for other country and territory values, such as for Canada.
    
    Salesforce tracks planned changes in the Changelist area.
6. When all the countries are mapped, click **Next** to convert state values.
    
    Use the Country of Origin column to identify the country or territory associated with that state or province.
7. To convert the values and turn on state and country/territory picklists in your org, click **Finish and Enable Picklists** on the Confirm Changes page. Or, to return to the State and Country/Territory Picklists page, click **Finish**.

#### 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.")

## Edit Converted Picklist Mappings

Edit existing picklist data mappings from the Convert Countries or Convert States page in Setup.

1. In Setup, find and select **State and Country/Territory Picklists**.
2. In the Enable State and Country Picklist section, select **Convert identified data**.
3. To revert a value in your changelist, select **Undo**.

You can convert state, country, and territory values even after saving your changelist and enabling the picklist. After picklists are enabled, you can no longer edit your conversion mappings. To make changes to picklist after it's enabled, you must disable the picklist and re-scan and convert your scanned data.

## Clear Scanned and Converted Picklist Mappings

If your converted data mappings are in a unrecoverable state, you can clear your scanned and mapped state and country data, and start again.

Clearing scanned and mapped data wipes out all the work you've done to convert scanned data to picklist entries. Use this feature only if you're unable to individually edit and revert your picklist data mappings.

1. In Setup, find and select **State and Country/Territory Picklists**.
2. From the State and Country/Territory Picklists page, locate the Enable State and Country/Territory Picklists section and select **Scan for State and Country Picklist data**.
3. From the Scan for Affected Data and Customizations page, select **Clear Scanned and Mapped Data**.