How Do I Look Up the Tariff Rate for My HS Code — Section 301, 232 & 122 Included?
3,327 verified HTSUS 2026 rate lines, one 8-digit lookup, every overlay stacked automatically — the Tariff Auto-Fill Upgrade™ (TAF-097), now with a free Executive Interactive Command Center™.
Get the Tariff Auto-Fill Upgrade™ — $97 One-time purchase. Instant digital download. No subscription.
Questions — Ask Me Anything (AMA)
You want to know the question I get the most? What is the Tariff Auto-Fill Upgrade™, and why is a $97 Excel file the thing procurement and compliance teams keep coming back to?
Well, here is a practical and non-salesy answer on the (10-tab workbook + Executive Interactive Command Center™) and what it does.
It is the single most repeated task in trade compliance — look up an HS code, find the rate, check if an overlay applies, do it again for the next code. This tool exists to stop that from being manual. So let me break it down:
The Real, True Value-Added Feature: one 8-digit code returns the general duty rate and all three overlay flags — Section 301, Section 232, Section 122 — at once, instead of four separate lookups.
What I See as the Practical Benefit: 3,327 verified rate lines, a 200-row auto-fill engine, and a 50-country FTA reference, all sourced from the official USITC 2026 HTS Rev 4.
Transformation: when someone asks “what’s our total exposure on this code?” you no longer cross-reference three government pages by hand — the answer is already sitting in one row.
So I know you don’t wake up wanting an “HTS lookup workbook.” You wake up thinking, “I have a shipment deadline and I don’t know what this is going to cost me.”
My goal, backed by my real-world sourcing and procurement experience, was to solve that exact problem. That’s exactly what the Tariff Auto-Fill Upgrade™ does.
The Master Rate Table — 3,327 lines with general rates, FTA programs, and all three overlay flags, annotated.
So If These Questions Are What You Are Asking
How do I find the tariff rate for my HS code? ⭐ Most Asked
Enter your 8-digit HS code into the Auto-Fill Lookup tab and the workbook returns the duty rate, description, chapter, and every applicable overlay flag (Section 301, 232, 122) instantly using pre-built VLOOKUP formulas.
What is the current Section 301 tariff rate for my product from China?
The Section 301 Overlay tab lists 16 action categories with rates from 25% to 100%, keyed to the same chapter number flagged in Auto-Fill Lookup Column H, so you go straight to the applicable rate instead of searching the USTR site.
Does Section 232 apply to my HS code?
Column I in Auto-Fill Lookup flags Y or N for Section 232 exposure, and the Section 232 Overlay tab shows the exact steel, aluminum, copper, or automotive rate for that chapter.
Is my product exempt from the new Section 122 tariff?
Column K returns EXEMPT, EXEMPT (Aircraft Only), or 10% APPLIES for every HTS code, reflecting the Section 122 temporary import duty in effect since February 24, 2026.
How do I calculate my total landed-cost tariff exposure, not just the general rate?
Add the General Duty Rate in Column C to whichever overlays flag Y for that code — Section 301, 232, and 122 all stack, and the workbook shows each layer separately, or combined instantly in the Executive Interactive Command Center™.
Where can I find a reliable, up-to-date HTS lookup spreadsheet?
The Master Rate Table contains 3,327 verified 8-digit tariff lines sourced directly from the official USITC 2026 HTS Rev 4 export, formatted as text so leading zeros never drop.
Can I check if my supplier’s country qualifies for a reduced tariff rate?
The Country Quick Reference tab covers 50 countries with FTA and GSP status, so you can check whether a Special Rate Program in Column D applies to your supplier’s country before assuming the general rate.
How do I know if a tariff rate I found online is still current?
Every rate ties back to the Instructions & Update Log tab’s version history and the official USITC source, and the workbook is versioned (currently v5.2, Post-SCOTUS Edition) so you know exactly which policy snapshot you’re looking at.
What happened to the old IEEPA tariffs — do they still apply?
No. The Supreme Court invalidated IEEPA-based tariffs on February 20, 2026. The Section 122 Overlay reflects the replacement action that took its place, current through the July 24, 2026 sunset.
Can I look up hundreds of HS codes at once instead of one at a time?
Yes. The Auto-Fill Lookup tab has 200 pre-formatted input rows, so you can paste a whole product list into Column A and get every rate back at once instead of looking up codes one by one.
The Tariff Auto-Fill Upgrade™ answers all of these from one lookup: rate, overlays, and country context, built from the official USITC schedule instead of a government PDF.
Best Primary Question for This Page
How do I stop manually searching the USITC PDF every time I need a tariff rate?
Now you might be asking what I mean by that, but that is what you, a real person with a shipment on a deadline, are actually asking. It also demonstrates how the Tariff Auto-Fill Upgrade™ is the answer with a complete lookup engine, not just a rate table.
The Tariff Auto-Fill Upgrade™ replaces the manual cross-referencing of USITC pages, three overlay bulletins, and a country FTA list with one 8-digit lookup. The free Executive Interactive Command Center™ then turns any batch of lookups into a live exposure summary you can hand to leadership.
The Section 301 Overlay tab — China rates 25%-100%, keyed to the same chapter Auto-Fill Lookup already flagged.
Other Questions Buyers Have Asked, In Their Own Words
These represent different reasons someone would need the workbook:
I have 200 SKUs and no idea which ones just got more expensive. Where do I even start?
Paste all 200 HS codes into the Auto-Fill Lookup tab at once — every row returns its rate and overlay flags instantly, so you see which SKUs changed without reviewing them one at a time.
My broker quoted me a rate that doesn’t match what I found on USITC’s site. Who’s right?
Cross-check both against the Master Rate Table, which pulls its 3,327 lines directly from the official USITC 2026 HTS Rev 4 export. If the numbers still don’t match, the discrepancy is worth raising with your broker directly.
I keep losing track of which codes are Section 301 versus Section 232. Is there a faster way?
Columns H and I in Auto-Fill Lookup flag each independently for every code, so you see both overlays side by side instead of checking two different government pages.
Can I trust a $97 Excel file over hiring a customs broker?
This isn’t a replacement for a licensed customs broker — it’s the lookup and stacking-logic layer that gets your team to an accurate working number before you loop in outside counsel or a broker for filing.
I’m not in trade compliance, I’m in finance. Can I actually use this without a customs background?
Yes. You paste an 8-digit code into a yellow cell and every field — rate, description, and all three overlay flags — fills in automatically. No formula-building or tariff-schedule knowledge required.
How do I explain to my boss why our landed costs went up this quarter?
Look up the affected HS codes in Auto-Fill Lookup to see exactly which overlay is driving the increase, then use the Executive Interactive Command Center™ to turn that into a one-page exposure summary.
Is this going to break when the next round of tariff changes gets announced?
The Instructions & Update Log tab tracks version history, and this workbook has already been updated multiple times this year — most recently to v5.2, Post-SCOTUS Edition — as Section 122, 301, and 232 details changed.
Do I need to buy a new tool every time the tariff schedule updates?
No. Ongoing updates are included at no additional cost as tariff rates, structures, and datasets evolve.
I already have the Tariff Playbook Suite (SKB-027). Do I need this too?
TAF-097 is the data layer SKB-027 was built to sit on top of. Paste verified rates from Auto-Fill Lookup into SKB-027’s Data Input tab and every response plan, dashboard, and executive metric in that workbook auto-populates.
Can I use this for sourcing decisions, not just compliance?
Yes. The Country Quick Reference tab’s FTA and GSP data lets you compare tariff exposure across supplier countries before you commit to a sourcing decision, not just after goods are already in transit.
What if I need to present this to my CFO, not just use it myself?
Upload your saved workbook into the free Executive Interactive Command Center™ and it generates a live exposure summary with a one-click Presentation Mode — no separate deck required.
Is my import data safe if I upload my workbook somewhere to see the dashboard?
Yes. The Command Center is a single static HTML file with no server and no login. Your browser reads the .xlsx file directly off your hard drive, and nothing is transmitted anywhere.
Whichever question brought you here, the Tariff Auto-Fill Upgrade™ answers it from one lookup: verified rates, overlay stacking, country context, and executive reporting, all sourced from the official USITC schedule.
The Tariff Auto-Fill Upgrade™ handles the first question — what’s my rate? Once you have it, the Executive Interactive Command Center™ turns any batch of lookups into a story you can walk into a meeting with.
The Executive Interactive Command Center™ — every code you imported, sorted by combined duty exposure, at a glance.
The Strongest FAQ Set of Questions the Tariff Auto-Fill Upgrade™ Solves
If any of these are on your list, here’s exactly how the workbook answers them.
How do I find the tariff rate for my HS code?
Enter it in Auto-Fill Lookup Column A — the duty rate, description, and every overlay flag return instantly.
Does Section 301, 232, or 122 apply to my product, and do they stack?
All three can apply to the same code at once, and they stack. Columns H, I, and K flag each independently, so every applicable layer shows up in one place.
Where does the rate data actually come from, and is it current?
The official USITC 2026 HTS Rev 4 export, currently at v5.2 (Post-SCOTUS Edition) with version history tracked on the Instructions & Update Log tab.
Can I look up many codes at once?
Yes — 200 pre-formatted rows in Auto-Fill Lookup, paste your whole product list and every rate returns at once.
Can I check country-level FTA eligibility for sourcing decisions?
Yes — the Country Quick Reference tab covers 50 countries with FTA and GSP status for exactly this comparison.
How do I turn a lookup into something I can hand to leadership?
Upload your workbook into the free Executive Interactive Command Center™ for a live exposure summary and a one-click, board-ready Presentation Mode.
One lookup answers all six: rate, overlays, data currency, batch processing, country context, and executive reporting, all from the Tariff Auto-Fill Upgrade™.
Ready to look up your own codes instead of searching a PDF?
Get the Tariff Auto-Fill Upgrade™ — $97
For “Now that I know my rate, what do I do about it?” — response planning and executive dashboards — that’s the Tariff Playbook Suite™ (SKB-027). Paste your verified rates from TAF-097’s Auto-Fill Lookup tab straight into its Data Input tab and every response plan auto-populates.