For macOS 10.12 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 19m 35s ago
Gather audio tracks whose files contain no artwork metadata
downloaded 20m 7s ago
Detects if a track's file's metadata contain image information
downloaded 20m 57s ago
Set the Plays of selected tracks.
downloaded 22m 17s ago
Applet compels you to rate unrated current track
downloaded 23m 31s ago
Delete characters from the beginning or ending of selected tracks' name, artist, album, comments, composer, or show tags
downloaded 23m 44s ago
Copy chosen tag info from one set of tracks to a different set of tracks