As an alternative to using NMD-Certified software, you can create your own NMD data file using a spreadsheet. Excel templates are available for NMD Versions 2.0/2.1 and NMD Version 3.0/3.1 files, although you are not required to use them. However, all files must conform to the requirements outlined for either NMD Version 2.0/2.1 or NMD Version 3.0/3.1, as described in the file specification attachments in the NMD Data Submission Overview

All data files must be either pipe-delimited text or Excel (xlsx) files. Once you have populated the file with data, save it to your computer as a Excel (xlsx) file or convert the file to a .TXT File. Make sure the file conforms to the NMD data file format for NMD Version 2.0/2.1 or NMD Version 3.0/3.1 (see attachments in NMD Data Submission Overview).

Follow the steps described in Data File Uploads to upload the file, check the status of the file, and view rejected records. You should also review the more detailed Summary of Uploaded Data report generated for each data upload. This report provides detailed counts of data for each variable, including errors and missing data.

Previous article: Create a File Using NMD-Certified Software