How to remove deleted files from your iTunes library

I use a little tool to manage my MP3s called “MP3 tag tools“. It’s quite powerful, it allows you to mass edit some or all ID3 tag fields, fill them from a file name scheme and vice versa (create folder structures and/or file names from the ID3 tag fields). Now when I recently cleaned up my collection using that tool, I noticed that I had about 400 double entries. I just didn’t notice before because the file names were different. Now as this tool tried to rename the files and put them in the appropiate subfolders, it threw error messages that existing files can’t be overwritten.

So I had 400 files that I could safely delete, which I did. Now I had 400 dead entries in the iTunes library (marked with a !) which I wanted to get rid of easily. Apparently, iTunes does not have a function to remove dead/broken/orphaned entries, I’d have to try to play every song from my playlist so iTunes would mark all missing entries and then… then what? iTunes doesn’t even let me sort by the ! column. That’s really stupid.

There is a solution though:

  1. Create a smart playlist with the criterion “Artist” is not “xxxyyyzzz” (or some other random string that does not occur as artist in your mp3 collection). Then name this smart playlist “all entries”. This way, we get a smart playlist with all database entries, working and broken.
  2. Create a static playlist called “working entries”.
  3. Open the “all entries” playlist, select all (ctrl-a/option-a) and drag the selection to the “working entries” playlist. iTunes will not copy dead entries, so now we have a list with everything and another with only the working ones. We need to substract them from each other. This is how:
  4. Create a smart playlist with the following criteria: “Playlist” is “all entries”, “Playlist” is not “working entries”. Check that all rules apply, not any rule. And dang! We just created a playlist of broken database entries. In this playlist, select all (ctrl-a/cmd-a) and hit shift-delete (alt-backspace on macs). iTunes will ask you if you want to remove the selected items from the iTunes library. Of course you want to!

Another way would be to deleteĀ My Music\iTunes\iTunes Music Library.xml and have iTunes re-import all the songs, but that would delete all the other information too, like number of skips, rating etc. so better not do it.

90 Comments

  1. Nice blog. Sir i am using the old version of iTunes and i tried to remove duplicate songs but i was unable. So can you suggest me a better idea that can help me to do that?

  2. Working thanks. But, am not able to see delete option to delete broken entries from smart playlist as “broken entries”. Please help me.

  3. OMG! I am a dj on a commercial radio, and to forward announce something in itunes that wasn’t there was common with 100+ broken links!!! Thanks so so so much! You have made my day/week/year/millenium!!

  4. Genius! I paid for some software (there wasn’t a demo) which took nearly a minute to remove EACH broken link from iTunes. With 4000 broken links that was a bit too slow! At least the developers refunded me. But your method is sensational! Thank you!

  5. If I try to delete songs from a playlist (iTunes 10, OS X 10.6) this beauty of program would just delete the titles in teh playlist … NOT in the library.
    How I love apple.

    Any idea? Is this a iTunes10 issue?

  6. Thank you for saving me weeks/months of trying to find and delete these files by hand. When I return the hard drive that I accidentally erased with all of her music on it with some semblance of order, she’ll thank you also!

Leave a Reply

Your email address will not be published. Required fields are marked *