Clearinghouse Data File Format

DrugTestNetwork  Clearinghouse Export Format: Include Company Row / Column (For Your Convenience)

DrugTestNetwork exports DOT Clearinghouse batch query data in the expected column order required for upload.

The DOT requires Text Tab-Delimited – NOT CSV.  By default, DrugTestNetwork generates the file as CSV so it opens easily in Excel for review when you click on the file from the downloads folder.

Why You May See an Extra Company Row or Column

During export, you may choose to include the Company (Employer) name for your convenience:

• Company name as a row above the listing: Helpful for printing or quick visual confirmation of the employer tied to the export.
• Company name as a trailing column: Helpful when exporting multiple employers in one request, so you can filter and split the results in Excel.

Important: The extra row and/or column is provided for review and organization only
and is not part of the DOT Clearinghouse batch upload format.

Before Submitting to the DOT Clearinghouse

The DOT Clearinghouse batch upload will be rejected if the file contains extra rows, extra columns, or does not match the required format.

Validation Checklist

• Remove any extra header rows (such as a company name line above the data).
• Remove any extra columns (such as a trailing Employer/Company column).
• Confirm the file contains only the required Clearinghouse columns, in the correct order.
• Save the final file as Text (Tab-delimited) before uploading.

Excel: Save the File as “Text (Tab-delimited)”

After reviewing (and, if needed, splitting the file by employer), use the steps below to create a
Clearinghouse-ready upload file.

1. Open the export in Excel.
2. If you exported multiple employers:
   use the employer/company column (if present) to filter the sheet to one employer at a time,
   then copy the filtered rows to a new worksheet/workbook.
3. Remove non-Clearinghouse content:
   • Delete any company-name header row above the data.
   • Delete any extra trailing employer/company column.
4. Confirm the required Clearinghouse columns remain(and are in the required order).Tip: Make sure there are no blank columns and no additional notes in the sheet.
5. Go to File > Save As.
6. Choose a location and file name (recommended: include employer name and date).
7. In Save as type, select Text (Tab delimited) (*.txt).
8. Click Save.
9. If Excel shows a warning such as “This format only supports one sheet” or “Some features may be lost,”
   click OK or Yes to continue (this is expected for tab-delimited exports).