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/2.2 and NMD Version 3.0/3.1/3.2 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/2.2 or NMD Version 3.0/3.1/3.2, 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/2.2 or NMD Version 3.0/3.1/3.2 (see attachments in NMD Data Submission Overview).

NOTE: When uploading an Excel file, please ensure it does NOT have any formulas in the cells. This will cause the file to reject and potentially not allow the log file to be accessed.

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