ReportAll Import Commodities: Customs Value by Customs Value For ALL Countries U.S. Imports For Consumption Annual Data NAIC Number1997 In 1,000 Dollars 334 COMPUTER AND ELECTRONIC PRODUCTS173,260,913 336 TRANSPORTATION EQUIPMENT149,260,345 333 MACHINERY, EXCEPT ELECTRICAL65,317,197 325 CHEMICALS51,602,943 211 OIL AND GAS50,030,240 315 APPAREL AND ACCESSORIES47,083,701 339 MISCELLANEOUS MANUFACTURED COMMODITIES42,906,066 331 PRIMARY METAL MANUFACTURING35,786,522 335 ELECTRICAL EQUIPMENT, APPLIANCES, AND COMPONENT26,984,506 980 GOODS RETURNED TO CANADA (EXPORTS ONLY); U.S. GOODS RETURNED AND REIMPORTED ITEMS (IMPORTS ONLY)21,982,709 324 PETROLEUM AND COAL PRODUCTS20,584,390 332 FABRICATED METAL PRODUCTS, NESOI20,530,468 316 LEATHER AND ALLIED PRODUCTS19,277,283 311 FOOD MANUFACTURING16,585,793 322 PAPER14,661,942 Subtotal :755,855,016 All Other:106,571,329 Total862,426,346 ~~~~~~~~~~ Sources: Data on this site have been compiled from tariff and trade data from the U.S. Department of Commerce, the U.S. Treasury, and the U.S. International Trade Commission. - Display percent distribution of values within year HOW TO PRINT WIDE REPORTS Choice 1) Print in "landscape". In the Netscape browser, this is done by going to "file", "print", "properties", and clicking on "landscape". Choice 2) Select a smaller font for your report. Choices are on the page just before the report. HOW TO SAVE YOUR REPORT TO A SPREADSHEET There are two methods: Method 1: To generate a text tab delimitated file to import into Lotus, Excel or Other Desktop tools press the "Download File" button. This will generate the file and allow you to download the file to your PC. (Caution all values and quantities will be in single units) Select a Delimiter: TabComma (,)Colon (:)Semicolon (;)Space ( ) Method 2: (Works best with the more current versions of the spreadsheet programs.) (Values will be as seen on screen) 1.) Save the file as a text file (Note--the saved file MUST have .txt at the end of the filename, such as fruit.txt) 2.) Go to Lotus 97 or Excel 4.0 3.)"Open" the saved .txt file. 4.) For Lotus: Under "parsing options", select "Automatically parse based on file layout", hit "OK" For Excel: Under "Original data type", select "fixed width", Hit "next. Move break lines so they are just to the right of each column of data, hit "enter" then finish". 5.) Sort results to remove blank rows if desired. User Name JAFFEE2 List Name All Import Commodities Country List ALL Countries Display Data Field CONS_CUSTOMS_VALUE Aggregation Level HTS3 Display Description YES Time-Line Annual Current Month 12 Current Year 2002 Current QTR 04 Scale In 1000