TSB logo

How to use UN Comtrade



Depending on your information need and level of expertise of the UN Comtrade system, the website offers flexibility in finding the necessary trade data. Consider the following scenarios below:

Casual Visitor

Casual visitors are interested to see the overall trends in trade (and probably in specific products or countries/areas). For this, they can visit UN Comtrade Analytics or UK BIS Trade in Goods Visualization that offer a simple interactive trade data exploration through visualization. Or explore various trade data visualizations showcased at UN Comtrade Labs.

Small Data Downloader

Users who would like to view or download small amount of data (up to 100K per query) can use this data extraction interface:

Application Developer

Developers may use UN Comtrade API to access trade data. A good example is UK BIS Trade in Goods Visualization which codes are made available at GitHub: Other examples are shown at UN Comtrade Labs.

Bulk Data Downloader

Do you want to download a year of data (~25M of records with ~450MB zip file) in one click or API call? Bulk downloader may use bulk data API or bulk data interface. This is only applicable to subscribers.

Nevertheless, all users should understand the limitation of trade data. Read Data Disclaimer.


The text below applied only to Legacy UN Comtrade
(i) Using Search for data Box, also known as Comtrade Explorer [Any Pages]

There are two search options available, data and help. For data, you can enter only commodity code or text, partner or reporter code or name, and related commodity trade variables. The output would yield several pages with the results in tag clouds. For example, the search term could be the name of the country, the country's abbreviation, a commodity key word or a year. Examples: "aircraft" or "aircraft engine". The tag clouds appear as years for which the commodity selected is available. The first result shows that year 2004 has the largest value for that commodity. Clicking data availability option just below gives all the reporters and years for which the selected commodity (-ies) is/are available.

(ii) Using Shortcut Query [Front Page]

If reporter or partner is known, Shortcut Query is the easiest tool. Just type the commodity text on the box, select reporter/partner and click Search. The system will search the latest available data.

(iii) Using Basic Selection [Menu: Data Query -> Basic Selection]

Basic selection option is a little more sophisticated but still user friendly. You can search for commodities within the commodities tab. Within the reporters tab you can select one or more reporters from the drop down list or choose your customized country groups or my favorite reporters. The latter two options are available to UN Comtrade subscribers only. It is the same for partners tab also. You can select years depending on your need in the years tab. The others tab allows the user to filter trade data by value and also allows the user to choose a preset sort order.

After choosing all the appropriate options for your query you can save your query for future use. You can also allow for batch notification. Batch notification will send a notice to your email address once the query execution is completed. Please note these two options are also limited to subscribers of the UN Comtrade database only.

(iv) Using Express Selection [Menu: Data Query -> Express Selection]

The Express selection query option is for the more advanced user of UN Comtrade. It too has all the features of the Basic Selection query but in a more compact window.

For commodities, you have the option to choose individual commodities or just chapters. All specifies all commodities within the selected revision. AG0, AG1, … AG6 are aggregate levels and refer to all commodity codes beginning with the specified digits. LF or leaf refers to the basic code and does not include any of the detailed children. Wildcard * is used to find a string of zero or more characters. Wildcard ? is used to find individual characters. The Advanced Items tab is the same as in the Basic Selection.


Shortcut Query - Manual.pdf Shortcut Query - Manual.pdf (199.00 KB, 7.5K views)

Related Links

Also In This Category

Add Your Comments
Comments require login or registration.
Last Modified: 2 Years Ago
Last Modified By: comtrade_admin
Rated 3 stars based on 1 vote
Article has been viewed 73.4K times.
Find Similar