Drug classification / DOCUMENTED CSV

NDC → ATC Crosswalk

Connect FDA drug package codes to therapeutic groups, with RxNorm identifiers and ATC levels 1–4 in one file.

ACD October 2026 release · source + processing changes

162,167unique relationships

11documented fields

63.2%of source package NDCs classified

632ATC-4 groups

01 / KNOW THE FIT

A useful join starts
with a clear meaning.

What you can do with it

Group an NDC-coded research or analytics table by therapeutic class, inspect RxNorm matches, or build consistent rollups across the ATC hierarchy.

What one row means

One classified FDA package NDC / ATC-4 code pair, with its RxCUI and parent ATC levels. This edition has one class per classified NDC; the pair remains the unique key.

Unique key
ndc_code + atc4_code

How to join it

Import ndc_code as text and match the original FDA hyphenated package format. Check your own code format and unmatched records before aggregating. The included lookup-status CSV accounts for every input NDC.

Coverage, with the edges visible

162,167 of 256,748 distinct FDA package codes receive a classification (63.2%), across 632 ATC-4 groups. Unclassified inputs remain visible in the lookup-status table, rather than disappearing from the denominator.

Keep in mind

NLM product classes reflect a most-common indication. This is not an exhaustive list of indications, ingredients, or historical mappings.
Includes ATC levels 1–4, not ATC-5 codes or defined daily doses. A missing current match does not prove no other mapping exists.
Prepared for research and analytics, not clinical decisions. FDA directory listing does not establish FDA approval.

WHAT MAKES IT ACTUALLY CLEAN

We resolve FDA package NDCs through NLM’s active Current Prescribable Content, then use direct ATCPROD membership of the resolved product. Ambiguous matches are excluded and recorded; source label case and NDC hyphens are preserved.

02 / TRY THE SHAPE

Real rows. Before you buy.

These are the first three rows from the delivered CSV, showing 4 of 11 fields. The free download contains the first five rows and all 11 fields; it is a format sample, not a coverage test.

NDC → ATC Crosswalk · first three rows
ndc_code	product_name	atc4_code	atc4_name
0002-0152-01	Zepbound	A10BX	Other blood glucose lowering drugs, excl. insulins
0002-0152-04	Zepbound	A10BX	Other blood glucose lowering drugs, excl. insulins
0002-0152-61	Zepbound	A10BX	Other blood glucose lowering drugs, excl. insulins

03 / NO GUESSING

Every field, explained.

The field dictionary from the current download. CSV has no built-in types; these are the intended import types.

All 11 fields in CSV order
Field	Type	Meaning
`ndc_code`	text	FDA package NDC in original hyphenated format
`product_name`	text	FDA brand name, falling back to generic name; label_case=source
`rxcui`	text	Unique active NLM RxNorm concept identifier
`atc4_code`	text	ATC level 4 code
`atc4_name`	text	ATC level 4 label; label_case=source
`atc3_code`	text	ATC level 3 code
`atc3_name`	text	ATC level 3 label; label_case=source
`atc2_code`	text	ATC level 2 code
`atc2_name`	text	ATC level 2 label; label_case=source
`atc1_code`	text	ATC level 1 code
`atc1_name`	text	ATC level 1 label; label_case=source

04 / INSIDE THE DOWNLOAD

Data, with its context.

One ZIP · 4.2 MB · 8 files. No account or subscription required.

ActuallyCleanData_NDC_to_ATC_Crosswalk.csvThe complete prepared dataset · UTF-8 CSV
README.mdImport guidance, method, attribution, and limitations
comparison.jsonComparison with the previous ACD release
data_dictionary.jsonTypes and definitions for every field
metadata.jsonSource provenance, production time, counts, and CSV checksum
ndc_lookup_status.csvLookup outcome for every input package NDC
provenance.jsonRetained source identifiers, URLs and file checksums
revision.jsonChanges and free-upgrade eligibility for this ACD revision

05 / DATES THAT MEAN SOMETHING

Sources, versions & changes.

Source versions identify the inputs. Our processing revision describes how we prepare them. Either kind of change creates a new ACD release; the package date records when it was built.

Current source versions

FDA directory date: 2026-10-09
RxNorm Current Prescribable Content: 05-Oct-2026
ATCPROD version: 1.2026.7
ACD edition: 2026-10-cpc-direct
Package prepared (UTC): Oct 13, 2026

Sources: FDA and NLM/NIH. ATC classification: WHO Collaborating Centre for Drug Statistics Methodology. Independent preparation; no endorsement.

RELEASE HISTORY

Oct 13, 2026 · current package (UTC)

Rebuilt from retained sources through versioned staging and processing. The delivered CSV is unchanged; the package adds source/processing identities and an explicit revision record. This revision is free to existing purchasers.

March 2026: previous ACD snapshot. Differences include both source revisions and a change in matching method; they are not counts of newly approved or discontinued drugs.

Read the mixed March–October comparison

Processing corrections and improvements for your purchased source edition are free. Genuinely new source editions may be sold separately. See the update policy and access instructions.

Check the downloaded CSV’s integrity

The metadata file inside the ZIP records this SHA-256 checksum for ActuallyCleanData_NDC_to_ATC_Crosswalk.csv. A matching checksum confirms identical CSV bytes.

4f86c01be818a89f526d88225ee041cdb59662f060f548fd48370c241bd03601

READY TO PUT IT TO WORK?