Skip to content
TablePage.ai Open the app

Compare country sizes with consistent area data, not map outlines

Compare country sizes using a sourced area table, calculate country-to-country ratios, and prepare a spreadsheet for a public interactive page.

Share X in f
Wei Hu

To compare country sizes, choose one area measure, put the countries in a table, and divide each area by the same reference country’s area. Using World Bank surface-area figures for 2024, the United States is 2.99 times the size of India, and Australia is 2.35 times the size of India.

The table below gives you a small, sourced dataset to reproduce those comparisons and prepare a public page readers can explore.

Choose what “size” means

For a geographic comparison, distinguish these two measures:

Do not use one country’s land area against another country’s surface area. The choice changes the result: the United States–India ratio is about 3.08 using land area, rather than 2.99 using surface area, calculated from the World Bank’s 2024 land-area observations.

Using the same indicator improves comparability, but does not eliminate every reporting difference: the World Bank notes that complete consistency across countries and over time is not possible.

For a broader ranking specifically excluding water, see biggest countries by land area.

A sample country-size comparison

This is a selected three-country comparison, not a world ranking. All rows use the same indicator, unit and observation year.

Country Country code Year Surface area (km²) Size relative to India (×)
United States USA 2024 9,831,510 2.99
Australia AUS 2024 7,741,220 2.35
India IND 2024 3,287,263 1.00

Source: World Bank surface-area observations for these countries, from the dataset updated October 8, 2026. Ratios are calculated from the unrounded area values and displayed to two decimal places.

Read 2.99× as “2.99 times the size of India.” Avoid “2.99 times larger,” which can make it unclear whether you mean a ratio or an increase.

Calculate the ratios in a spreadsheet

Create columns A–E using the table’s headings. Enter area values as numbers—for example, 9831510, not the text 9,831,510 km². Apply thousands separators through cell formatting; keep the unit in the header.

Place India’s reference area, 3287263, in cell H2, outside the table, and label H1 Reference area: India (km²). In E2, enter:

=D2/$H$2

Fill the formula down. The dollar signs make H2 an absolute reference, keeping every row pointed at the same reference cell. Store the ratio as a number and display two decimal places rather than adding an × character to each stored value.

If you want a percentage comparison instead, use:

=D2/$H$2-1

Format that result as a percentage. For the United States, it gives approximately 199% larger than India—the increase above the baseline, not the total ratio.

Before export, check that:

  • Every row uses surface area, square kilometres and 2024.
  • Each country code occurs once in this single-year table.
  • India’s ratio equals 1, and every ratio uses the intended reference value.
  • Missing areas remain missing rather than becoming zero.

Publish the comparison with its definitions

Prepare a values-only copy of columns A–E for publication, leaving the working reference cells behind. Keep the publication file rectangular: one header row, one country per row, no merged cells or subtotal rows. For a larger dataset, add fields such as indicator_code, source_name and retrieved_date. Record AG.SRF.TOTL.K2 for this example, and use your actual retrieval date—not the observation year.

Include a short description alongside the public table: “Selected countries compared by surface area, including inland water and some coastal waterways; 2024 observations; ratios relative to India.” Keep the source link visible and review the file before making it public.

TablePage accepts CSV, TSV, XLSX and XLS files and generates a public dataset page with a shareable link and filterable table. Upload only the reviewed comparison file, then check that areas and ratios appear as numbers and that the measure, year and reference country remain clear.

For a visual comparison, use a bar chart starting at zero or an equal-area map. Do not estimate relative size from ordinary Mercator outlines: USGS explains that Mercator area distortion increases away from the equator. The sourced table should remain available so readers can inspect the values behind the visual.