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.
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 TOTAL | INDUSTRY SHARE OF TOTAL | DOMESTIC SHARE OF TOTAL | ||||||||
| 3,855.0 | 71.0% | 15.7% | 13.3% | ||||||||
| Sum of latest published country totals | Irrigation and livestock share | Direct industrial and cooling water | Municipal, household and public services | ||||||||
| Regions and income groups: total withdrawals (billion m³), sector shares and renewable resources | |||||||||||
| Region or income group | Type | Withdrawals (bn m³) | Share of total | Withdrawal bar (scale 0 to 1,500 bn m³) | Agriculture | Industry | Domestic | Renewable (bn m³) | |||
| East Asia & Pacific | Region | 1,212.2 | 31.4% | ███████████████████████ | 72.1% | 12.9% | 15.0% | 10,105.6 | |||
| Europe & Central Asia | Region | 476.0 | 12.3% | █████████ | 51.8% | 28.7% | 19.1% | 7,070.9 | |||
| Latin America & Caribbean | Region | 354.0 | 9.2% | ███████ | 74.4% | 9.1% | 16.5% | 13,867.7 | |||
| Middle East, North Africa, Afghanistan & Pakistan | Region | 493.6 | 12.8% | █████████ | 87.2% | 3.3% | 9.5% | 332.6 | |||
| North America | Region | 480.4 | 12.5% | █████████ | 37.5% | 49.4% | 13.2% | 5,668.0 | |||
| South Asia | Region | 706.2 | 18.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.
| Freshwater withdrawals, renewable resources and water stress: latest value by country | |||||||||||
| Source: World Bank, World Development Indicators (original source: FAO AQUASTAT) · Retrieved 2026-10-08 · Licence: CC BY 4.0 | |||||||||||
| Country | ISO3 | Region | Income group | Total withdrawals (billion m³) | Year | Total withdrawals: same value every year since | Agriculture share (% of total) | Year | Industry share (% of total) | Year | Domestic share (% of total) |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 20.282 | 2022 | 1998 | 98.2 | 2022 | 0.8 | 2022 | 1.0 |
| Albania | ALB | Europe & Central Asia | Upper middle income | 0.797 | 2022 | 2022 | 70.9 | 2022 | 1.4 | 2022 | 27.7 |
| Algeria | DZA | Middle East, North Africa, Afghanistan & Pakistan | Upper middle income | 10.292 | 2022 | 2022 | 67.4 | 2022 | 1.7 | 2022 | 30.9 |
| Andorra | AND | Europe & Central Asia | High income | ||||||||
| Angola | AGO | Sub-Saharan Africa | Lower middle income | 0.706 | 2022 | 2005 | 20.8 | 2022 | 33.9 | 2022 | 45.3 |
| Antigua and Barbuda | ATG | Latin America & Caribbean | High income | 0.004 | 2022 | 2012 | 15.7 | 2022 | 21.7 | 2022 | 62.6 |
| Argentina | ARG | Latin America & Caribbean | Upper middle income | 37.690 | 2022 | 2011 | 73.9 | 2022 | 10.6 | 2022 | 15.5 |
| Armenia | ARM | Europe & Central Asia | Upper middle income | 3.072 | 2022 | 2022 | 77.5 | 2022 | 4.9 | 2022 | 17.6 |
| Australia | AUS | East Asia & Pacific | High income | 11.620 | 2022 | 2022 | 66.9 | 2022 | 18.6 | 2022 | 14.5 |
| Austria | AUT | Europe & Central Asia | High income | 3.140 | 2022 | 2019 | 5.2 | 2022 | 93.3 | 2022 | 1.5 |
| Azerbaijan | AZE | Europe & Central Asia | Upper middle income | 13.027 | 2022 | 2022 | 92.2 | 2022 | 4.6 | 2022 | 3.1 |
| Bahamas, The | BHS | Latin America & Caribbean | High income | ||||||||
| Bahrain | BHR | Middle East, North Africa, Afghanistan & Pakistan | High income | 0.155 | 2022 | 2016 | 33.3 | 2022 | 3.2 | 2022 | 63.4 |
Showing the first 16 of 189 rows and 12 of 24 columns. Cells with formulas show the formula on hover.
| Annual freshwater withdrawals, total (billion m³), 2000-2022 | |||||||||||
| Source: World Bank, World Development Indicators (original source: FAO AQUASTAT) · Retrieved 2026-10-08 · Licence: CC BY 4.0 | |||||||||||
| Country | ISO3 | Region | Income group | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 |
| Afghanistan | AFG | Middle East, North Africa, Afghanistan & Pakistan | Low income | 20.282 | 20.282 | 20.282 | 20.282 | 20.282 | 20.282 | 20.282 | 20.282 |
| Albania | ALB | Europe & Central Asia | Upper middle income | 1.838 | 1.750 | 1.663 | 1.576 | 1.488 | 1.401 | 1.272 | 1.248 |
| Algeria | DZA | Middle East, North Africa, Afghanistan & Pakistan | Upper middle income | 5.633 | 5.807 | 6.044 | 6.220 | 6.397 | 6.574 | 6.750 | 6.927 |
| Angola | AGO | Sub-Saharan Africa | Lower middle income | 0.640 | 0.653 | 0.667 | 0.680 | 0.693 | 0.706 | 0.706 | 0.706 |
| Antigua and Barbuda | ATG | Latin America & Caribbean | High income | 0.004 | 0.004 | 0.004 | 0.005 | 0.005 | 0.005 | 0.005 | 0.005 |
| Argentina | ARG | Latin America & Caribbean | Upper middle income | 30.367 | 31.032 | 31.698 | 32.364 | 33.029 | 33.695 | 34.360 | 35.026 |
| Armenia | ARM | Europe & Central Asia | Upper middle income | 1.871 | 1.726 | 1.733 | 1.976 | 2.503 | 2.771 | 2.827 | 3.012 |
| Australia | AUS | East Asia & Pacific | High income | 21.659 | 21.534 | 20.834 | 20.134 | 19.433 | 18.733 | 17.557 | 16.380 |
| Austria | AUT | Europe & Central Asia | High income | 3.636 | 3.607 | 3.577 | 3.566 | 3.555 | 3.544 | 3.534 | 3.523 |
| Azerbaijan | AZE | Europe & Central Asia | Upper middle income | 10.990 | 9.923 | 9.919 | 10.518 | 11.175 | 11.800 | 12.144 | 12.085 |
| Bahrain | BHR | Middle East, North Africa, Afghanistan & Pakistan | High income | 0.289 | 0.272 | 0.256 | 0.239 | 0.233 | 0.228 | 0.222 | 0.217 |
| Bangladesh | BGD | South Asia | Lower middle income | ||||||||
| Barbados | BRB | Latin America & Caribbean | High income | 0.081 | 0.081 | 0.081 | 0.081 | 0.081 | 0.070 | 0.070 | 0.070 |
Showing the first 16 of 184 rows and 12 of 27 columns. Cells with formulas show the formula on hover.
| Freshwater withdrawals by World Bank region and income group (sums of the Latest values tab) | |||||||||||
| Source: World Bank, World Development Indicators (original source: FAO AQUASTAT) · Retrieved 2026-10-08 · Licence: CC BY 4.0 · Sums cover only countries with data | |||||||||||
| Group type | Group | Countries in table | Countries with withdrawal data | Total withdrawals (billion m³) | Agriculture (billion m³) | Industry (billion m³) | Domestic (billion m³) | Agriculture share of withdrawals | Industry share of withdrawals | Domestic share of withdrawals | Renewable internal freshwater resources (billion m³) |
| Region | East Asia & Pacific | 23 | 20 | 1,212.2 | 874.4 | 156.0 | 181.9 | 72.1% | 12.9% | 15.0% | 10,105.6 |
| Region | Europe & Central Asia | 50 | 49 | 476.0 | 246.4 | 136.6 | 91.1 | 51.8% | 28.7% | 19.1% | 7,070.9 |
| Region | Latin America & Caribbean | 34 | 33 | 354.0 | 263.4 | 32.2 | 58.5 | 74.4% | 9.1% | 16.5% | 13,867.7 |
| Region | Middle East, North Africa, Afghanistan & Pakistan | 23 | 23 | 493.6 | 430.2 | 16.4 | 46.9 | 87.2% | 3.3% | 9.5% | 332.6 |
| Region | North America | 2 | 2 | 480.4 | 180.1 | 237.1 | 63.3 | 37.5% | 49.4% | 13.2% | 5,668.0 |
| Region | South Asia | 6 | 6 | 706.2 | 637.8 | 16.1 | 52.2 | 90.3% | 2.3% | 7.4% | 1,880.0 |
| Region | Sub-Saharan Africa | 48 | 48 | 132.5 | 104.7 | 9.4 | 18.4 | 79.0% | 7.1% | 13.9% | 3,883.8 |
| Income group | High income | 62 | 59 | 952.4 | 407.0 | 379.0 | 166.4 | 42.7% | 39.8% | 17.5% | 14,884.8 |
| Income group | Upper middle income | 53 | 53 | 1,646.4 | 1,212.3 | 190.0 | 242.0 | 73.6% | 11.5% | 14.7% | 18,559.8 |
| Income group | Lower middle income | 46 | 44 | 1,139.0 | 1,011.3 | 31.6 | 96.1 | 88.8% | 2.8% | 8.4% | 7,056.8 |
| Income group | Low income | 25 | 25 | 117.2 | 106.5 | 3.0 | 7.7 | 90.9% | 2.6% | 6.6% | 2,307.2 |
| All | All countries in table | 186 | 181 | 3,855.0 | 2,737.0 | 603.7 | 512.2 | 71.0% | 15.7% | 13.3% | 42,808.6 |
Showing the first 16 of 18 rows and 12 of 14 columns. Cells with formulas show the formula on hover.
| About this dataset | |
| Source: World Bank WDI (FAO AQUASTAT) · Retrieved 2026-10-08 · Licence: CC BY 4.0 | |
| What this workbook is | |
| Summary | Freshwater withdrawals for 181 countries and territories (186 with at least one water indicator), split by agriculture, industry and domestic use, set against renewable internal freshwater resources and the SDG water stress level. Figures… |
| Withdrawal versus consumption | |
| Withdrawal | Water taken from rivers, lakes or aquifers (or produced by desalination) for use. It is not the same as consumption. Part of withdrawn water returns to the system, for example power-plant cooling water or irrigation return flow, while cons… |
| Over 100 percent | Withdrawals can exceed renewable resources where water comes from desalination, non-renewable (fossil) groundwater or reuse. Several arid countries show water stress far above 100 percent (for example Kuwait, Saudi Arabia, the United Arab… |
| Stress is not a ratio of two columns | ER.H2O.FWST.ZS divides total withdrawals by total actual renewable water resources (internal plus inflows from other countries) minus environmental flow requirements. This workbook carries only internal renewable resources, so the stress c… |
| Tabs | |
| Dashboard | Global withdrawal and sector-share KPI tiles, regional and income-group withdrawal bars, and the top 15 countries by total freshwater withdrawals. |
| Latest values | One row per country with the latest published value of each indicator and its year in the next column. Sector volumes (billion m³) are formulas: total withdrawals times the sector share divided by 100, calculated only when both figures are… |
| Withdrawals 2000-2022 | Total annual freshwater withdrawals (billion m³), one column per year, 2000-2022. |
| By region | SUMIF, SUMIFS, COUNTIF and AVERAGEIF summaries of the Latest values tab by World Bank region and income group. |
Showing the first 16 of 63 rows and 2 of 2 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?
| Tab | What it holds |
|---|---|
| Dashboard | Global withdrawal and sector-share KPIs, regional bars, and the top 15 countries by freshwater withdrawals. |
| Latest values | Latest value and year of every indicator per country, sector volumes by formula, and a repeated-value flag. |
| Withdrawals 2000-2022 | Total annual freshwater withdrawals (billion m³) per country and year, 2000-2022. |
| By region | SUMIF, COUNTIF and AVERAGEIF summary by World Bank region and income group. |
| About | Definitions, 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.
| Function | Uses | What it does |
|---|---|---|
ISNUMBER | 1,860 | true for a number |
IF | 1,017 | one result when a test is true, another when false |
AND | 744 | true when every test is true |
COUNTIF | 197 | counts cells meeting one condition |
INDEX | 180 | value at a position in a range |
SUMIF | 91 | adds values meeting one condition |
IFERROR | 72 | swaps an error for a fallback value |
SUMIFS | 33 | adds values meeting several conditions |
MAX | 27 | largest value |
MIN | 27 | smallest value |
OR | 27 | true when any test is true |
REPT | 27 | repeats 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?
- Open Latest values and filter by region or income group, or sort by any column.
- Check the Year column beside a value, and the 'same value every year since' column, before comparing countries.
- Use the sector volume columns to see how many billion m³ each sector withdraws.
- Open the Withdrawals 2000-2022 tab to chart a country's total withdrawals over time.
- Read the By region tab for regional totals and shares, then copy the credit line from About.
What do the columns and units mean?
| Column | Unit | Meaning |
|---|---|---|
| Total withdrawals | billion m³ per year | Annual freshwater withdrawals, total (ER.H2O.FWTL.K3). |
| Agriculture share | % of total withdrawals | Freshwater withdrawals for agriculture (ER.H2O.FWAG.ZS). |
| Industry share | % of total withdrawals | Freshwater withdrawals for industry (ER.H2O.FWIN.ZS). |
| Domestic share | % of total withdrawals | Freshwater withdrawals for domestic use (ER.H2O.FWDM.ZS). |
| Sector withdrawals | billion m³ per year | Calculated by formula: total withdrawals times sector share divided by 100. |
| Renewable internal freshwater resources | billion m³ per year | Internal river flows and groundwater recharge (ER.H2O.INTR.K3). |
| Renewable internal resources per capita | m³ per person per year | ER.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). |
| Year | year | Year the World Bank assigns to the adjacent value. |
| Same value every year since | year | First 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.