Overview
Duplicate Cleaner 5 can save and load CSV (Comma Separated Value) text files. This can be useful for exporting to view in another program, such as Microsoft Excel.
Duplicate Cleaner can import Duplicate files or Unique/Remaining file lists. It doesn't currently import Duplicate folder lists.
The required columns are:
filename,groupno,size,datec,datem,chk,protect,hardlink,folder_name,folder_zip_pointer,device_id,device_type
With optional columns after. Common ones include:
hash,hashquick,duration,width,height
The presence of the Width/Height and Duration columns determine whether the list is loaded as an Image, Audio or Video mode scan.
It will load all user columns in, including any custom columns you wish to add. For instance, you could create a new calculated column in Excel (e.g. Files not containing the folder name='N'), re-import the CSV and use the new column in the Selection Assistant.
Notes:
A groupno of 0 indicates a unique/remaining file.
The folder_zip_pointer is the depth of the path (in characters) inside the zip file or archive (-1 if not a zip)
The device_type is either blank, V for a virtual folder or M for an MTP/Media device.