How to Automate Tariff Rates Without Digging Through the HTSUS Every Time
Instantly look up any U.S. HTSUS tariff rate by HS code in Excel. The Tariff Auto-Fill Tool™ automatically returns duty rates, product descriptions, and Section 301, Section 232, and Section 122 tariff overlays so you can analyze landed cost, forecast tariff exposure, and update ERP exports in minutes instead of searching thousands of HTSUS tariff lines manually.
US Tariff Rate Lookup by HS Code: Section 301, 232 and New Forced Labor Tariffs (2026 Updates)
Stop manually searching the USITC PDF for a HTS / HS Code Lookup. The Tariff Auto-Fill Tool consolidates 3,327 verified tariff lines into one Excel engine with VLOOKUP automation, Section 301/232/122 overlays, and a 50-country trade program reference.
Built for procurement directors, supply chain teams, CFOs, and importers modeling tariff exposure.
Current US Tariff Status as of June 2026
Excel-Based HS Code Lookup and Tariff Rate Auto-Fill
Stop manually searching the USITC PDF to lookup HS Codes / HTS Codes.
This HTSUS 2026 Master Rate Workbook consolidates the entire Harmonized Tariff Schedule into a single, filterable Excel engine — with pre-built VLOOKUP automation, Section 301/232/122 overlays, and a 50-country trade program reference.
Enter your 8-digit HTS codes in the yellow input cells. Duty rates, descriptions, compliance flags, Forced Labor status, and frozen Section 122 history populate instantly. Copy-paste directly into your ERP, landed cost models, or financial forecasts.
Why Your Early-2026 Tariff Data is Now Dangerous
In 2026, a “Free” duty rate in the HTS schedule no longer means zero duty at the port. The tariff landscape shifted again in spring 2026: the Supreme Court invalidated IEEPA tariff authority in February, Section 122 replaced it within hours, the Court of International Trade then ruled Section 122 unlawful in May, and two presidential proclamations rebuilt Section 232 around full customs value. Then on July 24, 2026, Section 122 closed on schedule and new Section 301 Forced Labor tariffs took effect on 60 economies the same day.
Section 122 Closed. Its Successor Has No End Date
The 10% Section 122 surcharge ran its full 150-day statutory term and closed on schedule July 24, 2026. The same day, new Section 301 Forced Labor tariffs took effect on imports from 60 economies at 10-12.5% — and unlike Section 122, they carry no built-in expiration. The workbook tracks the live program and keeps the frozen Section 122 record for protests and drawback.
Section 232 Now Hits Full Customs Value
Proclamation 11021 (effective Apr 6, 2026) shifted derivative tariffs from metal-content value to FULL CUSTOMS VALUE, with tiered rates of 50% / 25% / 15%. Proclamation 11032 (June 8) added copper, ag/HVAC/mobile equipment, and lowered the U.S.-origin metal threshold from 95% to 85%.
The Stacking Effect
Do the new Forced Labor tariffs stack on the China Section 301 rates? Yes — unless the code is a Section 232 article, which is excluded entirely. Example: Steel from China = 0% general + 25% Sec 301 + 50% Sec 232 + 0% Forced Labor (232 exclusion) = 75% total landed cost impact.
Built for the Way Supply Chain Teams Actually Work
Instant Auto-Fill Engine
Enter your 8-digit HTS code and get the duty rate, description, special programs, and all overlay flags in one click. 200 lookup rows with pre-built VLOOKUP formulas.
3,327 Verified Rate Lines
Every 8-digit HTS code sourced directly from the USITC 2026 HTS Rev 4. Pre-formatted as text to prevent leading-zero corruption on Chapters 01-09.
Section 122 Overlay
Frozen Section 122 record: every HTS code keeps its final status — EXEMPT (241 codes), EXEMPT Aircraft Only (187 codes), or the 10% that applied until the program closed on schedule July 24, 2026. Retained for protests, drawback, and pre-closure entries.
Section 301 & 232 Overlays
Dedicated tabs for China tariffs (16 categories, 25%-100%) plus the live Forced Labor tariffs on 60 economies (10-12.5%, no scheduled sunset), and Steel/Aluminum/Copper/Auto tariffs with tiered 15%-50% rates on full customs value. Stacking logic included.
50-Country Quick Reference
FTA status, GSP eligibility, Section 301/232 exposure, reciprocal tariff rates, and trade risk levels for every major U.S. trading partner.
Entity-Verified & Formula-Open
All data mapped to official Federal Register and proclamation citations. No logins. No black boxes. You own the data. Formatted as text to prevent the “HTS 0101” to “101” error that breaks most Excel models.
HTSUS 2026 Master Rate Workbook — 10 Tabs
- Tab 1: Icon KeyStandardized status indicator reference for every emoji and icon used across the workbook. Three sections: Core Status, Trade Program & Overlay, Action & Workflow.
- Tab 2: Instructions & Update LogData sourcing documentation, version history (current through v5.4, July 24, 2026), revision tracking, and legal disclaimers. Read-only reference.
- Tab 3: Integration GuideStep-by-step column mapping to every Career Chronicles product. Shows exactly which fields feed into SKB-027, TIAS-199, SCS-849, TDM-1299, and more.
- Tab 4: Auto-Fill Lookup200 input rows with 2,000+ VLOOKUP formulas. Enter your HTS code in the yellow cell — duty rate, description, overlay flags, the new Forced Labor flag, and the frozen Section 122 status populate instantly.
- Tab 5: Country Quick Reference50 countries with FTA status, GSP eligibility, Section 301/232 exposure, reciprocal tariff rates, and trade risk indicators.
- Tab 6: Master Rate TableThe core database — 3,327 verified 8-digit HTS tariff lines with General Rate, Special Programs, Column 2, Section 301/232 flags, the new Forced Labor Subject flag, and frozen Section 122 status.
- Tab 7: Section 122 OverlayClosed-program record (7/24/26). Every HTS code keeps its final Section 122 status per the White House Proclamation Annexes, with the full CIT ruling history and close-out note. Retained for protests, drawback, and entries filed before July 24, 2026.
- Tab 8: Section 232 OverlaySteel, aluminum, copper, automobiles, timber, and derivative products with tiered rates on full customs value (Proc. 11021/11032): 50% primary, 25% derivatives, 15% transitional for qualifying equipment through Dec 2027. Products under 15% metal content exempt.
- Tab 9: Section 301 Overlay16 China-specific product categories with 2024-2026 tariff rates. EVs (100%), syringes (100%), solar cells (50%), semiconductors (50%), batteries (25%), and more — plus the live Section 301 Forced Labor tariffs on 60 economies (10-12.5%, effective July 24, 2026; no scheduled sunset).
- Tab 10: HELP-FAQTroubleshooting, data source citations, and risk-level definitions — answers the questions that come up most during setup and daily use.
Actual Screenshots from the HTSUS 2026 Master Rate Workbook
No mockups. These are real tabs from the Excel file you download — the same auto-fill engine, overlay tabs, and reference tables procurement teams use every day.
Auto-Fill Lookup
Enter an 8-digit HTS code in the yellow cell and watch rates, descriptions, and overlay flags populate instantly.
Master Rate Table
The core database of 3,327 verified HTS lines, sourced from USITC 2026 Rev 4 and formatted as text.
Country Quick Reference
50 trading partners with FTA status, GSP eligibility, overlay exposure, and trade risk levels.
Section 122 Overlay
Closed-program record: every code’s frozen status (EXEMPT, Aircraft Only, or 10%), with the full ruling history and the July 24, 2026 close-out.
Section 232 Overlay
Steel, aluminum, copper, and autos with tiered 15%-50% rates on full customs value (Proc. 11021/11032).
Section 301 Overlay
16 China product categories at 25%-100%, plus the live Forced Labor tariffs on 60 economies (effective 7/24/26).
Icon Key
The standardized status legend for every icon used across the workbook, so nothing is ambiguous.
The Executive Interactive Command Center™
Every purchase now includes a self-contained HTML dashboard. Upload your TAF-097_HTSUS_2026_Master_Rate_Workbook.xlsx file directly — no CSV export, no copy-paste — and it builds a live executive exposure summary, an auto-calculated recommendation, and a one-click Presentation Mode you can hand straight to a CFO or board.
Runs entirely in your browser. Nothing is uploaded to Career Chronicles or any third party — the file is read locally and never transmitted.
Everything you need to look up any HTS code and know your exact tariff exposure — in minutes.
Get Instant Access — $97 One-Time Instant download. No subscription. No API keys required.Why Tariff Rate Visibility Is a Financial Control Issue
Tariff lookup is not a compliance checkbox. It directly impacts how your organization forecasts, negotiates, and reports. Tariff visibility without financial modeling creates blind spots. Tariff stacking without structured overlays creates exposure.
- ◆ Landed cost accuracy
- ◆ Gross margin integrity
- ◆ Quarterly forecasting
- ◆ Executive and board reporting
- ◆ Supplier negotiation leverage
- ◆ Tariff recovery eligibility
Already know your rate? Model the impact with the 5-Minute Tariff Cost Calculator. Think you may have overpaid? Review the Tariff Refund Process & CBP Protest Timeline.
Who Uses the Tariff Auto-Fill Tool
This tool is built for operational execution — not legal advisory.
- ◆ Procurement Directors managing import exposure
- ◆ Supply Chain Leaders modeling sourcing alternatives
- ◆ Import Compliance Managers verifying HS classifications
- ◆ CFOs and Financial Planning and Analysis teams modeling margin impact
- ◆ Trade Consultants advising importer clients
- ◆ Business Owners importing directly into the US
Why Structured Tariff Lookup Matters in 2026
Organizations that perform well under trade disruption share four capabilities. This tool delivers all four.
8-Digit HS Exposure Clarity
Know your exact exposure down to the 8-digit HTS level — not chapter-level estimates.
Stacked Tariff Impact Modeling
Model all overlay programs simultaneously. General + Section 301 (China + Forced Labor) + Section 232, with frozen Section 122 history, in one view.
Structured Overlay Tracking
Maintain organized tracking across all three overlay programs with color-coded status indicators.
Recovery Pathway Identification
Identify refund opportunities before protest windows close. The data backbone that feeds the Tariff Refund Suite.
Real Results from Supply Chain Leaders
“I was drowning in tariff complexity — this toolkit gave me clarity in 15 minutes.”
“The calculator and checklist combo saved us hours each quarter. Immediate ROI.”
“We cut our tariff exposure by $1.2 million in one quarter. The Trump Tariff Solution.”
Tariff Auto-Fill Tool — TAF-097
HTSUS 2026 Master Rate Workbook (v5.4)
- ✓ 3,327 verified HTS rate lines (USITC 2026 Rev 4)
- ✓ Auto-Fill Lookup with 200 input rows & 2,000+ VLOOKUPs
- ✓ Section 301 China overlay (16 categories, 25%-100%) + live Forced Labor tariffs (60 economies, 10-12.5%)
- ✓ Section 232 overlay (tiered 15%-50% on full customs value, incl. copper)
- ✓ Section 122 historical overlay (closed 7/24/26 — frozen statuses + full ruling record)
- ✓ 50-country FTA & trade program quick reference
- ✓ Executive Interactive Command Center™ — direct .xlsx import, no CSV or paste
- ✓ Integration Guide for all Career Chronicles products
- ✓ Works in Excel, Google Sheets & LibreOffice
Immediate download. No subscription. No API keys required.
Frequently Asked Questions — 2026 Tariff Rates, HS Code Lookup & Refund Eligibility
Enter your 8-digit HS code in the Auto-Fill Lookup tab (Tab 4). The tool retrieves the duty rate, description, and all applicable overlay flags (Section 301, Section 232, Forced Labor, and the frozen Section 122 history) instantly using pre-built VLOOKUP formulas.
Yes. 16 China-specific product categories are mapped with current 2024-2026 rates ranging from 25% to 100%, including EVs, syringes, solar cells, semiconductors, batteries, PPE, gloves, tungsten, polysilicon, and ship-to-shore cranes. The overlay also carries the live Forced Labor tariffs: 10-12.5% on imports from 60 economies, effective July 24, 2026, tied to forced-labor import-ban failures. No scheduled sunset; Section 232 articles are excluded.
Yes, as a frozen historical record. Every HTS code keeps its final status — EXEMPT (241 codes), EXEMPT Aircraft Only (187 codes), or the 10% that applied until closure (2,899 codes) — per the White House Proclamation Annexes. The surcharge ran its full 150-day statutory term and closed on schedule July 24, 2026. The tab preserves the CIT ruling history (Oregon v. United States, May 7, 2026) and the close-out record you still need for protests, drawback, and entries filed before July 24.
Yes. Steel, aluminum, copper, automobiles, auto parts, timber, and derivative products with tiered rates — 50% primary, 25% derivatives, and 15% transitional for qualifying metal-intensive equipment through December 2027. As of April 6, 2026 (Proclamation 11021), derivative tariffs apply to full customs value rather than metal content only. Proclamation 11032 (June 8, 2026) added agricultural equipment, HVAC, and mobile industrial equipment at 15% and lowered the U.S.-origin metal threshold from 95% to 85%. Products under 15% metal content are exempt.
Yes. A single HTS code can carry a general duty rate plus Section 301 plus Section 232 at once, and the new Forced Labor tariffs stack too unless the code is a Section 232 article. Example: Steel structural tubing from China (HTS 7308.90.95) = 0% general + 25% Section 301 + 50% Section 232 + 0% Forced Labor (Section 232 articles are excluded) = 75% total landed cost impact.
Recovery pathways may be open if entries were filed under IEEPA authority before Section 122 replacement, duties were misclassified or overpaid, exclusions apply, or protest windows remain open (180 days from liquidation). Review the full process in the Tariff Refund Process & CBP Protest Timeline Guide.
Model the financial impact using the 5-Minute Tariff Cost Calculator or the Tariff Impact Automation Suite. Assess recovery options using the Tariff Refund Suite. The Integration Guide tab maps every column to every other product in the ecosystem.
The Integration Guide tab (Tab 3) maps every column to every other product in the ecosystem. TAF-097 is the data backbone for the entire Tariff Operating System value path, feeding the Tariff Playbook Suite (SKB-027), Tariff Impact Automation Suite (TIAS-199), Strategic Command Suite (SCS-849), and Tariff Defense Masterplan (TDM-1299).
Tariff Auto-Fill Powers Every Tool in the Ecosystem
The Tariff Auto-Fill Tool is the data backbone. Once you have clean tariff data, these tools turn it into action — response plans, exposure dashboards, refund recovery, and full enterprise strategy.
Tariff Playbook Suite™
Response Framework & Executive Briefing Kit
“I need a response plan.”
72-hour response guide, quick-action framework, 5-minute calculator, executive briefing deck. Replaces $5K–$10K in compliance assessments.
Tariff Refund Suite™
CBP Protest Filing & Tariff Recovery Tools
“I may have overpaid. I want my money back.”
CBP protest templates, Form 19 guides, broker email templates, and tariff recovery tracking. Replaces $15K–$35K in consulting.
Tariff Impact Automation Suite™
Exposure Dashboards & Supply Chain Cost Tracking
“I have clean data. I need to see my exposure.”
Dynamic dashboards, supplier risk alerts, automated scenario snapshots. 4 pre-built Excel tools with visual dashboards. Replaces $10K–$25K in consulting.
Tariff Scenario Strategy Kit™
Scenario Planner & Duty Cost Simulation
“I need a 3–5 year strategic plan.”
Decision frameworks, what-if models, sourcing evaluators, mitigation scoring. Replaces $20K–$50K in consulting.
Strategic Command Suite™
Tariff Code Governance & Cross-Functional Evaluation
“I need deeper analytics and cross-functional frameworks.”
Advanced sourcing workbooks, global scenario evaluators, multi-tier supplier analysis. Replaces $35K–$75K in consulting.
Tariff Defense Masterplan™
Full Tariff Operating System with ERP Integration
“I need ONE integrated system.”
19 interconnected tabs, 2,132 formulas, auto-KPI dashboard, ERP integration (SAP/Oracle/NetSuite/D365), implementation tracker. Replaces $50K–$150K Big 4 consulting.
Compare Tariff Tools by Stage — From Tariff Code Lookup to Enterprise Tariff Governance
Every product creates disproportionate strategic leverage. 35 workbooks | 202 tabs | 6,340+ formulas. TAF-097 is the data backbone that powers every tier above it.
| Tier | Product | Price | Consulting Equivalent | Value Multiplier | Format |
|---|---|---|---|---|---|
| 0 | US Tariff Rate Lookup TAF-FREE | Free | $500-$2K | — | Web Tool + CSV/Excel |
| 1 | Tariff Playbook Suite™ SKB-027 | $27 | $5K-$10K | 185x-370x | Dashboards, PPT, PDF, Word, Excel |
| OB | Fast Track Briefing Kit™ FTB-019 | Order Bump | $19 | $7.5K-$15K | 395x-789x | 2 Excel workbooks, 8-slide PPTX, 8 email templates, PDF & guides |
| 1b | Tariff Auto-Fill Tool™ TAF-097 ← You Are Here | $97 | $10K-$20K | 103x-206x | Excel (3,327 auto-fill rate lines, 10 tabs) |
| 2a | Tariff Refund Suite™ TRS-197 | Parallel Path | $197 | $15K-$35K | 76x-177x | PPT, PDF, Word, Excel |
| 2b | Tariff Impact Automation Suite™ TIAS-199 | Visibility | $199 | $10K-$25K | 50x-125x | Excel Dashboards |
| 3a | Tariff Scenario Strategy Kit™ TSSK-449 | $449 | $20K-$50K | 44x-111x | Excel, PPT, PDF, Word |
| 3b | Strategic Command Suite™ SCS-849 | $849 | $35K-$75K | 41x-88x | Excel, Word, PDF |
| 4 | Tariff Defense Masterplan™ TDM-1299 | Enterprise OS | $1,299 | $50K-$150K | 38x-115x | 19 tabs, 2,132 formulas, all formats |
| ENT | Enterprise Edition | $34,999+ | $155K+ | — | Full Toolkit + Implementation |
Tariff Strategy Guides — Deep-Dive Reference for Procurement Leaders
Long-form reference guides built on official CBP procedures, USTR rulings, and accurate tariff schedule data. Updated for the 2026 SCOTUS IEEPA ruling, the May 2026 CIT decision, and Proclamations 11021/11032. Each guide reinforces a different layer of tariff control: Exposure, Modeling, Recovery, and Executive Alignment.
Section 301 Tariffs Definitive Guide (2026 Executive Edition)
Legal framework, tariff lists, exclusion history, and structured financial exposure modeling.
Read the Full Guide →Tariff Refund Process Guide
Liquidation timelines, protest windows, standing requirements, and refund recovery mechanics under CBP procedure.
Read the Full Guide →Tariff Financial Impact & Forecasting Guide (2026)
Quantifying tariff-driven cost increases, modeling EBITDA sensitivity, and building executive-ready forecast scenarios.
Read the Full Guide →Tariff Risk Management Framework
Procurement-led framework to assess exposure, prioritize supplier actions, and align tariff mitigation across teams.
Read the Full Guide →How US Tariff Rates Are Structured (2026 Guide)
How rates layer across MFN schedules, Section 301, Section 232, and preferential trade programs.
Read the Full Guide →Best Tariff Impact Simulation Tools (2026 Guide)
Enterprise platforms, customs broker tools, and Excel-based intelligence systems for modeling duty exposure.
Read the Full Guide →Free weekly briefing
Know the tariff shift before it hits your bottom line.
Join procurement and supply chain leaders getting the Procurement and Tariff Intelligence Newsletter™ — concise, executive-ready briefings on tariffs, trade risk, and sourcing strategy from The Procurement Perspective™.
Free. Unsubscribe anytime. Delivered securely via Substack.Choose the support your team needs
Start with a free resource or select a complete toolkit. Every card opens the product checkout page.
90-Day Tariff Risk Calendar™ Free Track critical tariff deadlines, comment periods, refund windows, and team actions in a practical 90-day dashboard. Get Free Access → 
US Tariff Rate Lookup Free Look up current US tariff rates by HS code and country, with a free companion tariff-rate export. Get Free Access → 
Tariff Auto-Fill Tool™ $97 Auto-populate HS codes, duty rates, and landed-cost estimates across your product catalog, including Section 301 and 232 overlays. View Checkout → 
Tariff Playbook Suite™ $27 Plug-and-play calculators, checklists, and action plans, with 60+ live formulas and auto-calculating dashboards. View Checkout → 
Fast Track Executive Briefing Kit™ $19 Executive-ready templates, calculator, and slide deck to communicate tariff impact to leadership fast. View Checkout → 
Tariff Refund Suite™ $197 Templates, trackers, and step-by-step guides to file CBP protests and claim tariff refunds and duty drawback. View Checkout → 
Tariff Impact Automation Suite™ $199 Excel dashboards, supplier-risk alerts, and scenario planners for tariff cost tracking and sourcing decisions. View Checkout → 
Tariff Scenario Strategy Kit™ $449 Premium scenario modeling with scoring, automation, and an integrated duty-drawback calculator. View Checkout → 
Strategic Command Suite™ $849 Scenario planning, boardroom briefing, and supply-chain tools for advanced tariff strategy and communication. View Checkout → 
Tariff Defense Masterplan™ $1,299 Enterprise dashboards, strategy, automation, and executive deliverables for tariff risk, compliance, and crisis management. View Checkout →