Skip to content

List of countries in the world in SQL, CSV or XML format

For many web projects (website, web application or mobile application) it is necessary to have a database of the countries of the world. This makes it possible, for example, to record the country of residence of users or to offer editorial content by country. This article proposes to download an SQL, CSV or XML database of the countries of the world.

World map (timezone)

About the list

The table contains 241 countries conforming to ISO 3166-1. The name of the country is available in French and English. The table also includes the 3-digit country code, the 2-letter code (used in many applications, including currency applications), and the 3-letter code.

Table of countries of the world

Table of countries of the world

For information, the information for the country France will be as follows:

  • Digital ISO 3166-1 code: 250
  • ISO 3166-1 alpha2 code: FR
  • ISO 3166-1 alpha3 code: ENG

Free version


The database is available in several formats, including a ZIP file which contains all available formats.