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 24m 10s ago
Exports and then re-imports selected tracks' artwork
downloaded 31m 12s ago
Set the Plays of selected tracks.
downloaded 48m 52s ago
Displays files in iTunes Media folder not in iTunes track library
downloaded 49m 49s ago
Finds and displays any empty folders in the iTunes Media folder
downloaded 55m 18s ago
Move selected playlists to a new or existing folder
downloaded 56m 7s ago
Perform tasks on a batch of playlists; rename, delete, duplicate, merge, more