Skip to main content

Publications

Trade statistical pivot tables

An accompanying range of tables for DFAT’s trade statistical publications have been released in pivot table format using MS Excel, a tool that enables users to easily access trade time series data. All users with access to MS Excel 2007 or 2020 will be able to download the pivot tables.

Guide to using the trade statistical pivot tables [PDF 2 MB]

Guide to using the trade statistical pivot tables [DOCX 5 MB]

SITCr4

Australia's exports and imports by all countries and selected country groups using the United Nations' Standard International Trade Classification revision 4 (SITCr4) at the 3-digit level. Yearly time series data is available from 2005–06 to 2020-21. Annual time series data is available from 2006 to 2020. Due to size limits the State/Territory pivot table is limited to the latest ten years of data.

For more information on the SITC classification refer to the United Nations webpage.

Australia level (now includes DFAT estimates for LNG exports by partner country)

Country and commodity pivot table 2006 to 2020 [XLSX 7.8 MB]
Last updated: August 2021 using ABS catalogue 5368.0 (June 2021 data)

Country and commodity pivot table 2005–06 to 2020–21 [XLSX 8.2 MB]
Last updated: September 2021 using ABS catalogue 5368.0 (July 2021 data)

Monthly series

Country and commodity pivot table monthly Jul-2018 to Aug-2021 [XLSX 10.5 MB]
Last updated: October 2021 ABS catalogue 5368.0 (August 2021 data)

State/territory level

State by country and SITC pivot table 2011 to 2020 [XLSX 16.1 MB]
Last updated: August 2021 using ABS catalogue 5368.0 (June 2021 data)

State by country and SITC pivot table 2011-12 to 2020-21 [XLSX 15.3 MB]
Last updated: September 2021 using ABS catalogue 5368.0 (July 2021 data)

TRIEC

Australia's exports and imports by all countries and selected country groups using DFAT's Trade Import Export Classification (TRIEC) at the 1-, 2-, 3- and 4-digit levels – ie trade data by Primary products and Manufactured products such as Simply transformed manufactures (STM) and Elaborately transformed manufactures (ETM). Export data is also split between total exports and Australian produced exports (Australia level only). Yearly time series data is available from 1989–90 to 2020-21. Annual time series data is available from 1990 to 2020.

For more information on the TRIEC classification refer to the TRIEC webpage.

Australia level (now includes DFAT estimates for LNG exports by partner country)

Country and TRIEC pivot table 1990 to 2020 [XLSX 7.5 MB]
Last updated: August 2021 using ABS catalogue 5368.0 (June 2021 data)

Country and TRIEC pivot table 1989-90 to 2020-21 [XLSX 8.1 MB]
Last updated: September 2021 using ABS catalogue 5368.0 (July 2020 data)

State/territory level

State by country and TRIEC pivot table 1990 to 2020 [XLSX 16.6 MB]
Last updated: August 2021 using ABS catalogue 5368.0 (June 2021 data)

State by country and TRIEC pivot table 1990-91 to 2020-21 [XLSX 15.7 MB]
Last updated: September 2021 using ABS catalogue 5368.0 (July 2021 data)

AHECC/HTISC

Australia's merchandise exports and imports data at the most detailed level published by the Australian Bureau of Statistics. The export pivot table presents total Australian exports using the Australian Harmonised Export Commodity Classification (AHECC) at the 2 ,4, 6 and 8 digit level. The imports pivot table presents total Australian imports using the Harmonised Tariff Item Stat-key Classification (HTISC) at the 2, 4, 6, 8 and 10 digit level. Annual time series data is available from 2007 to 2020. Financial time series data is available from 2006-07 to 2020-21. Due to the size of these datasets Partner country and State/Territory level data could not be included.

Please read the accompanying explanatory notes before using these tables. For more information and a copy of the classification please refer to the ABS website for the AHECC and the Australian Border Force website for the HTSIC.

AHECC

Australia AHECC export pivot table 2007 to 2020 [XLSX 3.7 MB]
Last updated: August 2021 using ABS catalogue 5368.0 (June 2021 data)

Australia AHECC export pivot table 2006-07 to 2020-21 [XLSX 4.5 MB]
Last updated: September 2021 using ABS catalogue 5368.0 (July 2021 data)

HTISC

Australia HTISC import pivot table 2007 to 2020 [XLSX 4.7 MB]
Last updated: August 2021 using ABS catalogue 5368.0 (June 2021 data)

Australia HTISC import pivot table 2006-07 to 2020-21 [XLSX 5.6 MB]
Last updated: September 2021 using ABS catalogue 5368.0 (July 2021 data)

Please email comments regarding all our trade statistical products to statssection@dfat.gov.au

Back to top