FREE

IP2Location™ Country Multilingual Database

IP2Location™ Country Multilingual Database is a free database for your download. The database can be used to display the country name in up to 81 different languages. And, it is currently available in a CSV text file (comma delimited).

You may download and use the IP2Location™ Country Multilingual Database in your personal and commercial project, with attribution being required by mentioning the use of this data as follows, "The IP geolocation data is provided by https://www.ip2location.com", on your webpage and in the documentation or advertising.

English

Download
Free download

Multilingual

Download
Free with registration
Features
Last Update 06 December, 2023
Database Format CSV Text File (Comma Delimited)
Database Fields
Name Type Description
lang VARCHAR(5) Language code based on ISO 639, except Chinese Simplified (ZH-CN) and Chinese Traditional (ZH-TW).
lang_name VARCHAR(50) Language Name based on ISO 639.
country_alpha2_code CHAR(2) Two-character country code based on ISO 3166.
country_alpha3_code CHAR(3) Three-character country code based on ISO 3166.
country_numeric_code CHAR(3) Three-character country numeric code based on ISO 3166.
country_name VARCHAR(200) Country name based on ISO 3166.
Sample Database
"lang","lang_name","country_alpha2_code","country_alpha3_code","country_numeric_code","country_name"
"EN","ENGLISH","AD","AND","20","Andorra"
"EN","ENGLISH","AE","ARE","784","United Arab Emirates"
"EN","ENGLISH","AF","AFG","4","Afghanistan"
"EN","ENGLISH","AG","ATG","28","Antigua and Barbuda"
"EN","ENGLISH","AI","AIA","660","Anguilla"
MySQL Statement
CREATE TABLE `ip2location_country_multilingual`(
	`lang` VARCHAR(5),
	`lang_name` VARCHAR(50),
	`country_alpha2_code` CHAR(2),
	`country_alpha3_code` CHAR(3),
	`country_numeric_code` CHAR(3),
	`country_name` VARCHAR(200),
	INDEX `idx_lang` (`lang`),
	INDEX `idx_country_alpha2_code` (`country_alpha2_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOAD DATA LOCAL
INFILE 'IP2LOCATION-COUNTRY-MULTILINGUAL.CSV' INTO TABLE `ip2location_country_multilingual`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n' IGNORE 1 LINES;
License Information

This works is licensed under Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0).

It is free for personal or commercial use with attribution required by mentioning the use of this works as follows:
This site or product includes IP2Location™ Country Multilingual Database which available from https://www.ip2location.com".

Languages Supported
Language Code Language Name
AF AFRIKAANS
AM AMHARIC
AR ARABIC
AZ AZERBAIJANI
BE BELARUSIAN
Show More »
BG BULGARIAN
BN BENGALI
BO TIBETAN STANDARD
CA CATALAN
CS CZECH
CY WELSH
DA DANISH
DE GERMAN
EE EWE
EL GREEK
EN ENGLISH
EO ESPERANTO
ES SPANISH
ET ESTONIAN
EU BASQUE
FA PERSIAN
FI FINNISH
FO FAROESE
FR FRENCH
GA IRISH
GL GALICIAN
GU GUJARATI
HE HEBREW
HI HINDI
HR CROATIAN
HU HUNGARIAN
HY ARMENIAN
IA INTERLINGUA
ID INDONESIAN
IS ICELANDIC
IT ITALIAN
JA JAPANESE
KA GEORGIAN
KI KIKUYU
KM KHMER
KN KANNADA
KO KOREAN
LG GANDA
LO LAO
LT LITHUANIAN
LV LATVIAN
MK MACEDONIAN
ML MALAYALAM
MR MARATHI
MS MALAY
MT MALTESE
MY BURMESE
NB NORWEGIAN BOKMAL
NE NEPALI
NL DUTCH
NN NORWEGIAN NYNORSK
NO NORWEGIAN
OR ORIYA
PL POLISH
PT PORTUGUESE
RM ROMANSH
RO ROMANIAN
RU RUSSIAN
SE NORTHERN SAMI
SK SLOVAK
SL SLOVENE
SN SHONA
SQ ALBANIAN
SR SERBIAN
SV SWEDISH
TA TAMIL
TE TELUGU
TH THAI
TI TIGRINYA
TL TAGALOG
TR TURKISH
UK UKRAINIAN
UR URDU
VI VIETNAMESE
ZH-CN CHINESE SIMPLIFIED
ZH-TW CHINESE TRADITIONAL
Country Name (English)
Country Code Country Name
AF Afghanistan
AX Aland Islands
AL Albania
DZ Algeria
AS American Samoa
Show More »
AD Andorra
AO Angola
AI Anguilla
AQ Antarctica
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 (Plurinational State of)
BQ Bonaire, Sint Eustatius and Saba
BA Bosnia and Herzegovina
BW Botswana
BV Bouvet Island
BR Brazil
IO British Indian Ocean Territory
BN Brunei Darussalam
BG Bulgaria
BF Burkina Faso
BI Burundi
CV Cabo Verde
KH Cambodia
CM Cameroon
CA Canada
KY Cayman Islands
CF Central African Republic
TD Chad
CL Chile
CN China
CX Christmas Island
CC Cocos (Keeling) Islands
CO Colombia
KM Comoros
CG Congo
CD Congo (Democratic Republic of the)
CK Cook Islands
CR Costa Rica
CI Cote d'Ivoire
HR Croatia
CU Cuba
CW CuraƧao
CY Cyprus
CZ Czechia
DK Denmark
DJ Djibouti
DM Dominica
DO Dominican Republic
EC Ecuador
EG Egypt
SV El Salvador
GQ Equatorial Guinea
ER Eritrea
EE Estonia
SZ Eswatini
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
GG Guernsey
GN Guinea
GW Guinea-Bissau
GY Guyana
HT Haiti
HM Heard Island and McDonald Islands
VA Holy See
HN Honduras
HK Hong Kong
HU Hungary
IS Iceland
IN India
ID Indonesia
IR Iran (Islamic Republic of)
IQ Iraq
IE Ireland
IM Isle of Man
IL Israel
IT Italy
JM Jamaica
JP Japan
JE Jersey
JO Jordan
KZ Kazakhstan
KE Kenya
KI Kiribati
KP Korea (Democratic People's Republic of)
KR Korea (Republic of)
KW Kuwait
KG Kyrgyzstan
LA Lao People's Democratic Republic
LV Latvia
LB Lebanon
LS Lesotho
LR Liberia
LY Libya
LI Liechtenstein
LT Lithuania
LU Luxembourg
MO Macao
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 of)
MD Moldova (Republic of)
MC Monaco
MN Mongolia
ME Montenegro
MS Montserrat
MA Morocco
MZ Mozambique
MM Myanmar
NA Namibia
NR Nauru
NP Nepal
NL Netherlands
NC New Caledonia
NZ New Zealand
NI Nicaragua
NE Niger
NG Nigeria
NU Niue
NF Norfolk Island
MK North Macedonia
MP Northern Mariana Islands
NO Norway
OM Oman
PK Pakistan
PW Palau
PS Palestine, State of
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
BL Saint Barthelemy
SH Saint Helena, Ascension and Tristan da Cunha
KN Saint Kitts and Nevis
LC Saint Lucia
MF Saint Martin (French Part)
PM Saint Pierre and Miquelon
VC Saint Vincent and the Grenadines
WS Samoa
SM San Marino
ST Sao Tome and Principe
SA Saudi Arabia
SN Senegal
RS Serbia
SC Seychelles
SL Sierra Leone
SG Singapore
SX Sint Maarten (Dutch Part)
SK Slovakia
SI Slovenia
SB Solomon Islands
SO Somalia
ZA South Africa
GS South Georgia and the South Sandwich Islands
SS South Sudan
ES Spain
LK Sri Lanka
SD Sudan
SR Suriname
SJ Svalbard and Jan Mayen
SE Sweden
CH Switzerland
SY Syrian Arab Republic
TW Taiwan (Province of China)
TJ Tajikistan
TZ Tanzania, United Republic of
TH Thailand
TL Timor-Leste
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
GB United Kingdom of Great Britain and Northern Ireland
UM United States Minor Outlying Islands
US United States of America
UY Uruguay
UZ Uzbekistan
VU Vanuatu
VE Venezuela (Bolivarian Republic of)
VN Viet Nam
VG Virgin Islands (British)
VI Virgin Islands (U.S.)
WF Wallis and Futuna
EH Western Sahara
YE Yemen
ZM Zambia
ZW Zimbabwe