Input File Layout

You supply the name for the input file. The input file can be a fixed-format file, a comma-separated file, or an ADP-formatted file.

If the file is a fixed-format file, you must fill every position with either an appropriate character or a space. It is not necessary to zero-fill numbers; you can use spaces to maintain the proper format. If the input file is a comma-separated file, you do not need to fill every position. However, the file must contain the correct number of commas. Single character values in the file should be in uppercase.

You will need to provide the values in some fields regardless of the settings in Costpoint. For existing employees, the only unconditionally required fields are Record Code and Employee ID. For new employees, refer to fields that are marked as Required in the Required Optional for New Employees column.

Note: You cannot use commas in the Notes field.

Note: The input file layout may contain fields that are available only in Costpoint Advanced. If you are using Costpoint Essentials, these fields are excluded from the import process and may be left blank or null when you create the input file.

Input File Excel Template

For Costpoint 2025.x, get the latest Excel template file specifically designed for this preprocessor from the Costpoint Preprocessor Guides page on the Deltek Learning Hub.

For Costpoint 8.1, you can download the input file from the Developer Resources page in the Costpoint Information Center.

Templates for the other Costpoint preprocessors are available at these same locations.