RxNorm Frequently Asked Questions
RxNorm can be used overseas but the content is U.S.-centric. RxNorm contains few, if any, non-U.S. drugs.
You must accept the terms of the Unified Medical Language System (UMLS) Metathesaurus license agreement, and create a UMLS Terminology Services (UTS) account to download the full RxNorm files. The National Library of Medicine (NLM) produces RxNorm and does not charge for licensing; however, the use of proprietary data in the RxNorm files may require additional licensing from those source vocabulary providers. See Appendix 1 and Section 12 of the UMLS license to learn more about a specific source vocabulary.
NLM does not provide RxNorm files in Excel format. However, RxNorm files are text files which can be imported or converted manually into a spreadsheet. For detailed instructions, see this brief video titled: Opening an RxNorm File in a Spreadsheet.
RxNorm files are in Rich Release Format with the extension .RRF, which are text files with values separated by the pipe character (|). After unzipping the RxNorm ZIP file, a text editor, such as Notepad or Notepad++ can be used to open and view the RxNorm data.
The RxNorm data files are meant to be loaded into a relational database management system (RDBMS). We recommend SQL, as our scripts and controls are designed for loading RxNorm files into an Oracle database or a MySQL database. NLM offers limited support in using SAS for RxNorm.
User-submitted scripts for the UMLS that can be modified for use with RxNorm are available here:
The RxNorm files can be downloaded as a ZIP file from the RxNorm files page.
To automate the download of the RxNorm releases, we provide scripts for Windows and Mac/Linux/Solaris computers that, when combined with a scheduling tool, will allow you to automate your downloads. You can download the scripts, along with a README file with instructions, here: https://download.nlm.nih.gov/rxnorm/terminology_download_script.zip
The full RxNorm data set is released on the first Monday of each month. During months when the first Monday is a U.S. Federal holiday, RxNorm is released on the first Tuesday.
No. However, RxNorm content is updated on a regular and predictable schedule through various resources.
- RxNorm Monthly Release – Available the first Monday of every month or the first Tuesday if Monday is a U.S. Federal holiday.
- RxNorm Weekly Release – Available every Wednesday (except the Wednesdays before the May and November RxNorm monthly releases).
- RxNav – Typically updated the first Monday or Tuesday of every month, as it is updated with the RxNorm monthly release.
- DailyMed – Typically updated every Thursday, as it is updated with the RxNorm weekly releases. DailyMed download data are also available as daily, weekly or monthly periodic updates.
An unZIP utility such as WinZIP can be used to open the ZIP files once downloaded. The RRF files are pipe-delimited text files (with a file extension of .RRF instead of .txt) which can be opened with a text editor such as Notepad.
Some of the files are large and cannot be opened with simple text editors. More robust text editors, such as Notepad++ for Windows and TextWrangler for Mac, work well. However, the RxNorm data are explored more effectively when loaded into a database or manipulated with command line tools, like grep or awk.
Several resources provide new RXCUI information.
- RxNorm Monthly Releases – The RXNCONSO.RRF file in the monthly releases contain new and existing RxNorm drug names and codes and is available for download the first Monday of every month or the first Tuesday if Monday is a U.S. Federal holiday.
- RxNorm Weekly Releases – The RXNCONSO.RRF file in the weekly releases contain select new data and is available for download every Wednesday (except the Wednesday before the May and November RxNorm monthly releases).
- RxNav – Perform a search on the first Monday or Tuesday of the month, as it is updated with the RxNorm monthly release.
- DailyMed – Perform a search on Thursdays, as DailyMed is typically updated with the Wednesday RxNorm weekly releases. To find the RXCUI in DailyMed (if available):
- Go to the desired DailyMed drug label page.
- Click on “RxNorm” under the “MORE INFO FOR THIS DRUG” section near the bottom of the left panel or the bottom of the page.
- A pop-up window will appear with relevant RxNorm information.
You can also email email@example.com requesting information.
There are several reasons why you might not be able to find an RXCUI in RxNorm.
- Merged into another RXCUI – When two concepts are determined to be synonymous, they are merged together. Once merged, only one of the RXCUIs remains active. You can find a record of these merges in the RxNorm history files (e.g. RXNCUI.RRF, RXNATOMARCHIVE.RRF, RXNCUICHANGES.RRF).
- Retired – If a concept is created in error, it may have been retired without merging into another concept. As with merged RXCUIs, look in the history files for a record of these changes.
- Not a valid RXCUI – If you cannot find the RXCUI in RXNCONSO.RRF or the history files, your RXCUI is not a valid RXCUI. RXCUIs with an NLM-created RxNorm normalized name are documented in the RxNorm files. However, RXCUIs for products without an RxNorm normalized name are considered out of scope and are transient and can change or be deleted by the source vocabulary provider at any time.
There are several reasons why an RXCUI does not have an associated RxNorm normalized name.
- Out of scope – Some information provided by source vocabularies is out of scope for RxNorm. While this information is grouped into concepts and given RXCUIs, RxNorm normalized names are not created for this information.
- Ambiguous – Some information provided by source vocabularies are too vague and for a specific RxNorm normalized name to be assigned.
- Base atom – A Base atom often lacks an RxNorm normalized name because a Base atom contains NDCs representing several different drug products. For more information about Base atoms, see Section 9: Duplicating Source Asserted Atoms (with NDC conflicts) of the RxNorm Technical Documentation.
Yes, the RxNorm dataset contains limited drug classification information, primarily from the following three source vocabularies: Anatomical Therapeutic Chemical Classification System (ATC); Veterans Health Administration National Drug File (VANDF); and a subset of Medical Subject Headings (MeSH).
The database queries to obtain classification information from the RxNorm data files can be long and cumbersome. To assist users, the RxClass Browser, RxClass API, and several preset workflows in RxMix provide drug class information, some of which are not available in the RxNorm data files. For more information about RxClass, see the RxClass Overview.
Learn more about RxMix on the RxMix Tutorial page. To see existing workflows in RxMix:
- Go to: https://mor.nlm.nih.gov/RxMix/.
- Click on “From workflow library”.
- Browse the workflows of interest in the pop-up screen.
Familiarity with the RxNorm data and file structure will be imperative in querying the data effectively. Review the RxNorm Technical Documentation, particularly the appendices, and the RxNorm Overview (i.e. relationship diagram under “What does the RxNorm model look like?”) for useful information.
Here are links to specific pages to help you get started:
- Appendix 5 - RxNorm Term Types (TTY)
- Appendix 1 - RxNorm Relationships (RELA)
- Appendix 4 - RxNorm Attributes
- Section 14.2 Sample Database Queries
- Section 3.1 Source Vocabularies (i.e. individual vocabulary pages (e.g. ATC) contain “Data Examples with MySQL Queries”)
Alternatively, the RxNav page provides web-based resources, such as application programming interfaces (APIs), to browse and retrieve RxNorm data.
There is no charge for licensing RxNorm; however, using proprietary data within the full RxNorm dataset may require additional licensing from those source providers. Read the UMLS Metathesaurus License Agreement for more information. Visit the UTS to request a license.
The RxNorm source vocabularies are listed in Section 3.1 Source Vocabularies of the RxNorm Technical Documentation. Contact a source vocabulary directly for additional clarification on using their data. Contact information is available in Appendix 1 of the UMLS License agreement.
Last Reviewed: November 18, 2019