Dataset · Water

Freshwater withdrawals by country

Freshwater withdrawals by sector, renewable resources and water stress for 186 countries, from the World Bank and FAO AQUASTAT.

See download membership

Preview below without an account. Downloads require the $19.85 yearly membership. Already registered? Sign in. XLSX, ODS and XML keep formulas; CSV and Numbers contain values only.

XLSXCSVODSXMLNumbers
Freshwater withdrawals, renewable resources and water stress by country
Source: World Bank, World Development Indicators (original source: FAO AQUASTAT) · Retrieved 2026-10-08 · License: CC BY 4.0
Annual freshwater withdrawals (billion m³) by sector, renewable internal resources and SDG 6.4.2 water stress (%).
TOTAL WITHDRAWALS (BILLION M³)AGRICULTURE SHARE OF TOTALINDUSTRY SHARE OF TOTALDOMESTIC SHARE OF TOTAL
3,855.071.0%15.7%13.3%
Sum of latest published country totalsIrrigation and livestock shareDirect industrial and cooling waterMunicipal, household and public services
Regions and income groups: total withdrawals (billion m³), sector shares and renewable resources
Region or income groupTypeWithdrawals (bn m³)Share of totalWithdrawal bar (scale 0 to 1,500 bn m³)AgricultureIndustryDomesticRenewable (bn m³)
East Asia & PacificRegion1,212.231.4%███████████████████████72.1%12.9%15.0%10,105.6
Europe & Central AsiaRegion476.012.3%█████████51.8%28.7%19.1%7,070.9
Latin America & CaribbeanRegion354.09.2%███████74.4%9.1%16.5%13,867.7
Middle East, North Africa, Afghanistan & PakistanRegion493.612.8%█████████87.2%3.3%9.5%332.6
North AmericaRegion480.412.5%█████████37.5%49.4%13.2%5,668.0
South AsiaRegion706.218.3%█████████████90.3%2.3%7.4%1,880.0

Showing the first 16 of 40 rows and 12 of 13 columns. Cells with formulas show the formula on hover.

What does this dataset do?

This workbook gathers the World Bank's freshwater indicators, which come from FAO AQUASTAT, for 186 countries and territories. For each country it gives total annual freshwater withdrawals in billion cubic meters, the share used by agriculture, industry and households, renewable internal freshwater resources (total and per person) and the SDG water stress level. The year of every value sits in the column next to it.

Sector volumes are calculated by formula (total withdrawals times the sector share), and a By region tab summarizes withdrawals, sector shares and average stress by World Bank region and income group with SUMIF, COUNTIF and AVERAGEIF. A second tab holds the total-withdrawals time series for 2000-2022.

These are withdrawals, not consumption: part of the water returns to rivers and aquifers. AQUASTAT relies on infrequent national surveys, so many countries repeat the same published value for several years; a column shows since when, and the About tab explains how to read it. Blank cells mean the World Bank publishes no value, and nothing is estimated.

What’s inside

  • 186 countries and territories; 181 with total withdrawals, latest year 2022
  • Agriculture, industry and domestic shares plus sector volumes calculated by formula
  • Renewable internal resources for 183 countries and water stress for 178
  • Total-withdrawals time series, 2000-2022, for 181 countries
  • By region tab with SUMIF, COUNTIF and AVERAGEIF summaries by region and income group
  • Flags where the published value has not changed for years (survey-based data)

Which tabs does the workbook have?

TabWhat it holds
DashboardGlobal withdrawal and sector-share KPIs, regional bars, and the top 15 countries by freshwater withdrawals.
Latest valuesLatest value and year of every indicator per country, sector volumes by formula, and a repeated-value flag.
Withdrawals 2000-2022Total annual freshwater withdrawals (billion m³) per country and year, 2000-2022.
By regionSUMIF, COUNTIF and AVERAGEIF summary by World Bank region and income group.
AboutDefinitions, withdrawal versus consumption, indicator codes, data years, sources, licenses and gaps.

What formulas does this dataset use?

This dataset holds 1,348 formulas in 9,768 cells across 5 tabs, so 14% of its cells calculate. They use 21 distinct functions; the longest formula is 182 characters and 391 of them read from another tab.

