Get help with creating custom data tables

This section is Guidance

Learn how you can explore and customise detailed trade data using the interactive data tables on our website.

Before you start

Before you use our interactive data tables, read our detailed guide to using our data to:

  • learn more about this data and our data sources
  • understand key terms and definitions
  • find out about methods we use to produce statistics

You can also read our guide to how goods are classified. This will help you to:

  • understand the main types of systems used to classify goods, such as the Harmonised System  and Combined Nomenclature
  • learn how commodity codes are structured
  • get help with comparing goods in different classification systems

If you need large volumes of trade data, you can download overseas trade datasets and regional trade datasets to use with your own software. You can also access our data using our API service.

Select a dataset to explore

Firstly, you will need to select the dataset you want to explore. You can choose from:

There are key differences between the different types of datasets.

Overseas trade by commodity code provides:

  • UK import and export trade data from 2000 to the latest period, by month
  • Harmonised System (HS) commodity data at 2-, 4-, and 6-digit levels
  • Combined Nomenclature (CN) commodity data at 8-digit level
  • EU estimates for non-response and Below Threshold trade at HS 2-digit level
  • UK port data (place of clearance) for non-EU trade
  • trade suppressed to protect confidentiality at HS 2-digit level

Overseas trade by Standard International Trade Classification (SITC) provides:

  • SITC correlation of the Overseas Trade Statistics (OTS) from 1996 to the latest period, by month
  • SITC commodity data at the 1- to 5-digit levels
  • EU estimates for non-response and Below Threshold trade at SITC 2-digit level
  • UK port data (place of clearance) for non-EU trade
  • trade suppressed to protect confidentiality at HS 2-digit level

Regional trade data provides:

  • Regional Trade Statistics data from 2013 to the latest quarter
  • OTS imports and exports data, allocated to a standard UK region

Some data may be withheld for confidentiality. Learn more about suppressed data.

Change the default table view

After you select a dataset, you will be presented with a default table.

By default, this table will group all available data for 2020 for UK trade in goods, for all commodities and countries.

Here is how you can view more specific data.

Add or change rows

You can add or change the table rows to change the order in which the data is presented.

Using the dropdown menu next to ‘Rows’, select the first row you want to display in the table. 

You can choose from the following types of table rows:

  • commodities, organised by:
    • HS or CN commodity code (shown as ‘comcode’)
    • SITC code
  • country, organised by geographical region (shown as ‘continent’)
  • UK ports

You can add more rows to the table using the ‘Add another dimension’ dropdown menu.

You can add up to three different types of rows. 

You cannot add rows for both ‘Commodities by comcode’ or ‘Commodities by SITC code’, as these refer to different systems for classifying goods.

Change column headings

Select Change column headings to show the options for table columns.

Use the checkboxes to select the table columns you want to add.

To change the width of columns in the table (some browsers may not support this feature):

  1. hover your mouse pointer between the column headings until a double-headed arrow appears
  2. select and drag the column to change its width

Trade direction

Select the Trade direction checkbox if you want to view a breakdown of the trade data by imports or exports.  This checkbox is selected by default.

Volume

Select the £ checkbox to show the reported trade value in pounds sterling (£) in your table. This checkbox is selected by default.

Select the Net mass checkbox to show data for the net mass of the goods. Net mass means the weight of the goods including immediate packaging. This is shown in kilograms (kg), rounded up to the nearest kilogram.

Select the Supplementary units checkbox to show supplementary units in your table. A supplementary unit is a second quantity used by some commodity codes. It can refer to square metres, litres, grams or another unit of measure. 

You should note: 

  • some commodity codes will not have net mass or supplementary units data
  • for commodity groups with different supplementary units, data will be shown as ‘-1’ instead of an actual value

How to explore table rows

Here you can find out how to drill down into a table to view the data in more detail.

First, go to a row in the table and select the expand option (+) to show the next level of data.

To continue drilling down further, select the expand option (+) on the next row. Repeat this until you find the level of detail you need, or you reach the last level of the data.

In the same way, you can hide table rows by selecting the collapse option (-) on the row.

You can also drill down by selecting the down arrow icon (↓). To do this:

  1. Hover over the table to show the Drill on option
  2. Select the Rows option in the dropdown menu
  3. Select the down arrow icon (↓) to the right of the dropdown menu
  4. Select a row to expand it

You should note that if you view HS data at 4- or 6- digit level, total values shown will not include the value of any suppressed data.

Keyboard shortcuts

You can also use keyboard shortcuts to navigate the data table using a keyboard.

To view a list of available keyboard shortcuts, press and hold Shift on your keyboard, then press the ? key.

How to customise the data table

