You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

đź“° Newsroom Update

Billie Eilish is Apple Music’s Artist of the Year for 2024. Learn more >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

Posted on Aug 10, 2024 4:19 AM

Reply

There are no replies.

EUREKA! Easy way to actually FIND and DELETE Windows 10 iTunes 12.13.2.3 Duplicate Files in Music library

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.