Dataset · Geography

World countries: codes, capitals, area and population

217 countries and territories with ISO codes, capitals, area, population, region and income level.

Create a free account to download

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 TERRITORIESTOTAL POPULATION (MILLIONS)TOTAL LAND AREA (MILLION KM²)POPULATION DENSITY (/KM²)
2178,192.1129.7663.1
World Bank country list (region != NA)Sum of latest country figuresExcluding inland water bodiesPeople per km² of land
Regions and continents: countries, population (M), share of total, land area (M km²) and density (/km²)
GroupGroupingCountriesPopulation (M)SharePopulation share bar (scale 0 to 100%)Surface area (M km²)Land area (M km²)Density (/km²)
East Asia & PacificWorld Bank region372,367.528.9%████████24.7924.4596.8
Europe & Central AsiaWorld Bank region58932.511.4%███28.9127.4333.9
Latin America & CaribbeanWorld Bank region42666.68.1%██20.5120.0633.2
Middle East, North Africa, Afghanistan & PakistanWorld Bank region23828.010.1%███12.8312.6465.5
North AmericaWorld Bank region3383.54.7%█25.4717.9421.4
South AsiaWorld Bank region61,692.320.7%██████3.693.35505.6

Showing the first 16 of 42 rows and 12 of 13 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?

TabWhat it holds
DashboardGlobal population and area KPIs, region and continent comparisons with bars, and the 15 most populous countries.
Countries217 rows: codes, continent, region, income, capital, population, areas, density, with filters.
By regionCountries, population and area totals by World Bank region and by continent (COUNTIF and SUMIF).
AboutColumns, 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.

FunctionUsesWhat it does
IF478one result when a test is true, another when false
ISNUMBER434true for a number
AND217true when every test is true
INDEX135value at a position in a range
SUMIF39adds values meeting one condition
MAX29largest value
MIN29smallest value
OR29true when any test is true
REPT29repeats text
ROUND29rounds to a number of digits
SUMIFS28adds values meeting several conditions
LARGE15nth 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?

  1. Open the Countries tab and use the header filters to select a region, continent or income level.
  2. Join the table to your own data on ISO3 or ISO2; use the ISO numeric column for UN-coded sources.
  3. Sort by population, land area or density to rank countries.
  4. Read the By region tab for regional totals, then check the About tab for notes on territories.
  5. Copy the credit line from the About tab when you publish.

What do the columns and units mean?

ColumnUnitMeaning
CountrytextCountry or territory name as used by the World Bank.
ISO2 / ISO3codeTwo- and three-letter codes from the World Bank country list (ISO 3166-1, except XKX and CHI).
ISO numericcode (text)Natural Earth ISO_N3_EH, three digits with leading zeros.
Continent / SubregiontextNatural Earth CONTINENT and SUBREGION attributes.
World Bank region / Income leveltextWorld Bank classification from the country API.
Capital city, latitude, longitudetext, decimal degreesWorld Bank country API values, unmodified.
PopulationpeopleSP.POP.TOTL, latest year available (mostly 2025).
Surface areakm²AG.SRF.TOTL.K2, total area including inland water.
Land areakm²AG.LND.TOTL.K2, area excluding inland water.
Population densitypeople per km² of landCalculated 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.