How to read the Bilateral Trade Explorer
I built the Bilateral Trade Explorer because I kept running into the same problem. People talk about trade between two countries as if it were one number, a single surplus or deficit, when the real story is hundreds of different products moving in both directions. I wanted a way to pick any two countries and see the whole picture at once. This post explains what the tool shows and how to get the most out of it.
What it does
You pick two countries, or the European Union as a single bloc, and the explorer lays out every category of goods they trade and how much each one is worth. The categories follow the Harmonized System, which is the standard the whole world uses to classify traded goods. At the top level there are 97 chapters, covering everything from live animals to aircraft to works of art. You see all of them, sorted by value, for the most recent full year of data.
Where the numbers come from
The trade values come from CEPII's BACI dataset, which reconciles the import and export figures that countries report to the United Nations into a single clean set of bilateral flows. The tariff figures are built on top of trade weighted applied rates, with current rates filled in by hand for the largest economies so that the big relationships, like the United States, China, the European Union, the United Kingdom, and Japan, reflect what is actually charged today rather than an old baseline.
Reading the balance bars
For each chapter there is a bar that shows the balance of trade in that category. The first country you picked sits on the left and the second sits on the right, and the bar leans toward whichever side exports more. This is the part I find most useful. Two countries can have a roughly even total relationship while being wildly lopsided product by product. One side sends raw materials and the other sends finished machines, and the balance bars make that visible at a glance.
Drilling down
The 97 chapters are a starting point, not the end. Click a two digit chapter and it opens into the four digit products inside it. A chapter like electrical machinery splits into phones, circuits, wiring, and dozens of other lines, so you can keep narrowing until you find the specific products that drive the relationship. Click again to collapse it and go back to the overview.
A few things worth trying
Pick the United States and China and look at how much of the relationship sits in just a handful of electronics and machinery chapters. Then pick two neighbors, like Canada and the United States, and notice how energy and vehicles dominate instead. Try a small country against a large one and watch the balance bars swing hard in one direction across almost every category. The flags next to each country are there to make scanning easier when you are comparing several pairs in a row.
Why bilateral trade is worth a closer look
Trade headlines usually shrink a relationship down to one figure and one verdict. The truth is more interesting and a lot more specific. Most of the value moves through a few categories, the balance often runs opposite ways in different products, and tariffs land unevenly across them. The point of the explorer is to let you see that detail without needing a spreadsheet or a background in economics. Pick two countries, follow the biggest bars, and the shape of the relationship shows up on its own.