Company Blog Support
Martin Cogburn
posted

Contents

    Back to Top

    Importing Contacts: Formatting State and Country Fields

    Why do this?

    In order for your imports to pass over the correct state and country fields, make sure that these two fields follow the formats below. For example, if your contacts have the country listed as "USA", this must be changed to "US" or "United States".

    How to find/replace values in Microsoft excel

    On a PC

    1. Click to highlight an entire column

    2. Press Ctrl + F to bring up the find command

    3. Select the Replace tab

    4. In the Find what box, type the text you’d like to find (i.e. USA)

    5. In the Replace with box, type a value (such as US)

    6. Click Replace All

    On a Mac

    1. Click to highlight an entire column

    2. Press Ctrl + F to bring up the find/replace command

    3. In the Find what box, type the text you’d like to find (i.e. USA)

    4. In the Replace with box, type a value (Such as US)

    5. Click Replace All

    Proper formatting of state/country fields

    STATES

    AL=Alabama

    AK=Alaska

    AZ=Arizona

    AR=Arkansas

    CA=California

    CO=Colorado

    CT=Connecticut

    DE=Delaware

    DC=D.C.

    FL=Florida

    GA=Georgia

    HI=Hawaii

    ID=Idaho

    IL=Illinois

    IN=Indiana

    IA=Iowa

    KS=Kansas

    KY=Kentucky

    LA=Louisiana

    ME=Maine

    MD=Maryland

    MA=Massachusetts

    MI=Michigan

    MN=Minnesota

    MS=Mississippi

    MO=Missouri

    MT=Montana

    NE=Nebraska

    NV=Nevada

    NH=New Hampshire

    NM=New Mexico

    NJ=New Jersey

    NY=New York

    NC=North Carolina

    ND=North Dakota

    OH=Ohio

    OK=Oklahoma

    OR=Oregon

    PA=Pennsylvania

    RI=Rhode Island

    SC=South Carolina

    SD=South Dakota

    TN=Tennessee

    TX=Texas

    UT=Utah

    VT=Vermont

    VA=Virginia

    WA=Washington

    WV=West Virginia

    WI=Wisconsin

    WY=Wyoming

    AB=Alberta

    BC=British Columbia

    MB=Manitoba

    NB=New Brunswick

    NL=Newfoundland and Labrador

    NS=Nova Scotia

    NT=Northwest Territories

    NU=Nunavut

    ON=Ontario

    PE=Prince Edward Island

    QC=Quebec

    SK=Saskatchewan

    YT=Yukon

    ACT=(AU) Australian Capital Territory

    NSW=(AU) New South Wales

    VIC=(AU) Victoria

    QLD=(AU) Queensland

    AU_NT=(AU) Northern Territory

    AU_WA=(AU) Western Australia

    SA=(AU) South Australia

    AU_TAS=(AU) Tasmania

    GP=(ZA) Gauteng

    WP=(ZA) Western Cape

    EC=(ZA) Eastern Cape

    KZN=(ZA) Kwa-Zulu Natal

    NW=(ZA) North West

    AF_NC=(ZA) Northern Cape

    MP=(ZA) Mpumulanga

    FS=(ZA) Free State

    COUNTRIES

    US=United States

    CA=Canada

    GB=United Kingdom

    AF=Afghanistan

    AL=Albania

    DZ=Algeria

    AS=American Samoa

    AD=Andorra

    AO=Angola

    AI=Anguilla

    AG=Antigua And Barbuda

    AR=Argentina

    AM=Armenia

    AW=Aruba

    AU=Australia

    AT=Austria

    AZ=Azerbaijan

    BS=Bahamas

    BH=Bahrain

    BD=Bangladesh

    BB=Barbados

    BY=Belarus

    BE=Belgium

    BZ=Belize

    BJ=Benin

    BM=Bermuda

    BT=Bhutan

    BO=Bolivia

    BA=Bosnia And Herzegowina

    BW=Botswana

    BV=Bouvet Island

    BR=Brazil

    IO=British Indian Ocean Territory

    BN=Brunei Darussalam

    BG=Bulgaria

    BF=Burkina Faso

    BI=Burundi

    KH=Cambodia

    CM=Cameroon

    CV=Cape Verde

    KY=Cayman Islands

    CF=Central African Republic

    TD=Chad

    CIS=Channel Islands

    CL=Chile

    CN=China

    CX=Christmas Island

    CC=Cocos (Keeling) Islands

    CO=Colombia

    KM=Comoros

    CG=Congo

    CK=Cook Islands

    CR=Costa Rica

    CI=Cote D'Ivoire

    HR=Croatia (Local Name: Hrvatska)

    CU=Cuba

    CY=Cyprus

    CZ=Czech Republic

    DK=Denmark

    DJ=Djibouti

    DM=Dominica

    DO=Dominican Republic

    TP=East Timor

    EC=Ecuador

    EG=Egypt

    SV=El Salvador

    GQ=Equatorial Guinea

    ER=Eritrea

    EE=Estonia

    ET=Ethiopia

    FK=Falkland Islands (Malvinas)

    FO=Faroe Islands

    FJ=Fiji

    FI=Finland

    FR=France

    GF=French Guiana

    PF=French Polynesia

    TF=French Southern Territories

    GA=Gabon

    GM=Gambia

    GE=Georgia

    DE=Germany

    GH=Ghana

    GI=Gibraltar

    GR=Greece

    GL=Greenland

    GD=Grenada

    GP=Guadeloupe

    GU=Guam

    GT=Guatemala

    GN=Guinea

    GW=Guinea-Bissau

    GY=Guyana

    HT=Haiti

    HM=Heard And Mc Donald Islands

    VA=Holy See (Vatican City State)

    HN=Honduras

    HK=Hong Kong

    HU=Hungary

    IS=Iceland

    IN=India

    ID=Indonesia

    IR=Iran (Islamic Republic Of)

    IQ=Iraq

    IE=Ireland

    IL=Israel

    IT=Italy

    JM=Jamaica

    JP=Japan

    JO=Jordan

    KZ=Kazakhstan

    KE=Kenya

    KI=Kiribati

    KP=Korea, Dem People'S Republic

    KR=Korea, Republic Of

    KW=Kuwait

    KG=Kyrgyzstan

    LA=Lao People'S Dem Republic

    LV=Latvia

    LB=Lebanon

    LS=Lesotho

    LR=Liberia

    LY=Libyan Arab Jamahiriya

    LI=Liechtenstein

    LT=Lithuania

    LU=Luxembourg

    MO=Macau

    MK=Macedonia

    MG=Madagascar

    MW=Malawi

    MY=Malaysia

    MV=Maldives

    ML=Mali

    MT=Malta

    MH=Marshall Islands

    MQ=Martinique

    MR=Mauritania

    MU=Mauritius

    YT=Mayotte

    MX=Mexico

    FM=Micronesia, Federated States

    MD=Moldova, Republic Of

    MC=Monaco

    MN=Mongolia

    MS=Montserrat

    MA=Morocco

    MZ=Mozambique

    MM=Myanmar

    NA=Namibia

    NR=Nauru

    NP=Nepal

    NL=Netherlands

    AN=Netherlands Ant Illes

    NC=New Caledonia

    NZ=New Zealand

    NI=Nicaragua

    NE=Niger

    NG=Nigeria

    NU=Niue

    NF=Norfolk Island

    MP=Northern Mariana Islands

    NO=Norway

    OM=Oman

    PK=Pakistan

    PW=Palau

    PA=Panama

    PG=Papua New Guinea

    PY=Paraguay

    PE=Peru

    PH=Philippines

    PN=Pitcairn

    PL=Poland

    PT=Portugal

    PR=Puerto Rico

    QA=Qatar

    RE=Reunion

    RO=Romania

    RU=Russian Federation

    RW=Rwanda

    KN=Saint K Itts And Nevis

    LC=Saint Lucia

    VC=Saint Vincent, The Grenadines

    WS=Samoa

    SM=San Marino

    ST=Sao Tome And Principe

    SA=Saudi Arabia

    SN=Senegal

    SC=Seychelles

    SL=Sierra Leone

    SG=Singapore

    SK=Slovakia (Slovak Republic)

    SI=Slovenia

    SB=Solomon Islands

    SO=Somalia

    ZA=South Africa

    GS=South Georgia , S Sandwich Is.

    ES=Spain

    LK=Sri Lanka

    SH=St. Helena

    PM=St. Pierre And Miquelon

    SD=Sudan

    SR=Suriname

    SJ=Svalbard, Jan Mayen Islands

    SZ=Sw Aziland

    SE=Sweden

    CH=Switzerland

    SY=Syrian Arab Republic

    TW=Taiwan

    TJ=Tajikistan

    TZ=Tanzania, United Republic Of

    TH=Thailand

    TG=Togo

    TK=Tokelau

    TO=Tonga

    TT=Trinidad And Tobago

    TN=Tunisia

    TR=Turkey

    TM=Turkmenistan

    TC=Turks And Caicos Islands

    TV=Tuvalu

    UG=Uganda

    UA=Ukraine

    AE=United Arab Emirates

    UM=United States Minor Is.

    UY=Uruguay

    UZ=Uzbekistan

    VU=Vanuatu

    VE=Venezuela

    VN=Viet Nam

    VG=Virgin Islands (British)

    VI=Virgin Islands (U.S.)

    WF=Wallis And Futuna Islands

    EH=Western Sahara

    YE=Yemen

    YU=Yugoslavia

    ZR=Zaire

    ZM=Zambia

    ZW=Zimbabwe

    Articles in this section

    Have more questions? Submit a request

    Comments

    • Avatar
      Rob Clarke

      How do you get the State field to change to those in your country?

    • Avatar
      Frank Hagan

      ONTRApages and ONTRAforms do not have the ability to select the states to show in the drop down box (yet). For regular Smart Forms with state fields you can click on the field and then select to show or hide each individual state: 

      select-states.png

      We plan to add this functionality to ONTRAforms and ONTRApages soon.

    Powered by Zendesk