Free reference data · all four

All four hazmat references, one download.

Name: HaulGuard Free Hazmat Compliance References — bundle (4 XLSX)
Creator: HaulGuard AI LLC
License: https://creativecommons.org/licenses/by/4.0/
Keywords: hazmat, 49 CFR, hazardous materials table, ERG, segregation, 177.848, reportable quantity, Appendix A, CERCLA, DOT, PHMSA, free spreadsheets

The DOT Hazmat Table, the 2024 ERG UN→Guide lookup, the 49 CFR 177.848 segregation tables, and the 172.101 Appendix A reportable-quantities list — bundled into a single ZIP. One email, all four. PHMSA publishes the regulations; we publish the spreadsheets.

A note on use: these are reference data, not legal advice. The controlling text is always the regulation itself (eCFR / PHMSA-published source) — verify against the current edition before relying on any of them for a shipment. Each file carries its own source, currency date, and SHA-256 on its "About" sheet.

What's in the file

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

Files4 XLSX + README
FormatZIP (~450 KB)
LicenseCC BY 4.0 (all four)
ProvenancePer-file SHA-256
SourceseCFR + PHMSA, authoritative
RefreshWhen PHMSA amends

DOT Hazardous Materials Table — 49 CFR 172.101, all 3,003 entries, byte-verified against the eCFR
2024 ERG UN→Guide Lookup — 1,982 UN/NA numbers to ERG guides, with a Quick Lookup tab
Hazmat Segregation Tables — 49 CFR 177.848, the class-vs-class matrix + Class 1 compatibility table
Appendix A Hazardous Substances — 49 CFR 172.101 App. A, 1,350 substances + 765 radionuclides with RQs
README.txt with each file's source, currency date, and SHA-256 for independent verification

Sources: Official eCFR XML (49 CFR 172.101, 177.848) and the PHMSA-published 2024 ERG PDF — authoritative, not re-typed.
Verification: Each reference is parsed from its source and verified before publication (the HMT is byte-checked against the eCFR; the segregation matrix is cross-checked against HaulGuard's production engine; RQ values spot-checked against the reg).
Provenance: Every file's "About" sheet carries its source URL, currency date, and SHA-256. The README.txt repeats the per-file SHA-256 so you can verify each independently.
License: CC BY 4.0 on all four. Underlying U.S. federal regulations are public domain (17 U.S.C. § 105).

Get the file

Free. No payment. One email gets you all four. We use it to send a fresh copy when PHMSA amends any of these references.

First name

Last name

Optional — used in our follow-up emails so we can address you by name.

Email *

Company / Agency *

Role (optional)

Email me when any of these references is refreshed (when PHMSA amends the underlying regulation).

CC BY 4.0

Licensed under Creative Commons Attribution 4.0 International. All four references are free under CC BY 4.0. The underlying U.S. federal regulations (49 CFR, the PHMSA ERG) are public domain (17 U.S.C. § 105); the parsing, formatting, and structure of each spreadsheet are © 2026 HaulGuard AI LLC and released under CC BY 4.0. Use them freely — please credit "HaulGuard AI — haulguard.ai/free-resources".

Need this run for you, every load?

These four tables are reference inputs. HaulGuard is the engine that runs them: photograph the Bill of Lading and it pulls the right ERG guide, generates the placards under § 172.504, checks segregation under § 177.848, flags reportable-quantity substances, and produces a tamper-evident audit trail to present at inspection — deterministically, with every output cited to a CFR section.

See HaulGuard pricing