FunctionUsesWhat it does
ISNUMBER1,860true for a number
IF1,017one result when a test is true, another when false
AND744true when every test is true
COUNTIF197counts cells meeting one condition
INDEX180value at a position in a range
SUMIF91adds values meeting one condition
IFERROR72swaps an error for a fallback value
SUMIFS33adds values meeting several conditions
MAX27largest value
MIN27smallest value
OR27true when any test is true
REPT27repeats text

The 12 most used of 21 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 Latest values and filter by region or income group, or sort by any column.
  2. Check the Year column beside a value, and the 'same value every year since' column, before comparing countries.
  3. Use the sector volume columns to see how many billion m³ each sector withdraws.
  4. Open the Withdrawals 2000-2022 tab to chart a country's total withdrawals over time.
  5. Read the By region tab for regional totals and shares, then copy the credit line from About.

What do the columns and units mean?

ColumnUnitMeaning
Total withdrawalsbillion m³ per yearAnnual freshwater withdrawals, total (ER.H2O.FWTL.K3).
Agriculture share% of total withdrawalsFreshwater withdrawals for agriculture (ER.H2O.FWAG.ZS).
Industry share% of total withdrawalsFreshwater withdrawals for industry (ER.H2O.FWIN.ZS).
Domestic share% of total withdrawalsFreshwater withdrawals for domestic use (ER.H2O.FWDM.ZS).
Sector withdrawalsbillion m³ per yearCalculated by formula: total withdrawals times sector share divided by 100.
Renewable internal freshwater resourcesbillion m³ per yearInternal river flows and groundwater recharge (ER.H2O.INTR.K3).
Renewable internal resources per capitam³ per person per yearER.H2O.INTR.PC, using World Bank population estimates.
Water stress%Freshwater withdrawal as a proportion of available freshwater resources (ER.H2O.FWST.ZS, SDG 6.4.2).
YearyearYear the World Bank assigns to the adjacent value.
Same value every year sinceyearFirst year of the unbroken run of identical total-withdrawal values ending at the latest year (derived).

Where does the data come from?

World Bank, World Development Indicators (original source: FAO AQUASTAT), licensed CC BY 4.0. Retrieved 8 Oct 2026.

Cite as: World Bank, World Development Indicators (ER.H2O.FWTL.K3, ER.H2O.FWAG.ZS, ER.H2O.FWIN.ZS, ER.H2O.FWDM.ZS, ER.H2O.INTR.K3, ER.H2O.INTR.PC, ER.H2O.FWST.ZS); original source FAO AQUASTAT; database last updated 2026-10-08; retrieved 2026-10-08 from https://api.worldbank.org/v2/. Licensed CC BY 4.0.

Original data: FAO AQUASTAT (https://data.apps.fao.org/aquastat/), accessed by the World Bank on 2024-05-29. FAO's database terms (CC BY 4.0 plus additional terms, including no implied FAO endorsement) apply to the original data. Annual values are as published by the World Bank; many countries repeat the last survey value in later years. Sector volumes are calculated as total withdrawals times sector share.

What is it good for?

  • Comparing agricultural water use across countries
  • Screening countries by water stress for a report or case study
  • Building charts of withdrawals per region
  • Classroom exercises on water use and scarcity
  • Joining water indicators to other country data on ISO3 codes

Questions about this sheet

Is withdrawal the same as water consumption?

No. Withdrawal is the water taken from a source; part of it returns to rivers or aquifers. Consumption is the part that evaporates or is built into products, and this dataset does not measure it.

Why do many countries show the same value year after year?

AQUASTAT depends on infrequent national surveys, and the World Bank publishes annual series. Many countries repeat their last reported value for several years. The Latest values tab shows since when, so you can judge how current each figure is.

Why can water stress be above 100 percent?

Withdrawals can exceed renewable resources when a country relies on desalination, fossil groundwater or reuse. Kuwait, Saudi Arabia and the United Arab Emirates are examples in the data.

Can I recompute water stress from the other columns?

Not exactly. The stress indicator divides withdrawals by total renewable resources (including inflows from other countries) minus environmental flows, while this workbook has only internal renewable resources.

Which countries are missing?

31 World Bank country-list entries, mostly small islands and territories, have none of the seven indicators. The About tab lists them.