Free reference data

The DOT Hazmat Table, as an XLSX.

The 49 CFR § 172.101 Hazardous Materials Table — 3,004 entries / 2,334 unique UN/NA numbers, all 14 columns, byte-verified against the eCFR HTML. PHMSA publishes the regulation; we publish the spreadsheet.

Just need one UN number? Type it into the free Quick Lookup — placard, hazard class, packing group, and ERG guide, instantly, in your browser. No download, no email.
Try the UN lookup →

What's in the file

Microsoft Excel (.xlsx). Plain data, no formulas, no macros.

  • Entries3,004 with UN/NA/ID
  • Distinct IDs2,334 UN/NA/ID numbers
  • Cross-refs682 "see X" navigation rows
  • ColumnsAll 14 from § 172.101
  • Size~322 KB
  • Sheets5 (About + data + 3 references)
  • All 14 columns: Symbols, PSN, Hazard Class, ID Number, PG, Label Codes, Special Provisions, Packaging (8A/8B/8C), Qty Limits (9A/9B), Vessel Stowage (10A/10B)
  • "About this file" sheet with full attribution, methodology, and the SHA-256 of every source it was verified against
  • Symbol legend and column reference sheets included
  • Brand banner + print headers — survives copy-paste so the source is always traceable
  • Continuation rows for multi-PG materials correctly recovered (UN1133 Adhesives gets PG I/II/III, etc.)
Source
Electronic Code of Federal Regulations (eCFR Part 172 Subpart B)
Snapshot
2026-09-09 (eCFR currency date; includes HM-268Q, effective 2026-09-08)
Verification
Compared field-by-field against the eCFR HTML across all 14 columns on 2026-05-15: zero field mismatches. Compared again, all 14 columns, against the eCFR table current to 2026-09-09: the only content changes were the special-provision cells of UN0101, UN0335 and UN0431 (HM-268Q), and this file carries the new values. The special-provisions sheet carries HM-268Q's new text of special provision 200. One deliberate difference: the CFR prints a multi-packing-group entry once and leaves the rows beneath it blank, and this file fills those rows in so each one stands alone.
File SHA-256
dde19f4e7554b7a1c09f6e3dbc4be7de598c48dd1173f456529c5f93c81b4750 — hash the file you downloaded and compare it to this.
Verified snapshot SHA-256
9a7f0583f0184744021d661965453a5f2cfd89ff5a77cad43cc4cbea24d23887 — the 2026-05-15 eCFR snapshot this compilation was first verified against.
eCFR update SHA-256
10d434682842084c906af1a201c050f61a87ef5683ce9fe80f9c9f75996d45b0 — the 2026-09-09 eCFR copy of § 172.101 the three amended cells were read from. Both hashes are on the file's "About this file" sheet alongside the canonical-dataset hash.

Get the file

Free. No payment. We capture your email so we can send you each updated copy when we publish it. The file is a dated snapshot, so check its as-of date before you rely on it.

Optional — used in our follow-up emails so we can address you by name.
CC BY 4.0
Licensed under Creative Commons Attribution 4.0 International. The underlying 49 CFR text is a US federal-government work and is in the public domain. The cleaning, verification, formatting, and metadata in this file are © 2026 HaulGuard AI LLC and released under CC BY 4.0. Use it freely — please credit "HaulGuard AI — 49 CFR § 172.101 HMT compilation — haulguard.ai/hazmat-table".

Need more than a lookup table?

HaulGuard scans the Bill of Lading, generates the placards under § 172.504, checks segregation under § 177.848, and produces a tamper-evident audit trail your driver can present at inspection. The table above is one input. The product is the engine.

Scan your paper — first scan free

Shippers & brokers: custom program pricing