Free Data – ISO Countries (CSV and Excel)Free Data – ISO Countries (CSV and Excel)Free Data – ISO Countries (CSV and Excel)Free Data – ISO Countries (CSV and Excel)Free Data – ISO Countries (CSV and Excel)

This data feed contains the ISO countries in the world as per the ISO-3166-1 standard. If you are looking for local translations of country names, there is an excellent resource here: https://github.com/umpirsky/country-list.

Download Formats

ISO Country Download in CSV
ISO Country Download in Windows UTF-16 with CRLF endings
ISO Country Download in Excel

Table Scripts

Compatible table creation scripts are available for the following databases.

Postgres ISO Country script
MSSQL ISO Country script
MySQL ISO Country script

Data Dictionary

The following columns are contained in the dataset:

Column Type Description
SK_Country Integer Surrogate Key that can be used in a data warehouse. Unique across all datasets on this site
Number Integer The ISO Country Numerical code
Alpha2Code String (Length: 2B) The 2 character ISO Country code
Alpha3Code String (Length: 3B) The 3 character ISO country code
CountryName String The English name of the country
TopLevelDomain String, prepended with . Top level domain of the country. Mostly, but not always the same as the Alpha2Code

  2Comments

  1. Medhat   •  

    many thanks

  2. Eric de Bruin   •  

    Dear Thomas Kejser,

    Thanks for the excel sheet with the ISO codes.
    Now i can load the controls with teh data and the user can only choose a valid one 🙂

    Regards
    Eric de Bruin
    Holland

Leave a Reply

Your email address will not be published. Required fields are marked *