Guru's Verification engine ensures consistency, confidence, and trust in the knowledge your organization shares. Learn more.

CPT Collection Instructions


Step 1) Go to https://portal.sw.nat.gov.tw/APGA/GA30E

Step 2) Check the box at “Total Imports” and "Total Exports"

image.png

Step 3) Check the box "Monthly" at "Periodicity" and input the period presented on the collection spreadsheet (check the pictures bellow).

Obs: The image below is just an example (input the period you received in the spreadsheet)

TAIWAN2 (Custom).png

TAIWAN3.png

Step 4) Select the option "Fill in the code (2/4/6/8/11-digits)" at "Commodity".

Step 5) Copy the Cell 'D7' next to 'Commodity' on the collection spreadsheet (check the pictures below) and paste in the "Please split the codes with ',' when you input more than one code." field on the CPT website. (Make sure there are no spaces after the last number)

TAIWAN1 (Custom).png

TAIWAN4.png

Step 6) Check the box "Detailed" at "Partner"

Step 7) Check the boxes "USD" and "Weight(Metric Ton)" at "Measure". Then click "Submit".

TAIWAN5.png

Step 8) Click on the "Export to Excel" button near the top-right corner of the page

TAIWAN6 (Custom).PNG

Step 9) Open the file just downloaded and copy the entire table presented

image.png

Step 10) The copied content must be pasted at the on cell 'A11' on the collection spreadsheet

Make sure you paste the correct data set in the right place

image.png

OBS: If you encountered any problems/erros in filling the spreadsheets or have any suggestions, please write them in the'Error Reporting' tab

You must have Author or Collection Owner permission to create Guru Cards. Contact your team's Guru admins to use this template.