Bulk Upload Documentation

Learn how to use bulk upload to calculate tariffs for multiple products at once. Upload a CSV file with input product data and download a comprehensive tariff report.

Getting Started

The bulk upload feature enables you to calculate tariffs for multiple products simultaneously by uploading a CSV file. This feature is particularly useful when analyzing a large number of products for tariff calculations.

Quick Start

Download the CSV template from the bulk upload modal
Fill in your product data using the supported fields below
Upload your completed CSV file
Download the processed tariff report

Supported Fields

The following table describes all the fields you can include in your bulk upload CSV file:

Field	What is it?	Required or Optional	Comments
SKU	A unique identifier for the product	Optional	This field is not required for tariff calculations but helps uniquely identify a product in the product library/parts database
US HTS Code	10-digit HTS code valid for import into the US	Required	Versions with and without dot are accepted. For example, 6404.19.90.60 and 6404199060 are both equivalent. Tip: if you import products from a chapter that starts with 0 e.g. roasted coffee under 0901.21.00.20, use the version with dots. This avoids errors when software like Excel mistakes HTS codes for a numeric value and drops the leading zero. (So 0901210020 becomes 901210020 making it an invalid HTS code)
Value USD	The value of the product in USD	Optional	If provided, the total duty amount (Total Duty USD) will be calculated. If not provided, only duty percentages will be calculated.
Origin Country	The two letter ISO 3166 country code of the country of origin for the product	Required	Please consult this wikipedia page to look up the ISO country code. For example, China is CN, Germany is DE and so on.
Entry Date	Expected date for goods to be released	Optional	A future date can be used to check tariffs on that date. Past dates can also be used going back to January 1, 2025. Dates older than that will result in an error and the row will be skipped
KG, NO, DOZ etc.	The unit of measure associated with the HTS code	Conditional	Only required when the HTS code has a specific rate that depends on one or more unit of measures. Each unit of measure is represented as its own column with the unit code as the header (e.g., KG, NO, DOZ etc). The value in the column is the numeric quantity for that unit. For example, to calculate duty for 0901.90.20.00 (duty rate 1.5¢/kg), you will add a column called KG where you will report the weight.
Aluminum Percent	The % of the product's total customs value attributed to its aluminum content	Conditional	Required for products that are affected by section 232 aluminum tariffs, optional otherwise. Can be set to 0 if the product's HTS code appears in the list of articles affected by Section 232 aluminum tariffs but does not contain any aluminum. If the product is not affected by Section 232 aluminum tariffs, this field can be left blank
Smelt Cast Country	The most recent country of smelt and cast	Optional	Country of Smelt/Cast can affect duty calculations. If the product has aluminum content and this field is left blank, the Tariff Simulator will use the country of origin as the country of Smelt/Cast. Special codes UN (Unknown) is also supported.
Steel Percent	The % of the product's total customs value attributed to its steel content	Conditional	Required for products that are affected by section 232 steel tariffs, optional otherwise. Can be set to 0 if the product's HTS code appears in the list of articles affected by Section 232 steel tariffs but does not contain any steel. If the product is not affected by Section 232 steel tariffs, this field can be left blank
Melt Pour Country	The country where the steel used in the product was melted/poured	Optional	Country of Melt/Pour can affect duty calculations. If the product has steel content and this field is left blank, the Tariff Simulator will use the country of origin as the country of Melt/Pour. Special code OTH (Other) is also supported.
Copper Percent	The % of the product's total customs value attributed to its copper content	Conditional	Required for products that are affected by section 232 copper tariffs, optional otherwise. Can be set to 0 if the product's HTS code appears in the list of articles affected by Section 232 copper tariffs but does not contain any copper. If the product is not affected by Section 232 copper tariffs, this field can be left blank
SPI	Special Program Indicator code for special tariff treatment	Optional	A Special Program Indicator (SPI) is used to indicate a free trade agreement or similar program should be applied. Common SPIs include S (USMCA), P (DR-CAFTA), K (KORUS FTA), and AU (Australia FTA). If an SPI is applicable, it may reduce or eliminate duty rates. Only one SPI can be provided per row.

Best Practices

✓Do

• Use the provided CSV template
• Include dots in HTS codes starting with 0
• Do not use special characters in the headers like commas, quotes, slashes, etc.
• Use proper ISO country codes
• Validate your data before uploading
• Keep file size under 500KB
• Keep total rows under 500
• Make sure the uploaded file only has a single tab
• Ensure there are no more than 10 extra columns, beyond the supported fields
• Make sure the uploaded file does not contain any formulas

✗Don't

• Use invalid HTS codes
• Mix different date formats
• Leave required fields empty
• Use special characters like slashes in the headers
• Use country names instead of codes
• Upload files larger than 500KB
• Upload more than 500 rows
• Upload sheets with multiple tabs
• Use file with more than 20 columns
• Upload sheets with formulas

Troubleshooting

Common Issues

Invalid HTS Code: Ensure your HTS codes are 10 digits and valid for US imports. Use the HTS code lookup tool to verify valid codes.

Invalid Country Code: Use 2-letter ISO country codes (e.g., CN for China, DE for Germany). Special codes UN (United Nations) and OTH (Other) are also supported. Check the ISO country codes list.

Missing Required Fields: Ensure all required fields are completed. Refer to the table above for field requirements.

Date Format Issues: Use standard date formats (MM/DD/YYYY or YYYY-MM-DD).

Invalid Unit of Measure: Ensure you're using valid CBP unit codes as column headers. Common codes include kg, Doz, liters, Pcs, m, t, g. Each unit of measure should be its own column with the unit code as the header. See the CBP unit codes list. If you use an invalid unit code, it will be treated as a passthrough column instead.

Need Help?

If you're having trouble with bulk upload or need assistance with your tariff calculations, our trade compliance experts are here to help.

Talk to an Expert Try Tariff Simulator for Single Input