How to Calculate the Total U.S. Tariff Rate for any imported products or goods?
To find the total U.S. tariff for an imported product, you need the HS code plus every applicable duty layer, not just the base duty rate. The Tariff Auto-Fill Tool gives you an immediate way to calculate the complete tariff automation looks up and combines the applicable rates in seconds.
Look Up Any HS Code. Auto-Fill the Tariff Rate. Stay Compliant.
The Tariff Auto-Fill Tool turns the entire HTSUS 2026 schedule into one Excel engine — 3,327 verified rate lines with Section 301, 232, and 122 overlays that calculate your total applicable rate the moment you enter a code.
Get Instant Access — $97 One-Time One-time purchase. No subscription. Instant download.
Accurate. Compliant. Automated. Strategic.
Instant HS Code Lookup
Enter an 8-digit code and the duty rate, description, chapter, and every overlay flag fill in at once.
3,327 Verified Lines
Sourced from the official USITC 2026 HTS Rev 4 and formatted as text to prevent leading-zero errors.
Every Overlay, Stacked
Section 301, 232, and 122 calculated together so your total applicable rate is always correct.
You Own the Data
No logins, no black boxes, no API keys. Open formulas in Excel, Google Sheets, or LibreOffice.
Real Tabs. Labeled So You Know What Every Column Does.
These are actual screenshots from the workbook, annotated with callout labels. No mockups — this is the file you download.
HTSUS 2026 Master Rate Workbook — 10 Tabs
Tab 1: Icon Key
Standardized status indicator legend for the whole workbook.
Tab 2: Instructions and ; Update Log
Data sourcing, version history, and disclaimers.
Tab 3: Integration Guide
Column mapping to every other Career Chronicles product.
Tab 4: Auto-Fill Lookup
200 input rows, 2,000+ VLOOKUPs. Enter a code, get every field.
Tab 5: Country Quick Reference
50 countries with FTA, GSP, overlay exposure, and risk.
Tab 6: Master Rate Table
3,327 verified 8-digit HTS lines — the core database.
Tab 7: Section 122 Overlay
Closed program (7/24/26): frozen status per code — EXEMPT, Aircraft Only, or 10%.
Tab 8: Section 232 Overlay
Steel, aluminum, copper, autos — tiered 15%-50%.
Tab 9: Section 301 Overlay
16 China categories at 25%-100% plus the live Forced Labor tariffs.
Tab 10: HELP-FAQ
Troubleshooting, data sources, and risk-level definitions.
Turn a Lookup Into a Boardroom Story in Under a Minute
Every purchase now ships with the Executive Interactive Command Center — a self-contained dashboard that reads your workbook file directly. No exporting to CSV, no copy-paste. Drop in your .xlsx and it hands you an exposure summary a CFO can act on.
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 and ; 2,000+ VLOOKUPs
- ✓ Section 301, 232 and ; 122 overlays with stacking logic
- ✓ 50-country FTA and ; trade program quick reference
- ✓ Integration Guide for all Career Chronicles products
- ✓ Works in Excel, Google Sheets and ; LibreOffice
Immediate download. No subscription. No API keys required.
Frequently Asked Questions
Enter your 8-digit HS code in the Auto-Fill Lookup tab. The tool returns the duty rate, description, and all applicable overlay flags (Section 301, 232, 122) instantly using pre-built VLOOKUP formulas.
Yes. A single code can carry a general rate plus Section 301 plus 232 at once, and the new Forced Labor tariffs stack too unless the code is a Section 232 article. Example: steel tubing from China (7308.90.95) = 0% + 25% + 50% + 0% (232 articles excluded from Forced Labor) = 75% total landed cost impact.
No. It is structured from official USITC data (2026 HTS Rev 4) and formatted for business use in Excel. Every rate traces back to the official Harmonized Tariff Schedule.
Take the full tab-by-tab visual tour, or review complete features and pricing on the main product page.
HS Code Lookup | HTS Code Lookup | HTSUS Tariff Rate Search Tool™
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 →