How do I find the total U.S. tariff rate for my HS code, including Section 301, Section 232, and other additional tariffs?
Enter your 8-digit HTS code and instantly see your base duty rate, applicable Section 301, Section 232, and Section 122 overlays, plus product descriptions and trade program data (without manually searching the HTSUS.)
Inside the Tariff Auto-Fill Tool: A Guided Tour of Every Tab
See exactly what you are buying. This is a labeled walkthrough of the HTSUS 2026 Master Rate Workbook — the Auto-Fill engine, the 3,327-line Master Rate Table, and the Section 301, 232, and 122 overlays — with callouts explaining what every column does.
Get Instant Access — $97 One-Time One-time purchase. No subscription. Instant download.One Workbook. Ten Tabs. Every Tariff Layer.
The Tariff Auto-Fill Tool brings the full Harmonized Tariff Schedule, three overlay programs, and a 50-country reference into a single connected Excel file. Here is the whole workbook in one view.
What Each Tab Does
Follow the gold callout labels on each screenshot. They point to the exact columns and inputs you will use to look up a rate, check an overlay, and model your total landed cost.
Auto-Fill Lookup
This is where the work happens. Type an 8-digit HTS code into the yellow input cell and every field fills in at once — no manual searching through the USITC PDF.
- Enter the HTS code — one yellow input cell drives the whole row
- Base duty + total applicable rate calculate instantly
- Section 301 / 232 / 122 flags show every overlay that applies
- Built on 2,000+ VLOOKUP formulas across 200 input rows
Master Rate Table
The core of the workbook: 3,327 verified 8-digit HTS lines sourced from the USITC 2026 HTS Rev 4, each one ready for lookup.
- Formatted as text to prevent the leading-zero import error on Chapters 01-09
- General duty rates and special FTA programs side by side
- Section 301 and 232 flags built into every row
- Section 122 overlay column — 10% or exempt, at a glance
Section 301 Overlay
Every China Section 301 action mapped with its current rate, effective date, and Federal Register citation — plus the newest 2026 development.
- 16 China product categories at additional rates from 25% to 100%
- Status for each line — active or proposed
- Notes track product lines and full rate history
- June 2026 update: proposed forced-labor tariff on 60 economies (10-12.5%)
Section 232 Overlay
Steel, aluminum, copper, automobiles, and timber tariffs with the tiered rates and country scope you need for accurate landed cost.
- Covered products — steel, aluminum, copper, autos, timber and derivatives
- Tariff rates 25%-50% with country scope and UK carve-outs
- June 2026 update: derivative tariffs now apply to full customs value (Proc. 11021)
- Products under 15% metal content are flagged exempt
Section 122 Overlay
The temporary surcharge that replaced IEEPA tariffs after the February 2026 Supreme Court ruling — tracked code by code, with its legal status.
- Universal 10% baseline surcharge classified per HTS code
- Expires July 24, 2026 — 150-day statutory limit
- Key exemptions: Section 232, USMCA, CAFTA-DR textiles, aircraft
- Stacks with Section 301 (not 232); includes CIT ruling status
Country Quick Reference
Trade status for 50 major trading partners in one screen — the fastest way to compare sourcing alternatives.
- FTA status and code for each country
- GSP eligibility at a glance
- Whether each country is subject to Section 301, 232, or 122
- Reciprocal tariff rates and trade risk indicators
Icon Key
A standardized legend so every status icon in the workbook means the same thing on every tab. Purely visual — it never affects a formula.
- Status symbols — yes / no / pending
- Trade program icons — 301 / 232 / 122 / FTA
- Compliance workflow icons
- Plus Tabs 2 & 3: Instructions & Update Log and the Integration Guide
The Executive Interactive Command Center
Past the last tab, one more file is waiting: a self-contained HTML dashboard. Open it in any browser, upload your workbook, and it takes over from there.
- Direct .xlsx import — browse or drag your file in, no CSV export or copy-paste
- Runs entirely in your browser — nothing is uploaded anywhere
- Toggle between a working Dashboard and a board-ready Presentation view
From Rows to a Ready-Made Exposure Summary
Once your data is in, the dashboard reads it automatically — no formulas to build, no chart to format.
- Auto-calculated executive recommendation banner
- Sortable HTS Portfolio table — click any column header to re-sort your full import
- Built-in Action Tracker for follow-up items your team can check off
Tariffs Stack — and the Tool Shows the Total
A single HTS code can carry a general duty rate plus Section 301 plus Section 232 plus Section 122 — all at once. Example: steel structural tubing from China (HTS 7308.90.95).
Miss one overlay and your landed cost model is wrong by tens of points. The Tariff Auto-Fill Tool surfaces every layer for every code.
Ready to Look Up Any HTS Code in Seconds?
Get the full HTSUS 2026 Master Rate Workbook — all 10 tabs, 3,327 verified rate lines, and every overlay shown above.
Get Instant Access — $97 One-Time Instant download. No subscription. Works in Excel, Google Sheets & LibreOffice.See full features and pricing on the product page →