We are not able to perform Excel file masking in CA FDM (Fast Data Masker) tool. There is a separate folder for dm.txt file, however, it is showing that the file does not exist.
The FDM connection profile is using EXCEL FILE in DBMS option. The file name we are trying to mask is <filename>.csv
FDM 4.9.1+
Excel file format names must end with .xlsx
A CSV file is not an Excel formatted file. This is why it is not showing up when you choose this option.
Though Excel can open a CSV and make changes to it, a CSV file is not a native Excel format.
To use FDM to mask this file you would need to open the CSV file in Excel and then do a save AS to save as an Excel workbook to then be able to use the Excel masking function in FDM.
To use FDM to mask a CSV file directly, change the DBMS type to "File" and map the fields in the GUI Interface, as shown below: