EUREKA! Easy way to actually FIND and DELETE Windows 10 iTunes 12.13.2.3 Duplicate Files in Music library
I have been using iTunes on Windows for a LONG time (multiple libraries, computers, decades...) and
I think I may have actually finally discovered a simple way to find actual duplicate file in your iTunes library:
(1) Start iTunes
(2) Songs -> File -> Library -> Show Duplicate Songs
(3) File -> Library -> Export Playlist -> Music.txt
(4) Create a new Excel Spreadsheet and copy and paste the entire Music.txt file into a worksheet
(5) Select all rows and then select Data -> Sort (Check box "My data has headers") -> Column Sort by Size -> Sort on Cell Values -> Order Smallest to Largest
(6) Select column K -> Home -> Conditional Formatting -> Highlight Cell Rules -> Duplicate Values -> Format Cells that contain: Duplicate values with Light Red Fill with Dark Red Text -> OK
(7) Scroll through entire file and for each pair of duplicate entries in column K that is an EXACT MATCH (Name, Artist, Composer, Album...) simply delete one of the corresponding duplicate files in iTunes remembering to select Keep file option
(8) After working through the entire list, close and reopen iTunes and repeat steps (1) to (7) one more time to ensure all duplicates are gone
iPhone 13 mini, iOS 17