「資料」美國2千億美元關稅清單Excel版來了,批量比對!

「資料」美國2千億美元關稅清單Excel版來了,批量比對!

此前美國對外公佈的2000億美元關稅清單為PDF版,小二君第一時間整理了word版,但是粉絲“航長”反映無法通過文檔批量比對,一個個查找很麻煩。

今天關務小二整理出Excel版,並加入批量比對函數,你只需將企業常用的出口美國商品編碼粘貼到表格中,即可對比是否出現在加徵清單內。

「資料」美國2千億美元關稅清單Excel版來了,批量比對!

批量查詢比對

「資料」美國2千億美元關稅清單Excel版來了,批量比對!

下面為部分商品編碼,因篇幅有限,完整版Excel表請在關務小二公眾號內回覆關鍵詞“美國千億表”。

序號商品編碼
商品描述
10203.29.20Frozen retail cuts of meat of swine, nesoi
20203.29.40Frozen meat of swine, other than retail cuts, nesoi
30206.10.00Edible offal of bovine animals, fresh or chilled
40208.10.00Meat and edible meat offal of rabbits or hares, fresh, chilled or frozen
50208.90.20Meat and edible offal of deer, fresh, chilled or frozen
60208.90.25Frog legs, fresh, chilled or frozen
70210.19.00Meat of swine other than hams, shoulders, bellies (streaky) and cuts thereof, salted, in brine, dried or smoked
80301.11.00Live ornamental freshwater fish
90301.19.00Live ornamental fish, other than freshwater
100301.91.00Live trout
110301.92.00Live eels
120301.93.02Live carp
130301.94.01Other live Fish, Atlantic & Pacific Bluefin Tunas
140301.95.00Other live Fish, Southern Bluefin Tunas
150301.99.03Live Tench (Tinca Tinca), sheatfish (Silurus Glanis), bighead carp (Aristichthys Nobilis) and other fish, nesoi
160302.11.00Trout, fresh or chilled, excluding fillets, other meat portions, livers and roes
170302.13.00Pacific salmon, fresh or chilled, excluding fillets, other meat portions, livers and roes
180302.14.00Atlantic and Danube salmon, fresh or chilled, excluding fillets, other meat portions, livers and roes
190302.19.00Salmonidae other than trout or Pacific, Atlantic & Danube salmon, fresh or chilled, excluding fillets, other meat portions, livers & roes
200302.21.00Halibut and Greenland turbot, fresh or chilled, excluding fillets, other meat portions,livers and roes
210302.22.00Plaice, fresh or chilled, excluding fillets, other meat portions, livers and roes
220302.23.00Sole, fresh or chilled, excluding fillets, other meat portions, livers and roes
230302.24.00Turbots
240302.29.01Flat fish, nesoi, fresh or chilled, excluding fillets, other meat portions, livers and roes
250302.31.00Albacore or longfinned tunas, fresh or chilled, excluding fillets, other meat portions, livers and roes
260302.32.00Yellowfin tunas, fresh or chilled, excluding fillets, other meat portions, livers and roes
270302.33.00Skipjack or stripe-bellied bonito, fresh or chilled, excluding fillets, other meat portions,livers and roes
280302.34.00Bigeye tunas (Thunnas obesus), fresh or chilled, excluding fillets, other meat portions,livers and roes
290302.35.01Atlantic & Pacific bluefin tunas, fresh or chilled, excluding fillets, other meat portions, livers and roes
300302.36.00Southern bluefin tunas (Thunnas maccoyii), fresh or chilled, excluding fillets, other meat portions, livers and roes
310302.39.02Tunas not elsewhere specified or included, fresh or chilled, excluding fillets, other meat portions, livers and roes
320302.41.00Herrings, fresh or chilled, excluding fillets, other meat portions, livers and roes


分享到:


相關文章: