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. XLSX, ODS and XML keep formulas; CSV and Numbers contain values only.
XLSXCSVODSXMLNumbers| World countries: codes, capitals, area and population | |||||||||||
| Source: World Bank country API and WDI; Natural Earth v5.1.2 · Retrieved 2026-10-08 · License: CC BY 4.0 (World Bank), public domain (Natural Earth) | |||||||||||
| ISO codes, continents, World Bank regions, capitals, latest population and land area across 217 countries and territories. | |||||||||||
| COUNTRIES AND TERRITORIES | TOTAL POPULATION (MILLIONS) | TOTAL LAND AREA (MILLION KM²) | POPULATION DENSITY (/KM²) | ||||||||
| 217 | 8,192.1 | 129.76 | 63.1 | ||||||||
| World Bank country list (region != NA) | Sum of latest country figures | Excluding inland water bodies | People per km² of land | ||||||||
| Regions and continents: countries, population (M), share of total, land area (M km²) and density (/km²) | |||||||||||
| Group | Grouping | Countries | Population (M) | Share | Population share bar (scale 0 to 100%) | Surface area (M km²) | Land area (M km²) | Density (/km²) | |||
| East Asia & Pacific | World Bank region | 37 | 2,367.5 | 28.9% | ████████ | 24.79 | 24.45 | 96.8 | |||
| Europe & Central Asia | World Bank region | 58 | 932.5 | 11.4% | ███ | 28.91 | 27.43 | 33.9 | |||
| Latin America & Caribbean | World Bank region | 42 | 666.6 | 8.1% | ██ | 20.51 | 20.06 | 33.2 | |||
| Middle East, North Africa, Afghanistan & Pakistan | World Bank region | 23 | 828.0 | 10.1% | ███ | 12.83 | 12.64 | 65.5 | |||
| North America | World Bank region | 3 | 383.5 | 4.7% | █ | 25.47 | 17.94 | 21.4 | |||
| South Asia | World Bank region | 6 | 1,692.3 | 20.7% | ██████ | 3.69 | 3.35 | 505.6 |
Showing the first 16 of 42 rows and 12 of 13 columns. Cells with formulas show the formula on hover.
| 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 | |
| Dashboard | Global population and area KPIs, World Bank region and continent comparisons with bars, and the 15 most populous countries. |
| 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. |
Showing the first 16 of 66 rows and 2 of 2 columns. Cells with formulas show the formula on hover.
What does this dataset do?
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
Which tabs does the workbook have?
| Tab | What it holds |
|---|---|
| Dashboard | Global population and area KPIs, region and continent comparisons with bars, and the 15 most populous countries. |
| 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. |
What formulas does this dataset use?
This dataset holds 581 formulas in 4,670 cells across 4 tabs, so 12% of its cells calculate. They use 17 distinct functions; the longest formula is 179 characters and 321 of them read from another tab.
| Function | Uses | What it does |
|---|---|---|
IF | 478 | one result when a test is true, another when false |
ISNUMBER | 434 | true for a number |
AND | 217 | true when every test is true |
INDEX | 135 | value at a position in a range |
SUMIF | 39 | adds values meeting one condition |
MAX | 29 | largest value |
MIN | 29 | smallest value |
OR | 29 | true when any test is true |
REPT | 29 | repeats text |
ROUND | 29 | rounds to a number of digits |
SUMIFS | 28 | adds values meeting several conditions |
LARGE | 15 | nth largest value |
The 12 most used of 17 functions. Counted from the workbook itself. Only functions that Excel, LibreOffice Calc, Google Sheets and Apple Numbers evaluate the same way are used, so the formulas survive every download format.
How do you 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.
What do the columns and units mean?
| 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. |
Where does the data come from?
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.
What is it 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.