While it is not required that you enter information into all of the columns in the Standard Template, the column headers still need to be included in your excel file. For example, if your company does not include employees’ middle initial information, you can leave the “Middle Init” data fields blank; however, you should not delete the column itself or its header.


To correct your data file:

  1. Download the latest version of the Standard Templates, available in the Data Management module under the “Manage Templates” tab. Click either the “Get the Standard Employee Template” or “Get the Standard Dependent Template” button, depending on which type of source file you are loading.
  2. Make sure your columns are in the exact order as the standard template, and that there are no extra columns. Then copy and paste the column headers from the Standard Template into your data file. This will ensure your headings match the expected headings.
  3. Attempt your data load again. On the Upload screen, under “Select Template” be sure to pick the appropriate standard template (Employee Template OR Dependent Template).