Read the NSN batch-report workbook

Application path: Main Menu → Search by NSN/NIIN → Create a Batch Report → Create Report → open the downloaded workbook.

After creating a batch report, open the downloaded .xls file in Excel or Google Sheets, then select a worksheet tab along the bottom. The selected sections determine which tabs appear. Read each value with its column heading; blank cells remain blank, and repeated item identifiers help keep rows with the right NSN.

The workbook screenshots and sample values below are from the established Guide examples dated October 11, 2026, using NSNs 6140014469506 and 8345002500919. They illustrate the worksheet layout and field meanings. Your output depends on your NSN list and the report sections you selected. See the full batch-workbook walkthrough and the SalesHelp batch form and safety instructions.

Which worksheets to expect

The catalog/reference example selected MCRL, ML-C, Technical Characteristics, Associated Docs, Substitutes, and Moe Rules, together with the required catalog header. It showed these tabs: MCRL, TechChars, SegH, MoeRules, AssociatedDocs, AltSubs, and NSN. The five-year-award example selected only Award History 5 Years with the required catalog header; it showed AwardHistory and NSN. Optional tabs appear when selected and when the report returns matching rows.

Read the worksheets

MCRL — part-number references

Guide workbook example: MCRL worksheet

Column What it shows
nsn Stock number used to identify the item.
fsc Federal Supply Classification portion of the stock number.
niin National Item Identification Number portion of the stock number.
Item Name Catalog name of the item.
Part Number Part number recorded for the item.
CAGE Entity code associated with the reference.
Company Company name associated with the CAGE.

Compare the part number and CAGE together when checking a reference.

TechChars — technical characteristics

Guide workbook example: TechChars worksheet

Column What it shows
nsn, FSC, NIIN Item identifiers.
Required Details Characteristic or requirement name.
Details Data Recorded response for that characteristic.
Order ID Identifier attached to the characteristic row.

Read dimensions, units and qualifiers with the corresponding requirement.

SegH — management-list records

Guide workbook example: SegH worksheet

Column What it shows
FSC, NIIN Identify the item.
MOE Major Organizational Entity or service-agency context.
SOS Source of supply.
AAC Acquisition Advice Code.
QUP Quantity per Unit Pack code or value.
UI Unit of Issue code.
UNIT PR Management-list unit price; not an award-history price or supplier quote.
SLC Shelf Life Code.
CIIC Controlled Inventory Item Code.
REP CD Repairability code for the management record.
MCD Service-specific Management Control Data.
EFF DATE Management-record effective-date value.
USI SVC CD Stored using-service code.
UI CONV FAC Unit of issue conversion factor. Confirm both units before calculating.
PHRS CD COUNT Phrase-code count; a blank value does not show how many management phrases the item has.

These are catalog codes. Use an applicable catalog reference to interpret them; multiple rows can represent different management contexts.

MoeRules — management and acquisition rules

Guide workbook example: MoeRules worksheet

Column What it shows
NIIN National Item Identification Number.
MOE Rule Organization or service rule identifier.
DSOR Depot Source of Repair code.
AMC Acquisition Method Code.
AMSC Acquisition Method Suffix Code.
NIMSC Nonconsumable Item Material Support Code.
IMC Item Management Code.
IMCA Stored item-management activity code; the value does not name an organization.
AAC Acquisition Advice Code.
Collaborators, Receivers Stored collaborator and receiver codes.

Decode code values with an applicable catalog reference. A code alone does not identify an organization or establish approval to offer a part.

AssociatedDocs — document references

Guide workbook example: AssociatedDocs worksheet

Column What it shows
NIIN Item associated with the document record.
Spec No Specification or document identifier.
Doc Type Document reference type, when provided.
Type ID Document type identifier, when provided.
Doc Link View Document link to the referenced file.

Confirm the document number and revision against the current requirement before relying on it.

AltSubs — substitute relationships

Guide workbook example: AltSubs worksheet

Column What it shows
(blank heading) The first column has no heading in this workbook.
FSC Class of the recorded replacement stock number; it may differ from the original item's class.
NIIN Original item's National Item Identification Number.
Repl NIIN Replacement item's National Item Identification Number, if present.
ISC Stored interchangeability or standardization relationship code.
Std Orig Origin code for the standardization decision.
Std Date Date shown for the standardization decision.
Status NIIN status code.

Confirm the relationship and decode its status before treating an item as a substitute. A catalog relationship alone does not approve an alternative offer.

NSN — catalog header

Guide workbook example: NSN catalog worksheet

The NSN tab accompanies both examples. Its first column has no heading.

Column What it shows
name Catalog item name.
nsn National Stock Number.
CCF Item criticality code; consult the catalog value before using it in a specification.
TOII Item-identification type indicator; use the applicable catalog definition before interpreting its value.
RPDMRC Reference or Partial Descriptive Method Reason Code; it qualifies how the item was identified and is not source approval.
DEMIL Demilitarization code; decode the value before applying handling requirements.
DATE ASSIGNED Stock-number assignment date, not a procurement or drawing date.
HMIC Hazardous Material Indicator Code; confirm actual hazards in current documents.
ESD EMI Electrostatic-discharge/electromagnetic-interference code; decode before specifying handling.
PMIC Precious Metals Indicator Code; it is not a physical metal quantity.
ADPEC Automated Data Processing Equipment Identification Code; decode the category.
lastprice Last-award price shown when available; it is not a supplier quote. Compare its unit, date and quantity with the award record. It differs from UNIT PR and award-row Price.

For item-specific catalog context, continue to the SalesHelp catalog and management-rule guide.

AwardHistory — five-year award rows

Guide workbook example: AwardHistory worksheet

Column What it shows
NSN, fsc, niin Award item's stock number, class and nine-character identifier.
name Catalog item name; it may be blank, so use the NSN to identify the item.
Contract Contract identifier. Keep it with CLIN when tracing an award row.
CLIN Contract line item number.
cage CAGE code for the recorded recipient.
quantity Awarded quantity. This workbook has no unit-of-issue column, so check the award before comparing prices.
Price Award unit price as displayed; compare with the individual award record before relying on it.
Total Award line value as displayed; it may not equal quantity multiplied by displayed Price.
Award Date Award-action date, displayed as month/day/year; the five-year option uses this date.
company Recorded recipient name.
Modified Y indicates the workbook adjusted displayed price values; N means it did not. This does not mean the contract was modified.

Guide workbook example: NSN tab accompanying award history

Blank cells are blank values, not zero. Compare units and the corresponding award record before comparing amounts. For the SalesHelp on-screen award route, see NSN award history.