Duplicate Cleaner 5 Manual.
Menu
Index
  • CSV files

CSV files

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.
 
CSV files can be exported from the File Removal Tab.  CSV Files can be imported from the Load and Save scans section in the Home tab.
 
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.