Duplicate Files Finder Tool

About the tool:

Duplicate Files Finder Tool is an MS Excel based tool to identify duplicate files exist in your system or shared folder. The tool takes a base folder path as input and list down all duplicate files in the folder and sub-folders. It has capability to find duplicate files by comparing the names and their size.

Tool Features:

  • Compare file names for duplicate after removing version numbers
  • Allows file size variations setting to compare files with different file sizes
  • Moves identified duplicate files to another folder

Benefits:

  • Save time to identify duplicate files
  • Save system or shared folder space

System Requirements:

  • You need to have installed version of MS Excel 2010 or above

How to use this tool:

 

  1. Open the tool and you will see below screen
    Duplicate Files Finder Tool
  2. If the macros are disabled, click on Enable Content button
    Duplicate Files Finder Tool
  3. Select the base folder path from which you want to identify duplicate files
    Duplicate Files Finder Tool
  4. There are two settings through which you can control identifying duplicate files logicFile Size Variation Allowed: Through this setting you can control the variations allowed in file size while comparison. For example, a file named Test.doc (118 KB) and another one named Test.doc (23 KB) can be found as duplicate if the file size variation allowed is 100 KB
    Duplicate Files Finder ToolTo change this setting, click on the dropdown and update the setting as required
    Duplicate Files Finder Tool

     

    Remove Characters from File Name before Matching: Through this setting you can remove version details from the file name before comparing it’s name. For example, a file named test v1.0 and test v2.0 may be duplicate
    Duplicate Files Finder Tool

    To change this setting, click on View Setting button
    Duplicate Files Finder Tool

    Here you can mention the characters to be removed from file name before comparison
    Duplicate Files Finder Tool

  5. Once you are done with the initial settings, click on Start Finding Duplicates button
    Duplicate Files Finder Tool
  6. Depending on number of files available for analysis, tool may take some time for analysis and identifying duplicate files. Once done, it will filter them and show you the result
    Duplicate Files Finder Tool
  7. If you want to move the duplicate files in another folder then select the folder where you want to move these files
    Duplicate Files Finder Tool
  8. Now select Yes for the files which you want to move
    Duplicate Files Finder Tool
  9. Once done, click on Move Duplicate Files
    Duplicate Files Finder Tool
  10. Click on Yes to confirm the action
    Duplicate Files Finder Tool
  11. Tool will now start moving the files to selected folder and show you a confirmation message once action is complete
    Duplicate Files Finder Tool
  12. You can see the action taken by the tool in Status column as well
    Duplicate Files Finder Tool