ISO Look Up

Source of Codes-- The ISO provides a free download of its two character codes at http://www.iso.org/iso/country_codes/iso_3166_code_lists/country_names_and_code_elements.htm. However, the UN defines the three character country codes as the standard and these are not provided free by ISO. The United Nations provides a list of country names with three character country codes and three place numeric codes (formatted as text with leading 0s) at http://unstats.un.org/unsd/methods/m49/m49alpha.htm. This file cannot be downloaded but it can be selected and copied to Excel-- the country names and three character country codes are reproduced correctly, but the three character numeric codes with leading 0s are converted to ordinary numbers (this is a common problem with downloading numbers in text format into Excel. In addition, the country names in the ISO code are all capital letters while those in the UN are upper and lower case and won't link easily with the all upper case characters of the ISO table. A third table is necessary to provide the linkages necessary to make up the ISO lookup table.  Wikipedia provides a copy of the ISO codes at http://en.wikipedia.org/wiki/ISO_3166-1 which can be copied and downloaded directly to Excel.  By combining the three tables it it possible to prepare a look-up table with seven fields, which provide a range of options for linking with other database country tables.

The fields are:

ISOCountryUC: The country name in upper case (text field)
ISOCountryLC: The country name in lower case (text field)
IISOA2: The two character ISO Alpha code (text field)
IISOA3: The three character ISO Alpha code (text field)
IISON3: The three character ISO numeric code with preceding 0s (text field)
IISONA: The numeric code as a text number (text field)
IISUNN: The numberic code as a number (number field)

The first few records of the look-up table are shown below:


The look-up table can be downloaded as an Excel (.xls) spreadsheet here.
Copyright 1998/2015 GRI    Updated 6 May 2015