Dataset · Geography
World countries: codes, capitals, area and population
217 countries and territories with ISO codes, capitals, area, population, region and income level.
This sheet is a free sample: any confirmed account can download it.
XLSXCSVODSXMLNumbers| World countries and territories: codes, capitals, area and population | |||||||||||
| Source: World Bank country API and WDI; Natural Earth v5.1.2 · Retrieved 2026-10-08 · Licence: CC BY 4.0 (World Bank), public domain (Natural Earth) | |||||||||||
| Country | ISO2 | ISO3 | ISO numeric | Continent | Subregion | World Bank region | Income level | Capital city | Capital latitude | Capital longitude | Population |
| Afghanistan | AF | AFG | 004 | Asia | Southern Asia | Middle East, North Africa, Afghanistan & Pakistan | Low income | Kabul | 34.5228 | 69.1761 | 43,844,111 |
| Albania | AL | ALB | 008 | Europe | Southern Europe | Europe & Central Asia | Upper middle income | Tirane | 41.3317 | 19.8172 | 2,349,580 |
| Algeria | DZ | DZA | 012 | Africa | Northern Africa | Middle East, North Africa, Afghanistan & Pakistan | Upper middle income | Algiers | 36.7397 | 3.05097 | 47,435,312 |
| American Samoa | AS | ASM | 016 | Oceania | Polynesia | East Asia & Pacific | High income | Pago Pago | -14.2846 | -170.691 | 46,029 |
| Andorra | AD | AND | 020 | Europe | Southern Europe | Europe & Central Asia | High income | Andorra la Vella | 42.5075 | 1.5218 | 82,904 |
| Angola | AO | AGO | 024 | Africa | Middle Africa | Sub-Saharan Africa | Lower middle income | Luanda | -8.81155 | 13.242 | 39,040,039 |
| Antigua and Barbuda | AG | ATG | 028 | North America | Caribbean | Latin America & Caribbean | High income | Saint John's | 17.1175 | -61.8456 | 94,209 |
| Argentina | AR | ARG | 032 | South America | South America | Latin America & Caribbean | Upper middle income | Buenos Aires | -34.6118 | -58.4173 | 45,851,378 |
| Armenia | AM | ARM | 051 | Asia | Western Asia | Europe & Central Asia | Upper middle income | Yerevan | 40.1596 | 44.509 | 3,086,700 |
| Aruba | AW | ABW | 533 | North America | Caribbean | Latin America & Caribbean | High income | Oranjestad | 12.5167 | -70.0167 | 108,785 |
| Australia | AU | AUS | 036 | Oceania | Australia and New Zealand | East Asia & Pacific | High income | Canberra | -35.282 | 149.129 | 27,614,411 |
| Austria | AT | AUT | 040 | Europe | Western Europe | Europe & Central Asia | High income | Vienna | 48.2201 | 16.3798 | 9,208,163 |
| Azerbaijan | AZ | AZE | 031 | Asia | Western Asia | Europe & Central Asia | Upper middle income | Baku | 40.3834 | 49.8932 | 10,246,996 |
Showing the first 16 of 220 rows and 12 of 19 columns. Cells with formulas show the formula on hover.
| Countries, population and area by World Bank region and by continent | |||||||
| Source: World Bank country API and WDI; Natural Earth v5.1.2 · Retrieved 2026-10-08 · Licence: CC BY 4.0 (World Bank), public domain (Natural Earth) | |||||||
| Grouping | Group | Countries and territories | Population | Share of total population | Surface area (km²) | Land area (km²) | Population density (people per km² of land) |
| World Bank region | East Asia & Pacific | 37 | 2,367,527,180 | 28.9% | 24,794,647 | 24,446,571 | 96.8 |
| World Bank region | Europe & Central Asia | 58 | 932,525,035 | 11.4% | 28,906,234 | 27,433,364 | 33.9 |
| World Bank region | Latin America & Caribbean | 42 | 666,592,570 | 8.1% | 20,510,334 | 20,059,037 | 33.2 |
| World Bank region | Middle East, North Africa, Afghanistan & Pakistan | 23 | 828,025,185 | 10.1% | 12,834,683 | 12,640,232 | 65.5 |
| World Bank region | North America | 3 | 383,501,065 | 4.7% | 25,470,210 | 17,936,174 | 21.4 |
| World Bank region | South Asia | 6 | 1,692,252,900 | 20.7% | 3,686,314 | 3,347,008 | 505.6 |
| World Bank region | Sub-Saharan Africa | 48 | 1,321,654,217 | 16.1% | 24,338,351 | 23,893,229 | 55.3 |
| Continent | Africa | 54 | 1,546,877,498 | 18.9% | 30,114,441 | 29,654,799 | 52.2 |
| Continent | Asia | 50 | 4,802,872,935 | 58.6% | 31,966,421 | 31,077,902 | 154.5 |
| Continent | Europe | 48 | 744,883,309 | 9.1% | 23,509,097 | 22,125,291 | 33.6 |
| Continent | North America | 34 | 612,362,225 | 7.5% | 28,689,025 | 21,018,254 | 29.1 |
| Continent | Oceania | 19 | 47,293,944 | 0.6% | 8,559,821 | 8,491,963 | 5.6 |
| Continent | South America | 12 | 437,788,241 | 5.3% | 17,701,968 | 17,387,407 | 25.2 |
Showing the first 16 of 19 rows and 8 of 8 columns. Cells with formulas show the formula on hover.
| About this dataset | |
| Source: World Bank, Natural Earth · Retrieved 2026-10-08 · Licence: CC BY 4.0 and public domain | |
| What this workbook is | |
| Summary | One row for each of the 217 countries and territories in the World Bank's country list: ISO codes, continent and subregion, World Bank region and income level, capital city and its coordinates, latest population, surface area and land area… |
| Tabs | |
| Countries | 217 rows sorted by name, with header filters. Population density = population / land area, a formula in column R. |
| By region | COUNTIF and SUMIF totals by World Bank region and by continent. |
| Columns and sources | |
| Country, ISO2, ISO3, World Bank region, Income level | World Bank country API (https://api.worldbank.org/v2/country). Names follow World Bank conventions. ISO3 is the World Bank code; it matches ISO 3166-1 alpha-3 except XKX (Kosovo) and CHI (Channel Islands), which are World Bank codes. |
| Capital city, Capital latitude, Capital longitude | World Bank country API (capitalCity, latitude, longitude), decimal degrees as published (4 decimals or fewer). See the note on capital coordinates below. |
| Population, Population year | SP.POP.TOTL, number of people, de facto definition (all residents regardless of legal status), midyear estimates. World Bank WDI; underlying: UN World Population Prospects, national statistical offices, Eurostat, UN Statistics Division. |
| Surface area (km²), year | AG.SRF.TOTL.K2: a country's total area, including areas under inland bodies of water and some coastal waterways (World Bank definition). WDI source: FAO. |
| Land area (km²), year | AG.LND.TOTL.K2: a country's total area, excluding area under inland water bodies, national claims to continental shelf, and exclusive economic zones (World Bank definition). WDI source: FAOSTAT. |
Showing the first 16 of 65 rows and 2 of 2 columns. Cells with formulas show the formula on hover.
About this dataset
A reference table of 217 countries and territories, one row each, built from the World Bank country list and World Development Indicators plus Natural Earth. Each row carries the ISO2 and ISO3 codes, ISO numeric code, continent and subregion, World Bank region and income level, capital city with latitude and longitude, and the latest population, surface area and land area, each with its year.
Population density is calculated by formula (population divided by land area), and a By region tab totals countries, population and area by World Bank region and by continent with COUNTIF and SUMIF. The Countries tab is sorted by name, with a frozen header and filters on every column.
The About tab documents every source, license and join, including how the World Bank and Natural Earth identifiers were matched, which entries are disputed, partially recognized or dependencies, and where the sources leave gaps. Nothing is estimated: a blank cell means the source has no value.
What’s inside
- 217 countries and territories with ISO2, ISO3 and ISO numeric codes
- 7 World Bank regions, 4 income levels, 6 continents and Natural Earth subregions
- Capital city with coordinates for 211 entries
- Latest population (217), surface area (216) and land area (216) with their years
- Population density by formula; By region tab with COUNTIF and SUMIF
- Documented join between World Bank and Natural Earth identifiers, including disputed territories
Tabs
| Tab | What it holds |
|---|---|
| Countries | 217 rows: codes, continent, region, income, capital, population, areas, density, with filters. |
| By region | Countries, population and area totals by World Bank region and by continent (COUNTIF and SUMIF). |
| About | Columns, sources, licenses, join log, disputed territories, naming conventions and gaps. |
How to use it
- Open the Countries tab and use the header filters to select a region, continent or income level.
- Join the table to your own data on ISO3 or ISO2; use the ISO numeric column for UN-coded sources.
- Sort by population, land area or density to rank countries.
- Read the By region tab for regional totals, then check the About tab for notes on territories.
- Copy the credit line from the About tab when you publish.
Columns and units
| Column | Unit | Meaning |
|---|---|---|
| Country | text | Country or territory name as used by the World Bank. |
| ISO2 / ISO3 | code | Two- and three-letter codes from the World Bank country list (ISO 3166-1, except XKX and CHI). |
| ISO numeric | code (text) | Natural Earth ISO_N3_EH, three digits with leading zeros. |
| Continent / Subregion | text | Natural Earth CONTINENT and SUBREGION attributes. |
| World Bank region / Income level | text | World Bank classification from the country API. |
| Capital city, latitude, longitude | text, decimal degrees | World Bank country API values, unmodified. |
| Population | people | SP.POP.TOTL, latest year available (mostly 2025). |
| Surface area | km² | AG.SRF.TOTL.K2, total area including inland water. |
| Land area | km² | AG.LND.TOTL.K2, area excluding inland water. |
| Population density | people per km² of land | Calculated by formula: population divided by land area. |
Source and licence
World Bank country API and World Development Indicators; Natural Earth, licensed CC BY 4.0 (World Bank data); public domain (Natural Earth). Retrieved 8 Oct 2026.
Cite as: World Bank country API and World Development Indicators (SP.POP.TOTL, AG.SRF.TOTL.K2, AG.LND.TOTL.K2), retrieved 2026-10-08 from https://api.worldbank.org/v2/, licensed CC BY 4.0; continents, subregions and ISO numeric codes from Natural Earth v5.1.2 (public domain).
Also used: Natural Earth v5.1.2 1:50m Admin 0 Countries (https://github.com/nvkelso/natural-earth-vector, public domain) for continent, subregion, ISO numeric, type and sovereign state, joined on ADM0_A3 with documented exceptions; 1:10m for Gibraltar only. GeoNames (CC BY 4.0) was used only to check capital coordinates, not as a data source. WDI last updated 2026-07-13 (population) and 2026-10-08 (areas). Capital coordinates are the World Bank's published values.
Good for
- Country lookup table for joins and dropdowns
- Mapping capitals and comparing country sizes
- Population and density rankings
- Reference list for forms, dashboards and teaching
- Grouping countries by region, continent or income level
Questions about this sheet
Which countries are included?
The 217 entries of the World Bank country list that belong to a region, including territories such as Puerto Rico, Hong Kong SAR and Greenland. Natural Earth features without a World Bank entry, such as Taiwan, are listed on the About tab but not included.
Why are some names written like 'Korea, Rep.'?
They are World Bank names, kept so the table joins to other World Bank data. ISO2 and ISO3 columns give a neutral key, and the About tab lists the unusual names.
How is population density calculated?
By formula as population divided by land area in km². Population is mostly from 2025 and land area from 2024, and the year columns show which.
How were the World Bank and Natural Earth tables matched?
On the World Bank ISO3 code against Natural Earth's ADM0_A3, with documented exceptions for South Sudan, Palestine, Kosovo, the Channel Islands and Gibraltar. The About tab has the join log.
Are the capital coordinates exact?
They are the World Bank's published values and are approximate. A few are tens or hundreds of kilometers off the actual capital; the About tab names them.