Page 1 PreviewWorld Countries & Capitals ISO Dataset CSV
Download a reference dataset of world countries and capitals in CSV. Includes ISO-3166 codes, continents, and currencies for database lookup.
Template Highlights & Included Features
ISO 3166-1 International Standard
Contains standardized 2-letter (alpha-2), 3-letter (alpha-3), and three-digit numerical country codes used in international trade and banking.
Essential Geographic & Telephony Attributes
Includes Sovereign Name, Official State Title, Capital City, Continent, ISO Currency Code (e.g., USD, EUR, JPY), Dialing Prefix, and ccTLD.
Clean UTF-8 Diacritic Support
Fully encoded in UTF-8 to preserve international city names and accent marks (e.g., Brasília) without corrupting character sets.
Plug-and-Play Dropdown Menus
Ideal for seeding country selection menus in registration forms, checkout billing pages, and localization microservices.
Every web application that handles user registration, payment processing, shipping logistics, or internationalization requires an accurate, standardized country dataset. Building country lists manually frequently results in spelling inconsistencies, missing ISO codes, and formatting errors that break downstream third-party APIs like Stripe and PayPal. This World Countries, Capitals and ISO Codes Dataset (.csv) provides a clean, verified lookup table.
Dataset Fields & Schema
The dataset provides standardized tabular columns designed for easy database indexing:
| Field Name | Type | Example | Purpose & Standard |
|---|---|---|---|
Country_Name | String | Germany | Common English country name |
Official_State_Name | String | Federal Republic of Germany | Formal constitutional state title |
ISO_Alpha2 | String (2-Char) | DE | ISO 3166-1 alpha-2 code (Form pickers, Stripe) |
ISO_Alpha3 | String (3-Char) | DEU | ISO 3166-1 alpha-3 code (Passports, international shipping) |
Numeric_Code | String (3-Digit) | 276 | ISO 3166-1 numeric UN code |
Capital_City | String | Berlin | National seat of government |
Continent | String | Europe | Regional continental classification |
Currency_Code | String (3-Char) | EUR | ISO 4217 official monetary code |
Phone_Prefix | String | +49 | ITU-T international direct dialing prefix |
Top_Level_Domain | String | .de | Country code top-level internet domain (ccTLD) |
Implementation Examples
1. Fast SQL Table Migration (PostgreSQL)
CREATE TABLE geo_countries (
country_name VARCHAR(100) NOT NULL,
official_name VARCHAR(150),
iso_alpha2 CHAR(2) PRIMARY KEY,
iso_alpha3 CHAR(3) NOT NULL,
numeric_code CHAR(3),
capital_city VARCHAR(100),
continent VARCHAR(50),
currency_code CHAR(3),
phone_prefix VARCHAR(10),
tld VARCHAR(10)
);
\copy geo_countries FROM 'world-countries-capitals-iso-dataset.csv' WITH (FORMAT csv, HEADER true);
2. Frontend React / Vue Select Component
Map over the dataset to render an accessible country selector:
import countries from './world-countries-capitals-iso-dataset.json';
export function CountrySelect({ value, onChange }) {
return (
<select value={value} onChange={e => onChange(e.target.value)}>
{countries.map(c => (
<option key={c.ISO_Alpha2} value={c.ISO_Alpha2}>
{c.Country_Name} ({c.ISO_Alpha2})
</option>
))}
</select>
);
}