HCM Data Loader - Dat File Editor
Excel spreadsheet with macros for opening and saving pipe-delimited files.
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.
- 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.