Automate HS Tariff Code Lookup and Rate Auto-Fill in Excel — HTSUS 2026
Enter your HS code. Get your tariff rate instantly. One Excel workbook with 3,327 verified USITC rate lines, Section 301/232/122 overlays, and 50-country trade data.
Built for procurement directors, supply chain teams, CFOs, and importers modeling tariff exposure.
“The calculator and checklist combo saved us hours each quarter. Immediate ROI.”
Manual Tariff Lookups Are Costing You Time, Money, and Accuracy
Every time a tariff rate changes, someone on your team scrambles to update spreadsheets, cross-reference government databases, and hope they got the right HTS code. Multiply that by hundreds of SKUs and you have a compliance risk hiding in every row.
Scattered Government Sources
USITC HTS tables have 35,000+ rows with no filtering. Section 301 rates are buried in Federal Register notices. Section 232 rulings live on Commerce.gov. Section 122 actions are spread across proclamation annexes.
Tariff Stacking Blind Spots
A single HS code can carry a base MFN rate plus Section 301 plus Section 232 plus Section 122 — all at once. Miss one layer and your landed cost model is wrong before you even submit the PO.
Classification Errors Compound
One misclassified HS code can trigger CBP penalties, months of overpaid duties, or failed audits. Manual lookups make errors invisible until someone catches them downstream.
Enterprise Software Is Overkill
Global Trade Management platforms cost $10,000 to $50,000+ per year. AI classification tools charge per query. Most mid-market teams need accurate data in Excel — not another SaaS login.
The core challenge: You need accurate, structured tariff data you can trust — in a format that plugs directly into the spreadsheets and cost models your team already uses. Without spending enterprise software budgets to get it.
Automate HS Tariff Code Lookup in One Excel Workbook
Stop bouncing between 4,000-page government PDFs.
The Tariff Auto-Fill Tool consolidates the entire HTSUS 2026 Harmonized Tariff Schedule into a single, filterable Excel engine. Pre-built VLOOKUP automation pulls duty rates, descriptions, compliance flags, and Section 122 status the instant you enter your 8-digit HTS code.
Copy-paste results directly into your ERP, landed cost models, or financial forecasts. No scraping. No manual cross-checking. No fragmented data.
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 USITC 2026 HTS Rev 4. Pre-formatted as text to prevent leading-zero corruption on Chapters 01-09.
Section 122 Overlay
Post-SCOTUS Section 122 tracking: every HTS code flagged as EXEMPT (241 codes), EXEMPT Aircraft Only (187 codes), or 10% APPLIES (2,899 codes). Includes CIT ruling status and July 24, 2026 expiration tracking.
Section 301 & 232 Overlays
Dedicated tabs for China tariffs (16 categories, 25%-100%) and Steel/Aluminum/Auto tariffs with tiered rates (15%-50%) on full customs value. Includes proposed forced labor tariffs on 60 economies.
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.
Plug-and-Play Integration
Designed to feed directly into every Career Chronicles tool. Integration Guide tab maps column-by-column connections to dashboards, calculators, and strategy frameworks.
What the Tool Looks Like in Action
HTSUS 2026 Master Rate Workbook — 10 Tabs
- Icon Key: Tab 1Standardized status indicator reference for every icon used across the workbook. Three sections: Core Status, Trade Program & Overlay, Action & Workflow.
- Instructions and Update Log: Tab 2Data sourcing documentation, version history, revision tracking, and legal disclaimers. Read-only reference.
- Integration Guide: Tab 3Step-by-step column mapping to every Career Chronicles product. Shows exactly which fields feed into dashboards, calculators, and strategy frameworks.
- Auto-Fill Lookup: Tab 4200 input rows with 2,000+ VLOOKUP formulas. Enter your HTS code in the yellow cell — duty rate, description, overlays, and Section 122 status populate instantly.
- Country Quick Reference: Tab 550 countries with FTA status, GSP eligibility, Section 301/232 exposure, reciprocal tariff rates, and trade risk indicators.
- Master Rate Table: Tab 6The core database — 3,327 verified 8-digit HTS tariff lines with General Rate, Special Programs, Column 2, Section 301/232 flags, and Section 122 status.
- Section 122 Overlay: Tab 7Post-SCOTUS emergency tariff tracking. Every HTS code classified as EXEMPT, EXEMPT (Aircraft Only), or 10% APPLIES per White House Proclamation Annexes. Includes CIT ruling status (ruled unlawful May 7, 2026 — government appealed) and July 24, 2026 expiration date.
- Section 232 Overlay: Tab 8Steel, aluminum, automobiles, copper, 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. UK exception at reduced tiers.
- Section 301 Overlay: Tab 916 China-specific product categories with 2024-2026 tariff rates (EVs 100%, syringes 100%, solar cells 50%, semiconductors 50%, batteries 25%), plus proposed forced labor tariffs (10-12.5%) on 60 economies.
- HELP-FAQ: Tab 10In-workbook help reference with answers to common questions about data sources, formula usage, overlay interpretation, and integration with other Career Chronicles products.
Everything you need to automate HS tariff code lookup and know your exact tariff exposure — in one Excel workbook.
Get Instant Access — $97 One-Time Instant download. No subscription. No API keys required.Why Teams Choose the Tariff Auto-Fill Tool
| Tool Type | Price | Best For | Limitation |
|---|---|---|---|
| Government portals (USITC, Trade.gov) | Free | One-off manual searches | 35,000+ unfiltered rows. No overlay tracking. No automation. |
| Free online HS code finders | Free | Quick single-code lookups | No bulk processing. No 301/232/122 overlays. No Excel export. |
| Tariff Auto-Fill Tool (TAF-097) | $97 one-time | Teams needing structured Excel automation for 3,327+ rate lines | Structured reference tool — not live API or customs filing software. |
| AI tariff classification tools | $500-$2,000+/year | High-volume automated classification | Per-query pricing. Requires integration. Overkill for rate lookup. |
| Enterprise GTM platforms (SAP GTS, E2open) | $10,000-$50,000+/year | Fortune 500 global supply chains | 6-12 month implementation. IT-dependent. Massive overhead. |
One-time purchase. No subscription. No API keys. No IT integration. It is an Excel file that works today.
Who Uses the Tariff Auto-Fill Tool
- ◆ Procurement Directors managing multi-country import exposure
- ◆ Supply Chain Leaders modeling sourcing alternatives and landed cost
- ◆ Import Compliance Managers verifying HS classifications for audits
- ◆ CFOs and FP&A Teams who need tariff cost inputs for financial models
- ◆ Trade Consultants advising importer clients on duty exposure
- ◆ Business Owners importing directly into the US without enterprise software
This tool is built for operational execution — the step between “what is my rate?” and “what do I do about it?” It is not a legal advisory platform. It is not a customs filing tool.
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.”
Honest Answers Before You Buy
“I can look up tariff rates for free on USITC.”
You can — one code at a time, across 35,000+ unfiltered rows, with no Section 301/232/122 overlay visibility and no bulk processing. This tool gives you 3,327 verified rate lines with nine auto-populated data points per code, ready to paste into your cost models. The time saved on the first batch lookup pays for the tool.
“$97 for a spreadsheet?”
A customs broker charges $150-$300 per hour. Enterprise GTM software starts at $10,000/year. This workbook replaces the data-gathering phase of both — for a one-time cost less than a single consulting hour. The consulting equivalent of this tool runs $5,000 to $15,000.
“What if tariff rates change after I buy?”
The workbook reflects USITC 2026 HTS Rev 4 data as of June 2026. Overlay tabs are structured so you can manually update rates as new USTR or Commerce Department actions take effect. Updated versions are available when USITC publishes new revisions.
“We already have internal spreadsheets for this.”
Most internal spreadsheets are missing Section 122 overlay data, have no stacking logic, and drift out of sync within weeks of a tariff change. This tool starts from the official USITC source and adds the overlay structure your internal sheets are missing.
Everything You Need to Know
How does the auto-fill work?
Enter your 8-digit HTS code into the Auto-Fill Lookup tab (column A). The workbook returns the general duty rate, description, special rate programs, Section 301/232 flags, and Section 122 status instantly via VLOOKUP formulas. 200 input rows are available.
Where does the data come from?
The U.S. International Trade Commission (USITC) official HTS export at hts.usitc.gov. The same source customs brokers and trade compliance professionals use for classification and duty determination. HTSUS 2026 Revision 4.
Does this include Section 301, 232, and 122 tariffs?
Yes. Dedicated overlay tabs cover Section 301 (16 China categories, 25%-100%, plus proposed forced labor tariffs on 60 economies), Section 232 (steel/aluminum/auto/copper/timber with tiered rates of 15%-50% on full customs value per Proc. 11021/11032), and Section 122 (post-SCOTUS 10% surcharge with exempt/applies classification for every HTS code, CIT ruling status, and July 24, 2026 expiration).
How many HTS codes are included?
3,327 eight-digit rate lines across Chapters 01 through 97, excluding special provisions in Chapters 98-99. These are the actual tariff lines with assigned duty rates from the USITC 2026 HTS Rev 4.
Can I use this in Google Sheets?
Yes. The workbook opens in Google Sheets, LibreOffice Calc, and any application that supports .xlsx files. VLOOKUP formulas function across all platforms.
Is this a live API connection?
No. This is a structured reference tool in Excel format, not a live API. It uses official USITC data formatted for business use. Always verify final classification with a licensed customs broker before filing.
How is this different from the free Tariff Rate Export Tracker?
The free version covers 169 category-level records. This upgrade provides 3,327 official 8-digit USITC rate lines, 2,000+ auto-fill VLOOKUP formulas, Section 301/232/122 overlay tabs, and full product integration with the Career Chronicles ecosystem.
What should I do after finding my tariff rate?
Model the financial impact using the Career Chronicles ecosystem. Calculate adjusted COGS, assess margin erosion, and determine if tariff recovery applies to your entries. The Integration Guide tab maps exactly which fields feed into every other tool.
Tariff Auto-Fill Tool — TAF-097
HTSUS 2026 Master Rate Workbook (v5.0)
- ✓ 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%) + forced labor proposal
- ✓ Section 232 overlay (tiered 15%-50% on full customs value per Proc. 11021/11032)
- ✓ Section 122 post-SCOTUS overlay (10% surcharge — CIT ruling + Jul 24 expiration)
- ✓ 50-country FTA & trade program quick reference
- ✓ Integration Guide for all Career Chronicles products
- ✓ Works in Excel, Google Sheets & LibreOffice
Immediate download. No subscription. No API keys required.
TAF-097 Powers the Entire Ecosystem
| Step | Tool | What It Does |
|---|---|---|
| Lookup | Tariff Auto-Fill Tool ($97) | Find your exact rate — you are here |
| Respond | Tariff Playbook Suite ($27) | 72-hour response plan and executive briefing |
| Automate | Tariff Impact Automation Suite ($199) | Dashboards, risk alerts, and scenario snapshots |
| Strategize | Tariff Scenario Strategy Kit ($449) | 3-5 year strategic planning frameworks |
| Recover | Tariff Refund Suite ($197) | CBP protest filing and duty recovery tools |
| Defend | Tariff Defense Masterplan ($1,299) | Enterprise-grade tariff operating system |
Tariff Auto-Fill Tool™
Tariff Playbook Suite™
Fast Track Executive Briefing Kit™
Tariff Refund Suite™
Tariff Defense Masterplan™
Tariff Impact Automation Suite™
Tariff Scenario Strategy Kit™
Strategic Command Suite™
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.