Sheet ReserveSpreadsheets worth keeping.

Dataset · Economy

Trade, exports, imports and current account by country, 2000-2025

Merchandise and services trade, exports, imports and current account balance (% of GDP) for 217 economies, 2000-2025.

Create an account

Downloads are included in the $19.85 yearly membership. Sign in

XLSXCSVODSXMLNumbers
Trade, exports, imports and current account by country, 2000-2025
Source: World Bank, World Development Indicators (NE.TRD.GNFS.ZS, NE.EXP.GNFS.ZS, NE.IMP.GNFS.ZS, BN.CAB.XOKA.GD.ZS) · Retrieved 2026-10-13 · License: CC BY 4.0
Merchandise and services trade, exports, imports and current account balance as % of GDP (2000-2025).
WORLD TRADE (% OF GDP, 2025)WORLD EXPORTS (% OF GDP, 2025)WORLD IMPORTS (% OF GDP, 2025)CURRENT ACCOUNT SURPLUS COUNTRIES
68.529.528.579
2025, World Bank WLD aggregate2025, World Bank WLD aggregate2025, World Bank WLD aggregateLatest published year per country
Regions and income groups, 2025: trade, exports and imports (% of GDP)
World, region or income groupCodeTrade (% GDP)Trade bar (scale 0 to 120%)Exports (% GDP)Imports (% GDP)Net exports (%)Trade 2000 (%)Change vs 2000
WorldWLD68.5████████████████29.528.51.050.118.4
East Asia & PacificEAS63.8███████████████32.528.54.152.411.4
Europe & Central AsiaECS81.8███████████████████43.741.02.769.112.7
Latin America & CaribbeanLCN49.1███████████26.126.4-0.336.312.9
Middle East, North Africa, Afghanistan & PakistanMEA57.2█████████████65.0-7.7
North AmericaNAC30.0

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

What does this dataset do?

This workbook holds four external-sector indicators from the World Bank's World Development Indicators for 217 countries and territories from 2000 to 2025: total trade in goods and services (% of GDP), exports of goods and services (% of GDP), imports of goods and services (% of GDP), and the current account balance (% of GDP). Each indicator has its own wide tab laid out as one row per country and one column per year.

The Latest year tab retrieves each country's most recent published value for all four series by formula, calculates net exports (exports minus imports when both come from the same year), and draws an in-cell trade-openness bar. The Dashboard compares World Bank regions and income groups and ranks the 15 economies with the highest trade share of GDP.

All values are the World Bank's published figures, unmodified. Where no value is published, the cell remains blank. The About tab documents the indicator codes, definitions and CC BY 4.0 credit line.

What’s inside

  • 217 countries and territories, 2000-2025, with ISO3 code, region and income group
  • Four WDI indicators: NE.TRD.GNFS.ZS, NE.EXP.GNFS.ZS, NE.IMP.GNFS.ZS, BN.CAB.XOKA.GD.ZS
  • Dashboard with world KPIs, regional trade bars and a formula-driven top-15 openness ranking
  • Latest year tab with INDEX/MATCH lookups, net exports formula and trade share bars
  • World Bank aggregates for the world, 7 regions and 4 income groups
  • CC BY 4.0 license with a ready-to-copy credit line on the About tab

Which tabs does the workbook have?

TabWhat it holds
DashboardWorld KPIs for 2025, regional comparisons with bars and the top 15 economies by trade share.
Trade (% of GDP)Sum of exports and imports of goods and services as % of GDP, 2000-2025.
Exports (% of GDP)Exports of goods and services as % of GDP, 2000-2025.
Imports (% of GDP)Imports of goods and services as % of GDP, 2000-2025.
Current account (% of GDP)Current account balance as % of GDP, 2000-2025.
Latest yearLatest published year and value for each series per country, net exports formula and trade bar.
Regions & income groupsWorld Bank aggregates for the world, seven regions and four income groups.
AboutIndicator codes, definitions, sources, CC BY 4.0 license and credit line.

What formulas does this dataset use?

This dataset holds 1,757 formulas in 26,588 cells across 8 tabs, so 7% of its cells calculate. They use 12 distinct functions; the longest formula is 117 characters and 1,055 of them read from another tab.

FunctionUsesWhat it does
IF1,681one result when a test is true, another when false
INDEX1,048value at a position in a range
MATCH883position of a value in a range
ISNUMBER699true for a number
MAX244largest value
MIN244smallest value
OR244true when any test is true
REPT244repeats text
ROUND244rounds to a number of digits
AND241true when every test is true
COUNTIF218counts cells meeting one condition
LARGE15nth largest value

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 Dashboard for global KPIs, regional comparisons and the top 15 trade-intensive economies.
  2. Select any indicator tab to read a country's annual series across a row or compare countries down a year column.
  3. Use the Latest year tab to compare exports, imports, net exports and current account balances side by side.
  4. Filter by World Bank region or income group using the header drop-downs.
  5. Copy the citation from the About tab when publishing charts or tables.

What do the columns and units mean?

ColumnUnitMeaning
Country / ISO3 / Region / Income grouptext / codeWorld Bank country name, three-letter code, region and income classification.
Trade (2000-2025)% of GDPSum of exports and imports of goods and services divided by GDP (NE.TRD.GNFS.ZS).
Exports (2000-2025)% of GDPExports of goods and services divided by GDP (NE.EXP.GNFS.ZS).
Imports (2000-2025)% of GDPImports of goods and services divided by GDP (NE.IMP.GNFS.ZS).
Current account balance (2000-2025)% of GDPSum of net exports, net primary income and net secondary income divided by GDP (BN.CAB.XOKA.GD.ZS).
Net exports% of GDPFormula on Latest year tab: exports (% of GDP) minus imports (% of GDP) when both refer to the same year.

Where does the data come from?

World Bank, World Development Indicators, licensed CC BY 4.0. Retrieved 13 Oct 2026.

Cite as: World Bank, World Development Indicators (NE.TRD.GNFS.ZS, NE.EXP.GNFS.ZS, NE.IMP.GNFS.ZS, BN.CAB.XOKA.GD.ZS), database last updated 2026-10-08; retrieved 2026-10-13 from https://api.worldbank.org/v2/. Licensed CC BY 4.0.

Underlying sources per the World Bank: World Bank and OECD national accounts data, and IMF Balance of Payments Statistics Yearbook. Values are unmodified.

What is it good for?

  • Comparing trade openness and export share across countries
  • Screening economies by current account surplus or deficit (% of GDP)
  • Checking net exports of goods and services against overall current account balances
  • Joining trade indicators to GDP and inflation workbooks on ISO3 codes
  • Building regional trade comparison tables for macroeconomic reports

Questions about this sheet

How can trade exceed 100 percent of GDP?

Trade is the sum of gross exports and gross imports, whereas GDP measures domestic value added. Trading hubs that import intermediates and re-export finished goods regularly record gross trade above 100 or 200 percent of GDP.

What is the difference between net exports and the current account balance?

Net exports cover only trade in goods and services (exports minus imports). The current account balance adds net primary income (such as investment income) and net secondary income (such as remittances and transfers).

Why are some country cells blank?

The World Bank publishes no value for that country and year, and this workbook does not interpolate or estimate missing observations.

Can I reuse this dataset commercially?

Yes. The World Bank publishes the World Development Indicators under CC BY 4.0, which permits commercial use and adaptation with attribution.