Duplicate Files Finder Tool


This tool helps you 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. You can also customize the tool to allow removing version name from the file name before comparing. For example File v1.1 and File v1.2.

Tool can remove version details from file name and catch duplicate files:
Duplicate Files Finder Tool
Setting to Remove Characters from File Name:
Duplicate Files Finder Tool
You can also define variation allowed in the file size for comparison. For example File v1.1 (475 KB) and File v1.1 (539 KB)
Duplicate Files Finder Tool

Follow the below steps to use this tool:

Step 1: Open the tool and you will see below screen
Duplicate Files Finder Tool
Step 2: Browse the root/base folder in which you want to find duplicate files
Duplicate Files Finder Tool
Step 3: If you want to allow some variation in the file size then update variation settings
Duplicate Files Finder Tool
Step 4: Verify or update the settings to remove version details from the file name before matching
Duplicate Files Finder Tool
Step 5: You may add more combinations based on your requirements. Few have been done for you
Duplicate Files Finder Tool
Step 6: Click on ‘Back to Home Page’
Duplicate Files Finder Tool
Step 7: Now you are ready to use the tool and find duplicate files. Click on ‘Start Finding Duplicates’ button
Duplicate Files Finder Tool
Step 8: Tool will now start finding the duplicates. You will received a confirmation message once the task is completed
Duplicate Files Finder Tool
Step 9: You will notice that all the duplicate files have been automatically filtered for you
Duplicate Files Finder Tool
Step 10: Since tool cannot decide which file you may want to keep and which you may want to move/archive; hence you need to update column G (Move Files?) as Yes or No so that tool can move the files which are marked as Yes to the selected folder
Duplicate Files Finder Tool

Note: To make your job little easy, we have enabled hyperlinks to open the file. To open the file, click on any of the Original File Name

Duplicate Files Finder Tool
Step 11: Before you proceed, don’t forget to select the folder where you want to move the files marked as Yes
Duplicate Files Finder Tool
Step 12: Now click on ‘Move Duplicate Files’ button
Duplicate Files Finder Tool
Step 13: Tool will now start moving the files. You will receive a confirmation message once the task is completed
Duplicate Files Finder Tool
Step 14: You can refer the status column to check if all actions have been taken
Duplicate Files Finder Tool
Congratulations you are now ready to use the tool.
Prerequisite:

You need to have installed version of MS Excel 2007 or above

Limitations:
  1. As the number of files increase, tool may take more time to complete the analysis and find duplicates

  2. Tool does not have capability to delete files

Add To Cart
VBA Tips you Must Know – Part 1
VBA TRICKS
Excel VBA Tips you Must Know – Part 1

Here we are coming with one more exciting post which can help you to solve very basic but very important problems while writing VBA codes.

How to use Excel Workday Formula in Excel
DATA ANALYSIS TRICKS
EXCEL FUNCTION – WORKDAY

Are you working today? or Do you have Work Off or holiday today?  I am asking this question because I am gonna tell you the most commonly used function in Excel “Workday”. “Workday” as name suggest that it brings the day when you will be working or you are expecting …

Subtotal Function Excel
DATA ANALYSIS TRICKS
Excel Function – SUBTOTAL

Excel Function “Subtotal” is most commonly used formula in excel and it can make your work easy while performing simple mathematical calculations because of variety of features like: – You can use this function for different purposes instead of multiple functions i.e. SUM, AVERAGE, COUNT, MAX, MIN, Standard Deviation etc. …

error

Like the Article? Please spread the word :)

Facebook
Facebook
YouTube
YouTube
Pinterest
Pinterest
LinkedIn