Importing Contacts: Formatting State and Country Fields
About Formatting State and Country Fields
Applies to: All ONTRAPORT accounts.
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
- Click to highlight an entire column
- Press Ctrl + F to bring up the find command
- Select the Replace tab
- In the Find what box, type the text you’d like to find (i.e. USA)
- In the Replace with box, type a value (such as US)
- Click Replace All
On a Mac
- Click to highlight an entire column
- Press Ctrl + F to bring up the find/replace command
- In the Find what box, type the text you’d like to find (i.e. USA)
- In the Replace with box, type a value (Such as US)
- Click Replace All
Proper Formatting of State and 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
- Contact Management Overview
- Importing Contacts
- Best Practices for Preparing a CSV File for Import
- Contact Management Segmentation (Groups)
- Contact Tags
- Add Custom Fields & Sections
- Card View for Contacts and Custom Objects
- Card View - Using the Color Field
- Converting to Card View
- Card View Quick Reference
How do you get the State field to change to those in your country?
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:
We plan to add this functionality to ONTRAforms and ONTRApages soon.