Use the filter options to select and change: 

  • commodities
  • countries
  • UK ports
  • specific years, quarters or months
  • trade flow, such as imports or exports

You can find a guide to each option below.

Filter options are only shown if data is available.

Find data by commodity code or description

To view data at commodity level, select the Commodity dropdown menu.

Next to the dropdown menu, you can select:

  • HS to find commodities classified using the Harmonised System
  • SITC to find commodities classified using the Standard International Trade Classification

You can add multiple commodities to a table. 

You can find a commodity to add to the table by using the search field in the dropdown menu. You can enter either a commodity code or a description to view suggestions.

Alternatively, use the down arrow (V) symbol to expand a section and drill down to specific commodities or commodity groups.

You can scroll down the list to view more commodities.

Select the checkbox next to the commodity to add it to the table, or deselect it to remove it.

When you have finished adding commodities, select Apply to update the table.

Find data by country

To view data at country level, select the Country dropdown menu.

You can add multiple countries to a table.

You can find a country to add to the table by using the search field in the dropdown menu.

Alternatively, use the down arrow (V) symbol to expand a section and drill down to specific countries or geographical regions.

You can scroll down the list to view more countries.

Select the checkbox next to the country to add it to the table, or deselect it to remove it.

When you have finished adding countries, select Apply to update the table.

Find data by UK port

To view data at UK port level, select the Ports dropdown menu.

You can add multiple UK ports to a table.

You can find a port to add to the table by using the search field in the dropdown menu.

Alternatively, use the down arrow (V) symbol to expand a section and drill down to specific ports.

You can scroll down the list to view more ports.

Select the checkbox next to the port to add it to the table, or deselect it to remove it.

When you have finished adding ports, select Apply to update the table.

Select a date period

You should note: 

  • monthly data is only available for Overseas Trade Statistics data
  • quarterly data is only available for Regional Trade Statistics data

To view overseas trade data for a specific period, select the Year, Month dropdown menu.

If you are viewing regional trade data, a Year, Quarter dropdown menu will be shown instead.

By default, the year 2020 is selected.

You can add multiple date periods to a table, or select all available years.

Alternatively, use the down arrow (V) symbol to expand a year and select a more specific time period within the year.

You can scroll down the list to view more years.

Select the checkbox next to the year, month or quarter to add it to the table, or deselect it to remove it.

When you have finished adding date periods, select Apply to update the table.

How to show years, months and quarters

  1. Hover over the table to show the Drill on option
  2. Select the Columns option in the dropdown menu
  3. Select the down arrow icon (↓) to the right of the dropdown menu
  4. Select a trade flow column to show years
  5. Select a year column to show the monthly or quarterly data

Years, months and quarters are only shown if data is available.

Find data by trade flow

To view data by trade flow, select the Flow type dropdown menu.

You can choose to view any of the following options, or select all.

  • EU - Imports
  • EU - Exports
  • Non-EU - Imports
  • Non-EU - Exports

You can add multiple selections to a table. 

Select the checkbox next to the trade flow to add it to the table, or deselect it to remove it.

When you have finished adding trade flows, select Apply to update the table.

How to sort the data by value

You can change the order in which data is presented in the table.

By default, the data will be arranged by commodity code in numerical order  (for example, 01 before 02).

You may want to view the data by monetary value instead. To do this:

  1. Hover over the table to show the extra table options
  2. Select the More options menu, shown as 3 dots
  3. Select Sort by then Value (£)

By default, this sorts the data in descending order, so the largest value is displayed first in the column.

If you have multiple columns in your table, the data will be sorted by the sum of all the values in the row. 

If you want the smallest value to be displayed first:

  1. Hover over the table to show the extra table options
  2. Select the More options menu, shown as 3 dots
  3. Select Sort ascending

Save or share a data table

You do not need to register to save a table.

To save a copy of your table to your device, select the Download this table in CSV format button.

The CSV file will contain the full commodity data in the table, so be aware of this if you are viewing higher-level data in the table shown onscreen.

You can download up to 30,000 rows of data using this option. To download larger datasets, we recommend using the Export data option or our  API service.

How to use the Export data option

You can export up to 150,000 rows using the Export data option. Follow these steps:

  1. Hover over the table to show the extra table options
  2. Select the More options menu, shown as 3 dots
  3. Select Export data
  4. On the next screen, select the Export button.

How to copy table data

You can also copy table data to paste into a spreadsheet by following these steps.

  1. Right-click a row or column heading in the table
  2. In the menu that appears, select Copy, then Copy selection

Alternatively, you can save a table by bookmarking the page, or selecting the Share or link to this table button.

Copy the link shown to a safe place so you can come back to it later.

If you need help with this service

If you have a question not covered by this guide, email uktradeinfo@hmrc.gov.uk.