Free reference data · 2 of 4

The 2024 ERG UN→Guide lookup, as an XLSX.

Name: 2024 ERG UN-to-Guide Lookup — XLSX
Creator: HaulGuard AI LLC
License: https://creativecommons.org/licenses/by/4.0/
Keywords: ERG, 2024 ERG, Emergency Response Guidebook, PHMSA, UN number, NA number, guide number, hazmat, first responder, DOT

The Emergency Response Guidebook 2024 yellow-pages index — 1,982 UN/NA numbers mapped to their assigned ERG guide, plus a guide-reference sheet for every guide populated in ERG2024. PHMSA, Transport Canada, Mexico SICT, and CIQUIME publish the guidebook; we publish the lookup.

A note for first responders: this is a reference-only XLSX for ops teams, dispatch, and compliance work. At an actual incident, use the official ERG2024 — printed booklet or PHMSA-published PDF — for protective-action distances, isolation zones, evacuation guidance, and the full orange-page guide contents.

What's in the file

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

Lookup entries1,982 UN/NA numbers
Dual-listings4 with multiple guides
Guide reference62 guides (full coverage)
Size~70 KB
Sheets4 (About + lookup + guides + license)
EditionERG 2024 (4-year cycle)

Sheet 2 — UN to Guide Lookup: ID Number → primary guide + guide title + initial isolation distance + alternates for dual-listings
Sheet 3 — Guide Reference: title, primary hazard (first FIRE OR EXPLOSION bullet), initial isolation distance, water-reactive flag for each of the 62 populated guides
"About this file" sheet with full PHMSA attribution, the verbatim ERG2024 page-380 reproduction notice, and SHA-256 of the upstream PDF
Dual-listings handled explicitly (UN1057 lighters, UN3166/3171 vehicles, UN3536 lithium batteries — different guides depending on configuration)
Print headers + workbook metadata — source attribution survives copy-paste and Excel export

Upstream source: 2024 Emergency Response Guidebook, official PHMSA-published PDF (phmsa.dot.gov)
Joint publishers: PHMSA (USA) · Transport Canada · Mexico SICT · CIQUIME (Argentina)
Snapshot: 2026-05-27
Verification: Every entry traced to the ERG2024 yellow pages (pages 28-87 of the English edition). Structural PDF parse, dedup on UN, conflict-detection for dual-listings.
PDF SHA-256: 180eb92e649d1ada7d2f39855da70d5742ff211d6863a8804ed2abb835c96e30

Get the file

Free. No payment. We capture your email so we can send a fresh copy when PHMSA publishes a new ERG edition or errata.

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 the lookup is refreshed (new ERG edition or PHMSA errata — usually every four years plus occasional mid-cycle).

CC BY 4.0

Licensed under Creative Commons Attribution 4.0 International. ERG2024 is jointly published by PHMSA, Transport Canada, Mexico SICT, and CIQUIME. Per the official ERG2024 publication notice (page 380), it "may be reproduced without further permission" — the names and seals of the participating governments are excluded from partial reproductions like this XLSX. The extraction methodology, formatting, and added metadata in this file are © 2026 HaulGuard AI LLC and released under CC BY 4.0. Use it freely — please credit "HaulGuard AI — 2024 ERG UN-to-Guide Lookup — haulguard.ai/erg-2024-lookup".

Need more than a lookup table?

HaulGuard scans the Bill of Lading, pulls the right ERG guide for every UN number on the load (deterministically — the AI doesn't get to vote when there's a published table), 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 lookup above is one input. The product is the engine.

See HaulGuard pricing