I had a similar requirement where duplicate records were spread across multiple Excel files. Initially, I tried handling them manually, but it became difficult to compare data across all the files. I eventually used SysTools Excel Duplicate Remover tool, and it helped me clean the duplicate records from multiple Excel spreadsheets in one go. The process was much faster, and I didn't have to spend time reviewing each file individually.