Top 2 Approaches to Find and Delete Duplicate Excel Files from PC

In today’s digital work and life, Excel files have become one of the most widely used document types for storing financial data, work reports, personal budgets, etc.

When you create, edit, share, and back up Excel files on your PC, duplicate Excel files inevitably accumulate quietly in different folders, drives, and subdirectories.

These duplicate files, often with suffixes like “Copy (1),” “Final Version,” or “Updated,” or saved with slightly different names but identical content.

Over time, these seemingly harmless actions can result in dozens or even hundreds of duplicate Excel files scattered across your computer, consuming several gigabytes of storage space and slowing down file searches.

More importantly, having multiple identical Excel files can easily lead to opening outdated versions for editing, causing data inconsistencies, lost work, or chaos when sharing files.

Therefore, it’s time to remove duplicate Excel files from PC to free up disk space and protect data accuracy.

How to find duplicate Excel files? This article provides a complete step-by-step guide on how to find and delete duplicate Excel files from PC.

How to Delete Duplicate Files on SD Card in Windows?

Learn how to find and remove duplicate files on SD cards step by step. This guide offers 2 approaches to do that.

Read More

Method 1. Delete Duplicate Excel Files Using MiniTool Partition Wizard

MiniTool Partition Wizard is a comprehensive disk management tool for Windows designed to optimize disk performance and manage storage.

Unlike manual searches, its Duplicate Cleaner feature identifies duplicates by content-based file hashing (MD5/SHA-1) rather than just filenames, ensuring you find truly identical Excel files, even those renamed or saved in different folders.

This software is perfect for you if you have multiple files scattered across multiple drives or deep subfolders.

Now, download and install MiniTool Partition Wizard on your computer.

MiniTool Partition Wizard FreeClick to Download100%Clean & Safe

Step 1. Launch this software to enter its main interface. Then click Duplicate Cleaner on the top toolbar.

Step 2. In the new window, configure the following scan settings for precision, and then click Scan Now.

• Select scan locations: This tool will list all detected drives. You can click the Remove icon to remove drives you don’t want to scan or click the Add button to choose the specific folders for focused scanning.
• Filter for Excel file types: Under the Filter section, choose the Documents option. Then, in the Include section, only leave these Excel file extensions: .xlsx, .xls, .xl; .xla; .xlt; .xlm; .xlc; .xlw.
• Advanced settings (optional): Set a file size range, choose a hash comparison method, and set file protection options.

Step 3. Once the scan finishes, this tool displays all duplicate Excel files. You can click Expand All to see the full path. Then click Smart Select and select different selection methods according to your needs.

Step 4. Click Delete Selected Files to choose different deletion options. Then click OK to start the deletion of duplicate files.

Method 2. Delete Duplicate Excel Files Using File Explorer

If you have a small number of Excel files or don’t want to use third-party tools, manually finding and deleting duplicate Excel files using Windows File Explorer is a safe and convenient option.

Now, follow the steps below to delete duplicate Excel files using File Explorer:

1. Press the Windows + E key to open File Explorer.
2. Navigate to the drive or folder you want to scan. In the top-right Search bar, type .xlsx or .xls to list all Excel files.
3. Once the results appear, adjust the File Explorer view to spot duplicates easily. Click the View tab at the top, select Details, then click Sort by and choose Name. This group files with identical or similar names together.
4. Look for files with the same name but different suffixes like “(1)” or “- Copy”. Check the Size and Date modified columns. If two files have the same size, they are likely duplicates.
5. After finding the duplicate Excel file, right-click it and choose Delete.

Why Do Duplicate Excel Files Accumulate on Your PC?

Duplicate Excel files often accumulate on your computer for the following reasons:

• Manual copying and pasting: This is the most common reason. When you want to back up an Excel file or share it with others, you often copy the file to another folder, desktop, or drive without renaming it, thus immediately creating duplicate files.
• Multiple savings: People often save new versions of Excel files with minor modifications (e.g., “Report_2024_V1”, “Report_2024_V2”) instead of overwriting the original, leaving older versions unused but still saved.
• File sharing and downloading: Receiving the same Excel file via email, cloud storage, and USB drive, and then saving each copy separately, can result in identical files appearing in different locations.
• Backup and synchronization redundancy: If configured incorrectly, automatic backup software or cloud sync tools may save extra copies of Excel files, storing duplicate files locally or in sync folders.
• Temporary recovery files: When Excel crashes, it creates auto-recovery files. If you don’t properly remove these files after recovering your work, they will remain on your drive.

How to delete duplicate Excel files from PC? This post offers 2 methods to do that.Click to Tweet

Delete Duplicate Excel Files from PC FAQ

Bottom Line

Duplicate Excel files can waste storage space, reduce work efficiency, and put important data at risk. This post offers 2 methods to delete duplicate Excel files with File Explorer and MiniTool Partition Wizard. Among them, MiniTool Partition Wizard is a better choice with fast and simple operation.

For any questions or suggestions about MiniTool Partition Wizard, contact us via [email protected]. We’ll reply as soon as possible.