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.
iTunes can't find the files pointed to by the Location property of these track entries.
Perhaps Also of Interest...
downloaded 56s ago
Batch-change the Album Rating for the albums of selected tracks
downloaded 1h 11m 16s ago
Sort purchased tracks into discrete playlists by name or Apple ID
downloaded 1h 23m 15s ago
Set the Plays of selected tracks.
downloaded 1h 26m 31s ago
Convert selected tracks and export the converted files to a new folder
downloaded 1h 35m 45s ago
Exports and then re-imports selected tracks' artwork
downloaded 1h 38m 59s ago
Remove iTunes tracks disassociated from files