For macOS 10.10 and later only. This applet checks your entire iTunes library for missing and presumed dead tracks--those tracks that iTunes is unable to associate with a file and which are listed in iTunes with a "!"--and can create a text file listing these tracks by last known File Path (if available), Song Name, Artist and Album, which you can view using TextEdit.
Also see Music Folder Files Not Added
To find and delete dead tracks see Super Remove Dead Tracks.
Watch the video demo below.
iTunes can't find the files pointed to by the Location property of these track entries.
Perhaps Also of Interest...
downloaded 6m 5s ago
Sort purchased tracks into discrete playlists by name or Apple ID
downloaded 2h 16m 25s ago
Change file type to make selected AACs bookmarkable
downloaded 2h 16m 31s ago
Perform search-and-replace on text in your choice of tags
downloaded 2h 16m 44s ago
Set choice of various number tags of selected tracks incrementally
downloaded 2h 16m 52s ago
Append user-entered text to beginning or ending of selected tag of each selected track
downloaded 2h 17m 7s ago
Applet assists with swapping, copying, appending data between track tags