HCM Data Loader - Dat File Editor

Summary:

Excel spreadsheet with macros for opening and saving pipe-delimited files.

Content (required):

The attached Excel spreadsheet can be used to easily open, edit and save HCM Data Loader pipe-delimited files. HCM Data Loader date formats and number values are retained, unconverted.

To use

• Download and open the attached spreadsheet, enabling macros.
• On the 2nd worksheet, use the 'Click to Open HDL DAT File' button to select the file to open. Only files with a .dat extension are displayed in the file search window.
• On opening a file, you're navigated to the first worksheet with each attribute value placed in a separate spreadsheet column.