ISO 3166-1 County & Nation State Data Stores

Programming

System Requirements:

  • A Country Code Problem
  • Text/CSV Viewer, Excel 2003, Access 2003

The Problem:

If you have ever been mildly curious over the country ID listing, or ever engaged in a project where language identification was important having to come up with a digital list of the global nation states can be a time consuming business.

This article simply saves you the time, having had me spend the time compile the list for you!

The Fix

If you need the country list, you can use my files below as a base for your project.

The data source has been taken from the latest revision of the ISO public states list (ISO 3166-1) registry, so any errors are universally the ISO’s problem if indeed there are any.

I have made the following three files available:

  • Comma Separated Variable (CSV) Text File
  • Office Excel 2010 Spreadsheet
  • Office Access 2003 Database

The CSV contains:

  1. Country Code
  2. Country Name
  3. 2 digit Alpha Numeric Code
  4. 3 digit Alpha Numeric Code

The Spreadsheet and MDB Database contain:

  1. Country Code
  2. Country Name
  3. 2 digit Alpha Numeric Code
  4. 3 digit Alpha Numeric Code

 

Download: CSV, Excel 2010, Access 2003 (42KB)

You may also be interested in my stores for RFC 1766 International Language Identification Codes.