Tariff Auto-Fill Upgrade™ · TAF-097Look Up Any HS Code. Auto-Fill the Tariff Rate. Stay Compliant.
The HTSUS 2026 Master Rate Workbook turns the entire Harmonized Tariff 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.
Real Tabs. Labeled So You Know What Every Column Does.
Actual screenshots from the workbook, annotated with callout labels. No mockups -- this is the file you download.
Now With the Executive Interactive Command Center™
Live captures of the Command Center itself -- included free with every purchase -- importing your workbook and turning a lookup into a board-ready story.
Frequently Asked Questions
How do I find the tariff rate for my HS code?
Enter your 8-digit HS code in the Auto-Fill Lookup tab. The tool returns the duty rate, description, chapter, and every applicable overlay flag (Section 301, 232, 122) instantly using pre-built VLOOKUP formulas.
Can tariff rates stack on the same HS code?
Yes. A single code can carry a general 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 tubing from China (7308.90.95) = 0% + 25% + 50% + 0% (232 articles excluded from Forced Labor) = 75% total landed-cost impact.
Is this connected to CBP or USITC directly?
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 -- always verify at hts.usitc.gov before filing.
Do I need any other software to use this?
No. It opens in Excel, Google Sheets, or LibreOffice. Sheet protection guards the formulas against accidental edits while data entry, sorting, filtering, and inserting rows stay enabled -- and the unprotect password ships in the Start Here guide, so you can still modify the workbook structure for your own internal workflows.
How is this different from SKB-027 Tariff Playbook Suite?
TAF-097 ($97) is the data layer -- verified HTSUS 2026 rates with a 200-row auto-fill engine. SKB-027 ($27) is the response-planning layer -- a 17-tab workbook for dashboards, supplier tracking, and team checklists. Paste your verified rates from TAF-097's Auto-Fill Lookup tab into SKB-027's Data Input tab and every response plan, dashboard, and executive metric in SKB-027 auto-populates.
Is my data safe when I upload my workbook into the Command Center?
Yes. The Command Center is a single static HTML file: no server, no login, no account. When you upload your .xlsx, your browser reads it directly off your hard drive and holds it in memory for that tab only. Nothing is transmitted anywhere -- you can disconnect from the internet before uploading and it still works.
Want to see inside before you buy?
Take the full tab-by-tab visual tour, or review complete features and pricing on the main product page.
Free rate-lookup tools stop at the general duty rate. This one stacks every layer that actually determines your landed cost.
| Capability | Manual / Free Lookup Tools | Tariff Auto-Fill Upgrade™ |
|---|---|---|
| Data source | Varies -- often outdated | USITC 2026 HTS Rev 4, verified |
| Overlay stacking | Checked separately, by hand | Auto-calculated: 301 + 232 + 122 |
| Lookup speed | Minutes per code | Instant, 200 rows at once |
| Country/FTA context | Separate research required | Built-in 50-country reference |
| Executive reporting | Manual spreadsheet work | Command Center, one-click deck |
The Data Layer for Every Tariff Decision You Make
Most tariff lookup tools tell you the general duty rate and stop there. The Tariff Auto-Fill Upgrade™ stacks the general rate with Section 301, Section 232, and the new Forced Labor tariffs the moment you enter an 8-digit HS code -- and keeps the closed Section 122 program's frozen history for protests and drawback -- so the number in front of you is the actual landed-cost impact, not just one layer of it.
Instead of cross-referencing USITC pages, three overlay bulletins, and a country FTA list by hand, this workbook does it in one lookup. Paste your codes into the yellow cells and every field -- rate, description, chapter, and all three overlay flags -- fills in at once.
Before TAF-097
- Manually cross-referencing USITC pages per code
- Section 301/232/122 checked in separate places
- Easy to miss a stacking layer and undercount exposure
- No standardized way to check FTA eligibility by country
After TAF-097
- One 8-digit code returns every applicable rate at once
- All three overlays stack automatically and correctly
- 3,327 lines verified against the official USITC export
- 50-country FTA reference built in for sourcing decisions
HTSUS 2026 Master Rate Workbook -- 10 Tabs
Icon Key
Standardized status indicator legend for the whole workbook.
Instructions & Update Log
Data sourcing, version history, and the standard disclaimer.
Integration Guide
Column mapping to every other Career Chronicles product.
Auto-Fill Lookup
200 input rows, 2,000+ VLOOKUPs. Enter a code, get every field.
Country Quick Reference
50 countries with FTA, GSP, overlay exposure, and risk.
Master Rate Table
3,327 verified 8-digit HTS lines -- the core database.
Section 122 Overlay
Closed program (7/24/26): frozen status per code, kept for protests and drawback.
Section 232 Overlay
Steel, aluminum, copper, autos -- tiered 15%-50%.
Section 301 Overlay
16 China categories at 25%-100%, plus the live Forced Labor tariffs (60 economies, 10-12.5%).
HELP-FAQ
Troubleshooting, data sources, and risk-level definitions.
Included at no additional cost: Executive Interactive Command Center™
Upload your saved .xlsx file directly -- no CSV export, no copy-paste -- and get a live executive exposure summary: total lines reviewed, average combined duty rate, and a category-by-category breakdown. Click Presentation Mode for a board-ready deck built from the same numbers. Nothing you upload ever leaves your browser.
One Step in the Tariff Operating System™
You're not buying a standalone spreadsheet -- you're buying into a methodology. The Automation tier is where verified data replaces manual lookup, and everything downstream gets faster because of it.
You Already Have
- Response checklists & the SKB-027 playbook framework
- A general sense of which HS codes carry risk
- Manual access to USITC's published rate pages
Now You Gain
- 3,327 verified HTSUS 2026 rate lines, one lookup engine
- Section 301, 232 & 122 stacked and calculated automatically
- 50-country FTA reference for sourcing decisions
- Verified rates that flow straight into SKB-027's Data Input tab
Who Uses the Tariff Auto-Fill Upgrade
- ◆ Import & export coordinators
- ◆ Procurement & sourcing teams
- ◆ Customs compliance staff
- ◆ Supply chain analysts
- ◆ Small business owners who self-file
- ◆ Finance & landed-cost teams
Tariff Auto-Fill Upgrade™ -- TAF-097
HTSUS 2026 Master Rate Workbook (v5.4, Post-SCOTUS Edition)
- ✓ 3,327 verified HTS rate lines (USITC 2026 Rev 4)
- ✓ Auto-Fill Lookup with 200 input rows & 2,000+ VLOOKUPs
- ✓ Section 301, 232 & 122 overlays with stacking logic
- ✓ 50-country FTA & trade program quick reference
- ✓ Integration Guide for all Career Chronicles products
- ✓ Executive Interactive Command Center™ -- included free
- ✓ Full written User Guide + Start Here quick-start PDF
- ✓ Works in Excel, Google Sheets & LibreOffice
Immediate download. No subscription. No API keys required.
Important: This workbook supports internal tariff rate lookup and exposure modeling. It does not determine legal eligibility, guarantee outcomes, or replace review by a licensed customs broker, customs attorney, or qualified trade advisor. Always verify official HTSUS rates at hts.usitc.gov.
“This saved me hours of cross-checking HS codes. Worth every penny.”