Normalize pharmacy claims NDCs with RxNorm

Convert claim-line NDC values into consistent ingredients and clinical drugs for utilization, adherence, formulary, and real-world evidence analysis.

Upload your NDC file Download sample CSV

The data problem

NDCs describe products, not comparable drugs

Pharmacy claims capture the dispensed product NDC. A patient can refill an equivalent medication under a different manufacturer or package code, fragmenting drug episodes and complicating cohort definitions.

The analyzable result

One standardized RxNorm layer

Attach normalized RxNorm fields to each unique NDC, then use ingredient or Semantic Clinical Drug to connect equivalent fills across time while retaining claim-level dates, quantities, and original product codes.

Three steps

From source file to analysis-ready data

Deduplicate NDCs

Export the unique NDC values from your claims extract rather than uploading repeated claim lines.

Map once in bulk

RxMap enriches the unique list with standardized RxNorm concepts and structured drug attributes.

Join to claim lines

Merge the crosswalk back to the full claims table and build drug episodes or analytical cohorts.

Verified example

Standard fields for every claim-line product

Download enriched Excel

ndc_code	IN_ingredient	SCD_semantic_clinical_drug	Strength
00093-1048-01	Metformin	Metformin hydrochloride 500 MG Oral Tablet	500 MG
00071-0155-23	Atorvastatin	Atorvastatin 10 MG Oral Tablet	10 MG
00054-8174-25	Dexamethasone	Dexamethasone 1 MG Oral Tablet	1 MG

Example mappings were checked against the public NIH NLM RxNorm API. Historical or nonstandard NDCs may not map and should remain visible for review.

What this unlocks

Connect equivalent fills when manufacturers or package sizes change.
Define ingredient-level cohorts without maintaining manual NDC lists.
Stratify utilization by clinical drug, strength, or dose form.
Review unmatched codes separately instead of silently dropping claims.

Make your NDC file analysis-ready

Preview your mapped rows before payment. $0.001 per NDC, with a $1 minimum and $25 maximum per upload.

Start converting